|
|||||
|
Jonathan Kehayias blogged [Pay Attention to Maintenance Cleanup Job Configuration (If you use Maintenance Plans)] yesterday going over one of his pet peeve about Maintenance plans. Maintenance plans are so inflexible when compared to regular T-SQL jobs and I want to present one of my reason(s) why I don’t like them. Starting from SQL Server 2005, we . . . → Read More: Another reason why I don’t like SQL Server Maintenance plans Recently I have been doing an audit on our enterprise SQL Servers including production and non-production systems and wanted to check the server level configurations. One of the audit items I specifically wanted to look at was the server level default connection options. Unless there is a strong reason to do so, In general it is . . . → Read More: Get the Server level default connection properties for SQL Server using T-SQL Database Snapshots are introduced in SQL Server 2005 and are available only in Enterprise Editions. Database Snapshots use copy-on-write along with NTFS Sparse file technology and this makes the Snapshot creation very quick. The amount of disk space used when creating the Snapshot is bare minimal and the actual size of the Snapshot will increase proportionally . . . → Read More: How to find the actual space used for the sparse files used in Database Snapshot? |
|||||
|
Copyright © 2010 Sankar Reddy, SQL Server Developer/DBA - All Rights Reserved      |
|||||
Popular posts