Protect sensitive data when sharing an execution plan by inspecting XML values, redacting names and literals, and checking the file again.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL Server on Virtual Machines: Settings That Matter
SQL Server on virtual machines needs deliberate CPU, memory, NUMA, and storage settings; learn what to inspect before blaming a slow query.
Incorrect Syntax Near: When Compatibility Level Is the Cause
Incorrect syntax near means the parser met a word it did not expect, and a low compatibility level is one cause. This post reproduces the error, shows how to read and raise the level, and covers the other common causes.
SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept
Two ideas with examples: transactions have no effect on local variables, and an UPDATE applies all its changes at once, which lets you Swap Variables in one go.
SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure
An introduction to CLR in SQL Server 2005 and later, with a simple CLR Stored Procedure built in Visual Studio that prints the current system datetime.
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2
Which way to select only date part from DATETIME is faster? After more tests on large tables, I now suggest the DATEADD and DATEDIFF method over CONVERT.
SQL SERVER – Get Common Records From Two Tables Without Using Join
Sachin wanted common records from two tables without writing a join condition. Imran Mohammed shows how INTERSECT in SQL Server 2005 does it.
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.