Is there any real world reason to list a missing identity in a table? Readers had no new script, but a lively discussion on whether gaps matter.
SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers
It’s my birthday, so I am taking a break from tech posts to spend time with family and to thank my top 7 commenters who help readers on this blog.
SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
SQL Server 2008 lets you copy database with data: turn on Script Data in the Generate Scripts wizard to get INSERT statements for the rows in your tables.
Calculating the Cost of a Slow Query
Cost of a slow query includes frequency, CPU, reads, waits, and user time; learn to turn SQL Server measurements into a practical tuning priority.
Resource Governor: Capping a Runaway Report
Capping a runaway report with Resource Governor uses workload groups, pools, and a tested classifier to limit one workload safely.
Stopping Backup Success Messages From Flooding the Error Log
Reduce backup success messages in the SQL Server error log with trace flag 3226, verify msdb history, and cycle logs safely.
Hunting Suspicious Objects After a SQL Server Compromise
Investigate a SQL Server compromise by preserving evidence and checking logins, startup procedures, Agent jobs, risky features, and changed objects.