SQL Server Performance

What is new in SQL 2008 vs SQL2005

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by AJITH123, Jul 9, 2007.

  1. AJITH123 Member

    Can anybody tell what is new in SQL 2008 vs 2005, like policy and all...?

    Thanks
    ARN
  2. FrankKalis Moderator

  3. satya Moderator

    http://sqlserver-qa.net/blogs/sql2008/archive/2007/06/10/sql-server-2008-whats-new.aspx [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] too.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  4. AJITH123 Member

    Thanks for your Quick reply...
  5. satya Moderator

  6. Madhivanan Moderator

    Somewhere I read that there are tow more datatypes DATE and TIME apart from DATETIME [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  7. satya Moderator

    Yes they are:

    DATE - ANSI-compliant date data type
    TIME - ANSI-compliant time data type with variable precision
    DATETIMEOFFSET - timezone aware/preserved datetime
    DATETIME2 - like DATETIME, but with variable precision and large date range

    GEOMETRY - "flat earth" spatial data type
    GEOGRAPHY - "round earth" spatial data type
    HIERARCHYID - represents hierarchies using path enumeration model

    If you are using CTP (June 2007) then those are not yet available and it will be in future CTPs.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  8. Madhivanan Moderator

    Thanks. <br /><br />DATETIME2 sounds VARCHAR2 of ORALCE [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  9. Akthar New Member

    great links thanks for putting the question

    AKTHAR
  10. MohammedU New Member

Share This Page