SSMS says saving changes is not permitted when a table must be re-created. Learn to turn off Prevent saving changes, and why I still prefer T-SQL.
Readers often ask how to check existence of a temp table and how to drop temp table without Msg 2714. My earlier article answers all of these questions.
Build a dynamic PIVOT with ordered STRING_AGG and QUOTENAME, parameterized filters, zero-filled results, and explicit report-width limits.
A New Major Version of SQL Server changes the engine while database compatibility, query plans, and deprecated features need separate review.
ALTER TABLE … DROP PRIMARY KEY is MySQL syntax and fails in SQL Server with Msg 156. Here is how to drop primary key constraint the SQL Server way.
While hiring Database Administrators and senior developers for a large project, we discussed many interesting questions. Here are some, with my own views.
CASE sort priority makes the queue policy explicit. Map known statuses to numeric ranks and keep missing or unfamiliar labels visible. Finish tied ranks with a unique key.