Well, let us discuss Detecting Deadlocks in SQL Server Using Trace Flags 1204 and 1222. T-SQL for enabling, disabling, and checking the status of these trace flags.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Understanding SQL Server Deadlocks: A Beginner’s Guide
Welcome to this introductory blog post on SQL Server Deadlocks. In this post, we’ll help you understand what deadlocks are, and how they occur.
SQL SERVER Challenge – Cumulative Total Calculation
Today we will see a very interesting SQL SERVER Challenge about Cumulative Total Calculation. During a recent Comprehensive Database Performance Health Check.
SQL SERVER – Difference Between ISNULL and COALESCE
SQL Server provides two commonly used functions, ISNULL and COALESCE, to address this requirement. Difference Between ISNULL and COALESCE
50 Minutes vs. 4 Hours for Database Performance Health Check
the On-Demand (50 Minutes) consultation and the Comprehensive Database Performance Health Check (4 Hours).
Reflections on Fireside Chat about Future of MySQL
I had the honor of participating in the Fireside Chat organized by Idera, where the discussion revolved around many different topics.
SQL SERVER – Count Occurrences of a Specific Value in a Column
Here is the exact question – How to Count Occurrences of a Specific Value in a Column? Well, honestly, the answer is very simple.
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.