Planting a Debug Flag in T-SQL

Are you looking for a way to debug stored procedures in SQL Server? Keep reading for a technique that’s worked ...
Read more
Required SQL Indexes

If you talk to any data professionals about query performance, they’ll bring up indexes in the first few minutes. For ...
Read more
Delete Duplicate Rows in T-SQL

We don’t live in a perfect world, which means duplicate rows occasionally show up. Sometimes you just need to delete ...
Read more
Storing Big Ugly Tables

Have you ever had a big ugly table? A table with millions or even billions of rows. Perhaps you wanted ...
Read more
Generate Random Dates In T-SQL

Have you ever needed to create a random date in SQL over a group of rows? Whenever I build a ...
Read more
SQL Server Learning Resources

Do you feel overwhelmed by the volume of SQL Server resources? Where do you start? In this article, I offer ...
Read more