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

 Data Compression:-
   
      1- Stored data efficiently.
      2- Reduced the data storage requirements.
      3- Provides Significant performance improvements for large work loads
      4- It works as Data Warehousing.

 Top 100+ Sql Server Interview Questions

Streamlined Installation:-

     1- Significant Improvements in the services Life cycle of SQL server.

Data Types:-
  
     Implements Round Earth Solution with geography data types.
     1- Latitude
     2- Longitude
      To define areas on the Earth Surface.

DATE/ TIME
     
    1- DATE-  A date only type
    2- Time  - A time only type
    3- DATETIMEOFFSET - A time - zone -aware datetime type
    4- DATETIME2 - with a large fractional seconds.