Get a List of Tables That Are Compressed
Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression enabled: Tested on SQL Server 2019.
Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression enabled: Tested on SQL Server 2019.
Recently when shrinking a SQL Server data file, I ran into the following error: File ID 3 of database ID 15 cannot be shrunk as it is either being shrunk by another process or is empty. DBCC execution completed. If …
When building out a new SQL Server to replace an existing SQL Server, the previous system may have been using DTC or the Distributed Transaction Coordinator. This needs to be done on both sides of the transaction, meaning both servers …
Configuring The Distributed Transaction Coordinator Read more »
I was investigating a slow sever recently and discovered almost a million files in the sql server error log directory. This contained job history and backup logs for many years. The error log directory is not a location that I …
How many files are in your SQL Error log directory? Read more »
Recently when doing a database upgrade for a client, I was informed that we had missed some user procedures, tables and functions in the master database. I needed a way to track all these down so that I could confirm …