Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000 2005 and 2008 customers.
Forcus area covered include SSIS, Performance, and Replication
I don't always remember names of the SQL Server Dynamic Managment views. Books Online is great, but here is a simple query to get a list of DMVs
SELECT * FROM sys.all_objects
WHERE [name] LIKE '%dm_%'
AND [type] IN ('V', 'TF', 'IF')
AND [schema_id] = 4
ORDER BY [name]
Anonymous comments are disabled
