T-SQL

Brent Ozar’s latest blog post contained a question that piqued my interest about a potential method to calculate the checksum for an entire row in SQL Server. The original question: …

This post contains a script I’ve put together to query database sizes in SQL Server along with some additional info like file counts per file types and their sizes in …

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 …

In this post I’ll cover ways of speeding up SELECT COUNT in SQL Server as well as some myths about best practices when it comes to SELECT COUNT. SELECT COUNT …

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 …

I’ve been looking in the past couple of weeks for posts testing large insert speeds in SQL Server between different scenarios, and was unable to find anything more recent that …

Since SQL Server Management Studio 19 has just been released last week, I’ve figured I’d take this opportunity to go through my configuration preferences. Update note 2024-06-17:These are my personal …

In this post I’ll demo how to use PowerShell to retrieve execution plan files from a SQL Server instance. It’s pretty much the same method I’ve used in PSBlitz to …

I figured I might get ChatGPT to write T-SQL, test out the results, and see how it compares to T-SQL written by a human. Warning: Do not run any of …

In this post I’ll go over the relationship between unique constraints and NULLs in SQL Server, and how you can have multiple NULLs in a unique constraint. What is a …