Adding every column with INCLUDE feels like a free speed-up. Here is a small demo of the space, reads and writes you pay for.
SQL SERVER- High CPU and Transaction Type WorkFileGroup_fake_worktable and Workfile
Workfile and WorkFileGroup_fake_worktable were clues in a customer high-CPU investigation. I correlated them with queries and plan evidence.
Which is Faster – INSERT INTO SELECT or SELECT INTO? – Interview Question of the Week #187
Which is faster, INSERT INTO SELECT or SELECT INTO? A client moving large data between tables asked me, and here is what we found when we tested both.
What is Lock Pages In Memory? – Interview Question of the Week #186
What is Lock Pages in Memory? It keeps data in physical RAM instead of paging it to disk, and here is the gotcha and how to enable it step by step.
Listing Server Credentials and Where They Are Used
Credentials hide their secrets but still tell you who depends on them. Build a small demo and follow a credential to its login, proxy and job step.
How to Find Cardinality or Uniqueness for any Column? – Interview Question of the Week #177
What is Cardinality, and how do you find it for a column? This simple script shows the percentage of unique values, using an AdventureWorks table.
SQL SERVER – How to Know Transaction Isolation Level for Each Session?
An outsourced app had teams using different coding standards, and performance suffered. Here is how to find the transaction isolation level of each session.