SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Technical Notes

Browse by Tags

All Tags » Availability » Performance (RSS)

Tuning the Performance of Backup Compression in SQL Server 2008

Authors: Mike Ruthruff, Sanjay Mishra Contributor: Steve Schmidt Technical Reviewers: Kevin Farlee, Sunil Agarwal, Burzin Patel, Lindsey Allen, Mark Souza...

Posted Apr 21 2008, 03:37 PM by SanjayMishra with | with 5 comment(s)

Filed under: Database, Availability, Performance, I/O, SQL Server, backup, Backup Compression

Database Mirroring Log Compression in SQL Server 2008 Improves Throughput

Author: Sanjay Mishra Reviewers: Peter Byrne, Don Vilen, Kaloian Manassiev, Burzin Patel, Eric Jacobsen Overview Database mirroring works by transferring...

Posted Sep 17 2007, 02:18 AM by SanjayMishra with | with 9 comment(s)

Filed under: Database, Availability, Performance

sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services