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.
Default Filegroup: Sending New Tables Away From PRIMARY
Changing the default filegroup only affects tables you create later. Here is what moves, what does not, and how a script can quietly ignore the rule.