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, Peter Scharlock, Wanda He
Microsoft SQL Server 2008 has hundreds of new and improved features, many of which are specifically designed for large scale independent software vendor (ISV) applications, which need to leverage the power of the underlying database while keeping their code database agnostic. This article presents details of the top 10 features that we believe are most applicable to such applications based on our work with strategic ISV partners. Along with the description of each feature, the main pain-points the feature helps resolve and some of the important limitations that need to be considered are also presented.
1 Data Compression
2 Backup Compression
3 Transparent Data Encryption
4 Data Collector and Management Data Warehouse
5 Lock Escalation
6 Plan Freezing
7 Optimize for Ad hoc Workloads Option
8 Resource Governor
9 Table-Valued Parameters
10 Filestream
Abstract courtesy : Microsoft
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Hi Pinal, thats indeed amazing..you are really a pioneer of SQL server…Can you please add or update more interview questions based on sql 2008?