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 » Configuration » SQL Server (RSS)

SQL Server Service Broker: Maintaining Identity Uniqueness Across Database Copies

Author: Michael Thomassy Technical Reviewers: Sanjay Mishra, Burzin Patel, Stuart Ozer A Deployment Method: Copying Databases When dealing with many large...

Posted Aug 12 2008, 10:53 PM by MichaelThomassy with | with no comments

Filed under: Database, SQL Server, Configuration

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

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