Browse by Tags

• Availability
• backup
• Backup Compression
• Configuration
• Database
• I/O
• OLAP
• Performance

• The Many Benefits of Money…Data Type!

  Authors: Denny Lee, Thomas Kejser, Matt Neerincx Contributors / Reviewers: Peter Carlin, Brandon Berg, Eric Jacobsen, Burzin Patel Background Our initial... Posted Sep 25 2008, 02:20 PM by admin with | with 3 comment(s) Filed under: Database, Performance, SQL Server

• 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

• 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

• 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