TSQL Query to Find Fragmented Indexes Including Partitioned Indexes

What I wanted to find is the most fragmented indexes, including the partition number (for the partitioned tables) and size for each index.  I want to bring back only the … Continue Reading →

How to Install SQL Server 2012 Shared Management Objects

Recently was asked to install the SQL Server 2012 Shared Management Object on an application server.  There was a new application need some of the library file that are installed … Continue Reading →