A developer saw slow performance with line strings in the Geometry datatype. I share what I found and the line string behavior enhancements that help.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan
Do you use the actual or the estimated execution plan? A candidate asked me this in an interview. I always use the actual plan, and here is why.
SQL SERVER – Script: Remove Spaces in Column Name in All Tables
A reader wanted a script to remove spaces from every column name in all tables. Here it is, with a warning first: renaming columns can break your application.
SQL SERVER – Getting to understand SQL Server Activity Monitor in SSMS
My notes on the lesser used parts of Activity Monitor in SSMS, like Resource Waits, and how the tool builds them from sys.dm_os_wait_stats at each refresh.
SQL SERVER – How To Improve Performance by Offloading Backups to a Secondary Replica – Notes from the Field #108
Want more from two servers? In Notes from the Field #108, Eduardo explains how offloading backups to a Secondary Replica can make the primary server faster.
SQL SERVER – Unable to drop login – Msg 15170, Level 16, State 1
Cleaning up my demo server, I could not drop login danny because of Msg 15170: the login owns a job. Here is how to find what a login owns and remove it.
SQL SERVER – Error and Fix for Msg 1907 Cannot recreate index The new index definition does not match the constraint being enforced by the existing index
Moving to a Clustered ColumnStore Index can throw Msg 1907: cannot recreate index, as the new definition does not match the constraint. Here is why and the fix.
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.