Setting Windows To Prefer IPv4 Over IPv6

This post is a bit different from my usual SQL Serer posts, I recently hit a problem where a legacy...

SQL Server Dedicated Admin Connection and Why You NEED It!

DAC or Dedicated Admin Connection is one of those things you don’t know you need until it’s too late.

What is...

SQL Server Advanced Aggregations Part 3 GROUPING/GROUPING_ID

This post is part 3 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...

SQL Server Removing Outliers With Standard Deviation

When running aggregations for reporting in some situations outliers can throw out the numbers.
For example lets say we have a...

SQL Server Minimum Memory Setting

There is almost never a reason to set this setting unless you’re running other apps on the same server as...

SQL Server Advanced Aggregations Part 2 ROLLUP and CUBE

This post is part 2 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...

SQL Server Advanced Aggregations Part 1 Grouping Sets

This post is part 1 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...

SQL Server Nested Transactions Probably Don't Work How You Think

SQL Server allows you to nest multiple transactions but the results of doing so are completely not obvious.
Take the following...

SQL Server and Evil Greedy Data Types

In a recent post, I talked about SQL Server reads and how the data is stored in pages. One of...

What Do Read Counts On Your SQL Server Execution Plans Even Mean?

If you’ve ever spent any time looking at execution plans you will have almost definitely noticed all the read counts...