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 » I/O (RSS)

Tuning Backup Compression Part 2

Authors : Sanjay Mishra, Mike Ruthruff Technical Reviewers : Steve Schmidt, Mike Purtell, Mark Souza, Juergen Thomas, Peter Scharlock, Burzin Patel, Prem...

Posted Feb 16 2009, 01:24 PM by SanjayMishra with | with 4 comment(s)

Filed under: Database, Performance, I/O, SQL Server, Configuration, backup, Backup Compression, Log, Transaction Log, Transparent Data Encryption, Encryption, Data Compression, TDE

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 16 comment(s)

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

How many files should a database have? - Part 1: OLAP workloads

The question in the title of this blog comes up a lot. This Tech Note described tradeoffs for file allocation in OLAP systems...

Posted Mar 07 2008, 11:28 AM by tkejser with | with 9 comment(s)

Filed under: I/O, OLAP, SQL Server, Configuration

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