Need statistics of whole database in one view? My script uses DMVs instead of the deprecated sp_helpstats and shows each stat, column and last update.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
CROSS JOIN: Duplicate Inputs Multiply the Result
CROSS JOIN multiplies row counts, including repeated labels. Keep source identifiers and grouped pair counts visible while checking result grain.
SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator
SELECT SUM over a lone NULL throws Msg 8117: Operand data type void type is invalid for sum operator. Here is why it happens and how ISNULL fixes it.
SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers
A SQL enthusiast at the airport asked for a simple way to find maximum between two numbers. Here is his clever ABS formula and my CASE version.
Tabular Models for the SQL Developer
Tabular models for the SQL developer add relationships, measures, security, and reusable semantics above SQL tables; learn when a view is enough.
Summary Tables: Keeping Pre-Aggregated Totals Current
Keep summary tables current with changed-day rebuilds, handle late arrivals and deletes, and reconcile stored totals against detail.
SQLAuthority News – Ahmedabad Tech Ed On Road June 11, 2011 – A Grand Success of Community Tech Days
Over 500 people packed the Ahmedabad Tech Ed On Road on June 11, 2011, so we found 150 more chairs. Here is how this Community Tech Days went.
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.