Features of SQL Server 2008 List 2 Programming Logic and Code with Syntax

Recovery of data pages :-

     

     1- It uses the principal and mirror machines to transparently.

 Top 100+ Sql Server Interview Questions

 

Log  Compression:-

      

       Compression of outgoing in 2008 SQL Server log stream b/w the participant delivers performance and minimises the network the network bandwidth.

Governing Resources :- 

       Provide a predictable and constant response to users with the introduction.  Allowing organisations to define limits and set into hierarchy according to workload.

Query Performance:- 

    1- Provide functionality Lock for query

    2- Provide Stable query plans.

    3- Provide consistent performance to server upgrades.

    4- Provide Separate Environment for testing and production server.