Deep level technical short papers on specific SQL Server topics.

• Views 639 Comments 1

  Report Server Catalog Best Practices Building and Deploying Large Scale SQL Server Reporting Services Environments—Technical Note Series Authors: Denny Lee, Lukasz Pawlowski Contributors: David Reinhold, John Gallardo, Dean Kalanquin, Robert... Posted Jun 26 2008, 05:15 PM by denny.lee with 1 comment(s) Filed under: Performance, Scalability, Reporting Services

• Views 1,762 Comments 0

  Reporting Services Scale-Out Architecture Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series Authors: Denny Lee, Lukasz Pawlowski Contributors: David Reinhold, Robert Bruckner Technical Reviewers... Posted Jun 05 2008, 02:59 PM by denny.lee with no comments Filed under: Performance, Scalability, Reporting Services

• Views 2,713 Comments 2

  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, Mark Tomlinson, Denny Lee, Prem Mehra, Alexey... Posted Apr 21 2008, 03:37 PM by SanjayMishra with 2 comment(s) Filed under: Database, Availability, Performance, I/O, SQL Server, backup, Backup Compression

• Views 944 Comments 0

  Resolving scheduler contention for concurrent BULK INSERT Author: Thomas Kejser Reviewers: Stuart Ozer, Kun Cheng, Lindsey Allen, Mike Ruthruff and Mark Souza, Prem Mehra, Alex Verbidski Background information As you may be aware, SQL Server, through SQLOS, implements... Posted Apr 09 2008, 08:05 PM by tkejser with no comments Filed under: Scalability, ETL, BULK

• Views 1,928 Comments 3

  Including Child Members Multiple Places in a Parent-Child Hierarchy Author: Carl Rabeler Contributor: Scott Hulke Reviewers: Richard Tkachuk, Thomas Kejser, Denny Lee When designing your SQL Server 2005 (or 2008) Analysis Services solution, you may be faced with the design... Posted Mar 17 2008, 07:46 PM by CarlRabeler with 3 comment(s) Filed under: Analysis Services, Performance, OLAP

• Views 1,389 Comments 1

  Analysis Services Synchronization Best Practices Authors : Denny Lee, Edward Melomed, Mike Vovchik Contributors: Duy Vuong, Greg Washburn Reviewers : Prem Mehra, Stuart Ozer, Thomas Kejser, Nicholas Dritsas, Kevin Cox, Wayne Robertson Introduction When... Posted Mar 16 2008, 12:18 AM by denny.lee with 1 comment(s) Filed under: Analysis Services

• Views 1,767 Comments 6

  How many files should a database have? - Part 1: OLAP workloads Author: Thomas Kejser Contributors and reviewers: Stuart Ozer, Sanjay Mishra, Lubor Kollar, Juergen Thomas, Lindsey Allen, Mike Ruthruff, Mike Kilpatrick, Burzin Pazel, Kevin Cox, Prem Mehra and Hermann... Posted Mar 07 2008, 11:28 AM by tkejser with 6 comment(s) Filed under: I/O, OLAP, SQL Server, Configuration

• Views 1,376 Comments 0

  Analysis Services: Should you use many-to-many dimensions? Author: Denny Lee Reviewers: Mosha Pasumansky, Carl Rabeler, Richard Tkachuk Introduction For starters, please note that I am not saying not to use many-to-many (m:n) dimensions in Analysis Services. This... Posted Feb 11 2008, 02:29 AM by denny.lee with no comments

• Views 3,310 Comments 2

  Precision Performance for Microsoft SQL Server using RML Utilities 9.0 Author: Robert Dorr, Keith Elmore, Lindsey Allen Introduction Have you ever asked the question: “If I upgrade or apply a fix how will it affect my applications?” Based on the experiences cumulated... Posted Feb 01 2008, 11:46 PM by Lindsey.allen with 2 comment(s) Filed under: Database, Performance, Upgrade

• Views 3,814 Comments 1

  Sample Robocopy Script to customer synchronize Analysis Services databases Authors: Eric Jacobsen, Denny Lee Contributors: Mike Vovchik Technical Reviewers: Guillaume Fourrat, Richard Tkachuk, Thomas Kejser Applicable to: SQL Server 2005 Analysis Services Introduction As a quick... Posted Jan 17 2008, 02:51 PM by denny.lee with 1 comment(s) Filed under: Analysis Services, Scalability

• Views 1,138 Comments 3

  Asynchronous Database Mirroring with Log Compression in SQL Server 2008 Author: Sanjay Mishra Reviewers: Prem Mehra, Mike Ruthruff, Michael Thomassy, Peter Byrne, Kaloian Manassiev, Burzin Patel, Juergen Thomas, Tom Davidson Overview This is the second part of the article... Posted Dec 17 2007, 06:37 PM by SanjayMishra with 3 comment(s) Filed under: Database, Availability

• Views 2,478 Comments 8

  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 and applying a stream of database log records from... Posted Sep 17 2007, 02:18 AM by SanjayMishra with 8 comment(s) Filed under: Database, Availability, Performance

• Views 1,992 Comments 1

  Analysis Services 2005 Aggregation Design Strategy Author: Eric Jacobsen, Denny Lee Introduction Designing effective aggregations are a well known way to improve query performance (for the sake of AS processing time). As you may have noticed in Tip #2... Posted Sep 11 2007, 07:54 PM by admin with 1 comment(s) Filed under: Analysis Services, Aggregations

• Views 1,121 Comments 0

  How to warm up the Analysis Services data cache using Create Cache statement? Author: Eric Jacobsen, Christian Petculescu Updated by Denny Lee Goal This document describes how to build Create Cache commands. Create Cache for Analysis Services (AS) was introduced in SP2 of SQL Server... Posted Sep 11 2007, 07:53 PM by admin with no comments Filed under: Analysis Services, Cache

• Views 738 Comments 0

  Distributed Partitioned Views / Federated Databases: Lessons Learned Authors: Kevin Cox, Teodoro Marinucci, Silvia Bevilacqua (also thanks to Stefano Stefani, Gargi Sur and Rakesh Gujjula from the SQL Product Team) Updated by Denny Lee Introduction This article contains... Posted Sep 11 2007, 07:51 PM by admin with no comments Filed under: Partitions, Database