Question: How to create primary key without ANY index? SQL Server builds a clustered or nonclustered index for every primary key, so here is the answer.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
How Readable Secondary Replicas Build Their Own Statistics
Learn why readable secondary replicas create temporary statistics in tempdb, how to find them, and when the primary needs a permanent statistic.
Reading a Benchmark Somebody Else Published
Read a database benchmark by checking workload rules, hardware, durability, latency, pricing scope, and whether the test can be repeated.
SQL SERVER – Connecting Specific Database on Starting SSMS
Here is how to connect to a specific database on starting SSMS, a small setting many DBAs miss. It keeps stray objects out of the master database.
SQL SERVER – Why One Table Cannot Be Deleted From a Backup File
You cannot Delete a Single Table by editing a SQL Server backup file. I keep the original backup intact.
SQL SERVER – Puzzle – Shortest Code to Produce the Number 1000000000 (One Billion)
This shortest code puzzle asks for 1000000000 without writing that literal or using arithmetic operators. The earlier zero puzzle brought roughly 700 valid answers.
Error 0x80040E4D: SaveToSQLServer Fails With Login Failed for sa
Error 0x80040E4D stopped a client from saving a maintenance plan, with Login failed for user sa at the end of the message. The sa login was locked out by another maintenance plan that still used an old password. Windows authentication worked in the meantime.
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.