During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Keyword Join or Inner Join – SQL in Sixty Seconds #099
Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same or different? If different, how are they different?
Moving to Azure SQL Database: The Features You Give Up
Plan moving to Azure SQL Database by finding Agent jobs, cross-database references, CLR, FILESTREAM, linked servers, and recovery changes.
How to Get Rowcount of Every Table in SSMS? – Interview Question of the Week #288
Question: How to Get Rowcount of Every Table in SSMS?
Answer: After watching my earlier video on the fastest way to get the rowcount for the table,
Alter Index Add Column – Workaround – SQL in Sixty Seconds #097
However, while modifying it we faced a unique challenge that we can’t actually alter index to add columns. Let us discuss that today.
Fastest Way to Retrieve Rowcount for a Table – SQL in Sixty Seconds #096
What is the fastest way to retrieve rowcount for a table? Whenever I am helping my clients with their SQL Server, I get this question.
Where are Table Variables Stored? – SQL in Sixty Seconds #095
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,
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.