SSMS 2008 lets DBAs run one query against many servers from one window. Here is how multi-server queries work, a tip from my TechEd India session.
SQL SERVER – Performance Counters from System Views – By Kevin Mckenna
SQL and .NET expert Kevin Mckenna, whom I met on Twitter, shows how to read SQL Server performance counters from system views.
SQL SERVER – What is Interim Table – Simple Definition of Interim Table
What is an interim table? A simple question started a long debate on a call with developers. Here is my simple definition of interim table.
STDEV and STDEVP: Choose Sample or Population
STDEV and STDEVP report spread in the input’s units. Compare a sample, a full population, duplicates, NULL and a single observed value.
SQL SERVER – List All Objects Created on All Filegroups in Database
A reader asked which object belongs to which filegroup. Here is how to list all objects created on all filegroups in a database, with a sample database.
SQL SERVER – Create Multiple Filegroup For Single Database
How to create multiple filegroup for a single database, both for a new database and an existing one, using T-SQL as well as SSMS.
SQL SERVER – Difference Between Candidate Keys and Primary Key
What is the difference between a candidate key and a primary key? A table can have many candidate keys, but only one of them becomes the primary key.