The same query plan can sit in the cache many times when query text changes by a space, a letter case or a comment. See it, measure it and learn how to share one entry.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Best Value for Maximum Worker Threads – SQL in Sixty Seconds #170
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
SQL SERVER – Display Dates in Different cultures FORMAT
Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.
Rowstore to Columnstore: Replace the Clustered Index
Rowstore to columnstore is a change of the clustered index, and one command works in only one case. This post builds two tables of 600,000 rows, shows the error from DROP_EXISTING on a primary key, and converts each table the working way. It compares the sizes before and after.
Copy Database – SQL in Sixty Seconds #169
At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient.
Read-Ahead Reads in STATISTICS IO: What They Tell You
Interpret read-ahead reads in STATISTICS IO, compare isolated cold scans and seeks, and separate prefetch from storage-wait evidence.
9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168
This episode of SQL in Sixty seconds is very special as it contains 9 SQL SERVER Performance Tuning Tips. The length of the video is also longer.
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.