In this post I cover some unpleasant side-effects of using heaps in SQL Server for anything else than staging tables. In the past couple of months I’ve been running into …
Tag:
indexes
-
-
In this post I cover ways to fix performance problems caused by implicit conversion when the query cannot be modified. What is an implicit conversion? I’ve already covered, in detail, …
-
In this post I show a few examples of implicit conversions in SQL Server and the impact they can have on query performance. Types of conversions in SQL Server If …
-
In this post I cover my solution to Brent Ozar’s recent query exercise, where we needed to optimize a query so that it’s able to find long values faster. Introduction …
-
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 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 …