SELECT OBJECT_NAME(object_id) AS tblName ,( SELECT name FROM sys.indexes WHERE object_id = a.object_id and index_id = a.index_id) ,avg_fragmentation_in_percent FROM sys.dm_db_index_physical_…
No matter in which order you perform these, here are some points to keep in mind 1) By default, the UPDATE STATISTICS statement uses only a sample of records of the table. Using UPDATE STATISTI…
Principal Instance - Put the database you want to mirror in FULL recovery mode. For example: 1: BACKUP DATABASE AdventureWorksLT2008 2: TO DISK = 'c:\AdventureWorks…
This is one of those simple tip posts that may seem obvious and taken for granted by those of us who have been working with SQL Server for a while now but maybe a newbie or two out there will find th…
This list will grow as I find new tools. So if you know of some not on this list do post them in the comments. SQL Server Management Studio Add-in's SSMS Tools Pack - an add-in with lots…