Check intelligent query processing by database compatibility level, scoped switches, and actual plan evidence before comparing servers.
Inline Table-Valued Functions: Parameterized Views That Stay Fast
Compare inline table-valued functions with scalar functions, preserve customer results, and inspect plans before claiming performance gains.
Wide Covering Indexes: The Cost of INCLUDE Everything
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.