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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Questions and Answers with Database Administrators
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: Put Business Order Before Alphabetical Order
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.
SQL SERVER – Find Last Date Time Updated for Any Table
Want the last date time a table was updated without an UpdatedDate column? The sys.dm_db_index_usage_stats DMV shows it. A quick demo on AdventureWorks.
Ordered Columnstore Indexes in SQL Server 2022
Build an ordered columnstore index in SQL Server 2022, inspect segment bounds, and compare range-query reads on your own data.
INTERSECT: Return Shared Values Once
INTERSECT returns distinct shared rows, including shared NULL. Compare it with an equality join that preserves matching-pair multiplicity.
A Weekly Routine for SQL Server Administration
A weekly routine for SQL Server Administration checks recovery, failures, capacity, integrity, security, and pending changes in a practical order.
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.