|
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..........
|
