Ads

06 January 2015

25 December 2014

Database Files location with Comma separated

Enclosed script will provide the details of MDF and LDF locations with a comma separated. This will help us to collect the inventory during the intial requirement gathering.

 https://gallery.technet.microsoft.com/Database-Files-location-08d507df

 

Usefull DMV's

Dynamic Management Views and Functions (Transact-SQL) SQL Server 2014 Other Versions 5 out of 5 rated this helpful - Rate this topic Dynamic management views and functions return server state information that can be used to monitor the health of a server.


https://gallery.technet.microsoft.com/Usefull-DMVs-14b6bb92

SQL Server 2012 Instalation

DataCompression_Scripts and Steps


Database Compression document enclosed. This will do only page level compression if we run the scripts as it is mentioned in the document.If we need to do the ROW level compression please change the script, Just remove the commets where i have commented for the ROW.


https://gallery.technet.microsoft.com/DataCompressionScripts-and-40780587