SQL Server 2008 Interview Questions - Freshers & Experienced

Inline variable assignment in SQL Server 2008 enables to – declare, and assign the variables in a ‘single line’..........
Compound operators feature is enhanced in SQL Server 2008. They are like compound operators in languages like C, C++ etc..........
Automatic auditing is a true auditing solution for enterprise customers. STL Trace can be used for satisfying several auditing needs..........
Data compression is a feature which is used to reduce disk storage space and increase the performance of the query by reducing the I/O operations..........
Filtered index in SQL Server 2008 is an index WHERE clause. A filtered index is an optimized non-clustered index.........
Resource Governor enables the DBA for managing the work load of SQL Server and critical system resource consumption...........
Plan freezing is a new concept that allows the DBAs to persist plan guides..........
A user defined tables are allowed between queries using the Table Value Parameters feature of SQL Server 2008...........
Prior to SQL Server 2008, IntelliSense was available from third-party products. Red-Gate has a pretty good IntelliSense product..........
Windows PowerShell is a new and powerful scripting shell which can be used by developers and administrators for automating server administration.........
Declarative Management Framework is a system for managing the instances of SQL Server 2008. It is a policy based system...........
The demands of regulatory compliance and overall data privacy concern are enabled by encryption in organizations...........
A comprehensive solution for encryption and key management is provided by SQL Server 2008...........
Automatic Page Repair: The principal is enabled and mirror computers for recovering transparently from 823 and 824 errors on data pages..........
CPUs can dynamically be added to a running system, by using Hot Add CPU feature...........
Extended Events are the enhanced event handling system in SQL Server. It is an architecture that is highly scalable, highly configurable..........
A compression backup is smaller than uncompressed backup. The backup speed significantly increases because it needs less disk space and I/O operations..........
The complexity of application development and reduces the managing unstructured data cost...........
A column with an optimized storage for null values is known as sparse column. Sparse columns reduce the storage space needs for null values..........
TIME Data type: TIME data type of SQL Server 2008 allows to exclusively storing the time...........
Location based data can be seamlessly consumed and extended by the enterprises with the comprehensive support of spatial data types..........
Policy based database administration allows the DBA for managing the instances and objects of SQL Server 2008 across the enterprise by a defined policies that are set...........
Change Data Capture is a feature that is used for tracking the changes on a table. The process involves in steps........
Spatial data is stored by using Geometry and Geography data types that are introduced in SQL Server 2008...........
SQL Server 2008 allows objects to be created for high level business like Customers, Parts, Inventory...........
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition..........