Browse by Tags

• Backup Compression
• Bulk Load
• Compression
• Data Collector
• Data Compression
• Data Warehouse
• Dimension Table
• Encryption
• Fact Table
• Filestream
• Maintenance
• MDW
• OLTP
• Partition Elimination
• Partitioning
• Performance
• Query
• Resource Governor
• Sliding Window
• 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 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