This is just a brief post containing a script to get table sizes in SQL Server, along with some other information like table type, number of records, partition count, compression …
Monthly Archives
August 2023
-
-
In this post I’ll cover ways of speeding up SELECT COUNT as well as some myths about best practices when it comes to SELECT COUNT. SELECT COUNT use cases SELECT …
-
In this post I’ll cover a quick way to get access to SQL Server when you don’t have a login and don’t know the password for the SA account. I’ve …