I used generate scripts for a historical SQL Server 2017-to-2005 migration. It was a logical migration rather than a backward backup restore.
SQL SERVER – Simple Method to Find FIRST and LAST Day of Current Date
I calculate the FIRST and LAST Day of Current Date using explicit date boundaries. The historical sample starts on October 28, 2017.
SQL SERVER – Remove Duplicate Rows Using UNION Operator
The UNION operator removes duplicates from a query result without deleting source rows. I use a small example to show that distinction.
SQL SERVER – How to Fix log_reuse_wait_desc – AVAILABILITY_REPLICA?
A client’s database always showed AVAILABILITY_REPLICA in log_reuse_wait_desc of sys.databases. After quick research, here is what it means and how to fix it.
Find the Query Growing TempDB in SQL Server
To find the query growing TempDB, read the space each session has allocated and join it to its statement. This post separates temporary tables from spills, watches both live in a second window and shows the totals after a query ends. It ends with ways to fix a spill.
Where is the Default Settings for Backup Compression? – Interview Question of the Week #191
Where are the default settings for backup compression? The Back Up dialog shows three options. Here is where the server default lives and how to set it.
Estimated Completion Time for Backup, Restore and DBCC
The estimated completion time of a backup, restore or DBCC command is one query away. This post builds a monitor query on sys.dm_exec_requests and watches a backup, a restore and a DBCC check in a second window. It also covers STATS and the DBCC step name.