geometry STIsEmpty tests whether an existing spatial instance has an empty point set. I keep that condition separate from SQL NULL. A missing database value and a present empty geometry are different inputs.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQLAuthority News – SQLPASS Nov 8-11, 2010-Seattle – An Alternative Look at Experience
SQLPASS 2010 in Seattle was the best summit ever. Instead of the usual event report, here is an alternative look at my trip, travel stats and fun moments.
LIKE Cardinality: String Statistics and Row Estimates
LIKE row estimates depend on the pattern, string statistics and compilation context. Compare estimated and actual matching rows in a controlled distribution, while keeping cardinality estimates separate from the chosen access path.
SQL SERVER – Change Database Access to Single User Mode Using SSMS
I showed before how to set single user mode with T-SQL before a backup. You can also set single user mode using SSMS, from the database properties page.
How to Practise SQL Without a Real Database
You can practise SQL with small invented tables, generated rows, and repeatable exercises without access to a company's production database.
Recording Table Row Counts Every Day
Recording table row counts each day creates a useful SQL Server trend when a scheduled job, history table, and change review support it.
Replaying a Production Workload After Distributed Replay
Capture a production workload with Extended Events and replay it on a restored copy using WorkloadTools or ostress after Distributed Replay.
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.