Use Central Management Servers and registered servers in SSMS to organize SQL Server instances and run safe read-only queries across groups.
sys.objects, sys.all_objects and sys.system_objects
Compare sys.objects, sys.all_objects and sys.system_objects to find SQL Server user objects, system objects, and metadata visibility gaps.
Evaluating a New SQL Server Version in One Week
Evaluating a New SQL Server Version in one week works when you install, restore, run a real workload, compare results, and write a decision.
SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
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.