EugeneChiang.com

Upgrading SQL Server 2014 via Uninstall/Re-install

Process Detach databases. Uninstall SQL Server 2014 Install SQL Server 2016/2019 Reattach databases. Uninstall SQL Server 2014 (v12) To uninstall SQL Server instance, go to Control Panel and then Programs and Features. Select and right-click on Microsoft SQL Server 2014 and select Uninstall/remove. Upgrade to SQL Server 2016 (v13) SSMS Tool https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Upgrade to SQL... » read more

SQL Server Transaction Log Backup Errors

Common Transaction Log Failure Erros Make sure all databases in transaction log job are marked as Full backup. Make sure there is at least one successfully full database backup. Disable transaction log backup job when running a full database backup job. Back up the log Under the full recovery model or bulk-logged recovery model, if... » read more

Add Foreign Key

Drop Table

Cross Join

The CROSS JOIN joined every row from the first table (T1) with every row from the second table (T2). In other words, the cross join returns a Cartesian product of rows from both tables. In general, if the first table has n rows and the second table has m rows, the cross join will result in n... » read more

Split String Function

Returns a table based off of a delimited string

SQL to Open XML file

SQL to retrieve content of xml file.

Gathering SQL Server Index Statistics and Usage Information

After creating the indexes, we should proactively know which indexes are badly used, or totally unused in order to perform the correct decision to maintain these indexes or replace it with more efficient ones. Recall that removing the unused indexes or badly indexes will improve the performance of the data modification queries, that needs to... » read more

Fine Tuning Queries

Database administrators have to balance between creating too many indexes and too few indexes. For example, there is no need to index every column individually or involve the column in many overlapping indexes. They should also take into consideration that, the index that will enhance the performance of SELECT queries will also slow down the... » read more