What is the difference between an INNER JOIN and WHERE clause join? Very little in results or speed, but I explain why I still prefer INNER JOIN.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Extended Security Updates Explained
Extended Security Updates give eligible older SQL Server releases limited critical security coverage while you complete a migration.
SQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table
Can you add an auto incremental identity column to a table after it is created? The answer is both no and yes, and I show the ALTER TABLE script.
SQL SERVER – Row Offset in SQL Server For Different Version
A common question is how to find row offset in SQL Server. I share paging examples for each version, from OFFSET FETCH in 2012 back to SQL Server 2000.
SQL SERVER – Tuning Queries is Sometimes Waste of Time – Notes from the Field #049
Brian Moran explains why tuning queries is sometimes a waste of time when you are trying to fix performance and scalability problems in SQL Server.
SQL SERVER – Reset the Identity SEED After ROLLBACK or ERROR
A reader noticed that a failed insert still bumps the identity value. I show how to reset the identity seed after a ROLLBACK or an error.
Finding Hot Tables With sys.dm_db_index_usage_stats
Identify hot tables with index usage, lock and latch counters, table sizes, and retained snapshots that describe a real workload interval.
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.