XQuery node identity compares source nodes, not their text. Use is beside text equality to distinguish repeated values from the same node.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Finding the Slowest Stored Procedures With sys.dm_exec_procedure_stats
Find the slowest stored procedures with cache statistics, compare CPU and reads, and use two snapshots to isolate one busy hour.
SQLAuthority News – 1700th Blog Posts – Over 25 Millions of Views – A SQL Milestone
My 1700th blog post is a milestone with over 25 million views. I look back at 2011 so far, from my wait types series to my SQL Server Quiz question.
SQL SERVER – How to ALTER CONSTRAINT
Can you ALTER CONSTRAINT in SQL Server? No. The only way to change a constraint is to drop it and create it again, and here is the script for that.
SQL SERVER – How to Use Decode in SQL Server?
CASE expresses the DECODE mapping in this SQL Server example. I keep the named matches and default value explicit.
SQL SERVER – Potential Bottlenecks for Performance
At GIDS I was asked to name potential bottlenecks for performance. My old college list still holds: CPU, RAM, hard disk, network and application code.
SQL SERVER – Prevent Constraint to Allow NULL
Why does a CHECK constraint allow NULL? A reader thought it was a bug. I show why it happens and how to write the constraint so NULL is rejected too.
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.