Two scripts I share with clients all the time: they show the plan cache and data cache in memory, with cached plans by size and cached pages by table.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber
I strongly favor ORDER BY ColumnName over ORDER BY ColumnNumber. The performance is the same, but here is why column numbers are risky in real code.
SQL SERVER – Server Side Paging in SQL Server Denali – Part2
Part 2 of server side paging in SQL Server Denali: a reader keeps rows per page and page number in a table, and OFFSET and FETCH can read them from there.
SQLAuthority News – 18 Seconds of Fame – My PASS Experience
At SQLPASS someone asked me for 15 seconds on camera and I forgot all about it. Today I found out about that clip: my 18 seconds of fame from PASS.
Restoring to a Newer SQL Server Is a One-Way Trip
Plan a restore to newer SQL Server with the version boundary in mind, preserve the original backup, and understand options for moving data back.
SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2
A reader asked what happens when we create an index on the base table as well as on the view. Part 2 of my observation of the view looks at both cases.
geometry Collections: Read Members With STGeometryN
geometry Collections hold member shapes that STGeometryN can return individually. I extract a point and a line from one fixed collection. A third request deliberately exceeds its member count.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.