Spatial data types in SQL Server use geometry for planes and geography for Earth; points, polygons, and indexes start with valid coordinates.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Find Queries using Parallelism from Cached Plan
A script by Feodor Georgiev that finds queries using parallelism from the cached plan, along with their plans. Please avoid running it on a busy production server.
Stop Blaming the User: Let Constraints Catch Bad Data
Blaming the user is the oldest joke in IT. Here’s why it fails, and how NOT NULL, CHECK, UNIQUE and foreign keys stop bad data before it lands.
OPTIMIZE FOR and RECOMPILE Hints Compared
OPTIMIZE FOR and RECOMPILE address parameter-sensitive plans differently; compare stable representative values with per-run compilation cost.
Keyset Paging: Continue After a Date and ID Cursor
Keyset paging continues after a saved ordering key instead of counting past an offset. A date and unique ID together keep equal-date rows in the sequence. A guarded disposable fixture makes the boundary conditions explicit.
SQL SERVER – SELECT * FROM dual – Dual Equivalent
Oracle developers often miss the DUAL table in SQL Server. I explain what DUAL is, why SELECT * FROM dual fails with Msg 208, and the dual equivalent to use.
SQL SERVER – Identifying Statistics Used by Query
Can you find the statistics used by query? There is no direct tool or DMV for it, but I explain an indirect way through the indexes a query uses.
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.