A developer wrote a cursor because he did not know how to UPDATE from SELECT. I show how to use JOIN and multiple tables in an UPDATE statement.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database
A tester wanted to load bad data, but foreign keys got in the way. Here is how to disable all the foreign key constraints in a database and enable them again.
Reducing the Size of a Reporting Database
Reducing the size of a reporting database starts with compression, archiving, and index review; shrinking files comes last.
Weekday Logic That Works Under Any DATEFIRST Setting
Make weekday logic independent of DATEFIRST with a normalized offset or a known Monday, then test every date in a full year.
UNION vs UNION ALL in SQL Server: What Each One Does
UNION vs UNION ALL comes down to duplicates: UNION removes them and UNION ALL keeps every row. This post tests both on two small store tables. It also covers sorting, a total row at the bottom, mixed operators and data type rules.
SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2
Part 2 on how to return a specific row at the bottom of the resultset. Earlier I used CASE in ORDER BY, and this time I show the UNION ALL method.
SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050
SQL in Sixty Seconds hits its 50th episode and a full hour of play time. To celebrate, get a free SQL Server Interview Questions and Answers sample chapter.
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.