Browse by Tags

• Backup Compression
• Bulk Load
• Compression
• Data Collector
• Data Compression
• Data Warehouse
• Dimension Table
• Encryption
• Fact Table
• Filestream
• Integration Services
• Maintenance
• MDW
• OLTP
• Partition Elimination
• Partitioning
• Query
• Resource Governor
• Sliding Window
• SQL
• Statistics
• Table Valued Parameters
• TDE
• Transparent Data Encryption

• Top 10 SQL Server 2008 Features for ISV Applications

  Author: Burzin Patel Contributor: Kun Cheng Reviewers: Sanjay Mishra, Denny Lee, Mike Ruthruff, Sharon Bjeletich, Mark Souza, Peter Carlin, Hermann Daeubler... Posted Nov 24 2008, 01:24 PM by Burzin with | with 11 comment(s) Filed under: Maintenance, Query, Performance, OLTP, Table Valued Parameters, Transparent Data Encryption, Backup Compression, Filestream, Resource Governor, Encryption, Data Compression, MDW, Data Collector, TDE, Compression, Statistics

• Top 10 SQL Server Integration Services Best Practices

  Authors: Thomas Kejser, Denny Lee Contributors: Runying Mao Technical Reviewers: Burzin Patel, Kevin Cox, Peter Carlin, Mark Souza, Richard Tkachuk, Len... Posted Oct 01 2008, 03:32 AM by denny.lee with | with 33 comment(s) Filed under: Performance, SQL, Integration Services

• Top 10 Best Practices for Building a Large Scale Relational Data Warehouse

  Contributors : Stuart Ozer, with Prem Mehra and Kevin Cox Technical Reviewers : Lubor Kollar, Thomas Kejser, Denny Lee, Jimmy May, Michael Redman, Sanjay... Posted Feb 06 2008, 06:53 PM by SanjayMishra with | with 15 comment(s) Filed under: Performance, Data Warehouse, Partition Elimination, Partitioning, Statistics, Sliding Window, Fact Table, Dimension Table, Bulk Load

• Top SQL Server 2005 Performance Issues for OLTP Applications

  OLTP work loads are characterized by high volumes of similar small transactions. It is important to keep these characteristics in mind as we examine the... Posted Nov 21 2007, 03:30 PM by Lindsey.allen with | with 16 comment(s) Filed under: Performance, OLTP

• Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications

  Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified... Posted Nov 21 2007, 03:25 PM by Lindsey.allen with | with 5 comment(s) Filed under: Performance, Data Warehouse