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

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

Enter Search Terms Here Search

Subscribe to All RSS Feeds

CAT | Customer Advisory Team | Meet the members of the largest SQL Server implementation team.

Use your Windows Live ID to log in here.

More Info

Toolbox

Check out our toolbox of helpful tools

Presentations

Check out our presentations, radio, podcasts, and webcasts

Other great SQLCAT resources

CSS Experts Blog: Great SQL Tips and Best Practices from SQL Escalation engineering team

SQLCAT ISV Team blog: Great SQL tips and best practices from the SQLCAT ISV team

Other Languages

ホワイトペーパー（日本語）

中文（简体）白皮书

Popular Tags

Browse All Tags

Members

Lubor

CarlRabeler

Lindsey.allen

thoshi

denny.lee

joeld2

aspiringgeek

SanjayMishra

dreamania