SQL Server Performance Forum – Threads Archive
What is new in SQL 2008 vs SQL2005
Can anybody tell what is new in SQL 2008 vs 2005, like policy and all…? ThanksARN
Check this out:http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx —
Frank Kalis
Microsoft SQL Server MVP
Contributing Editor, Writer & Forum Moderatorhttp://www.sql-server-performance.com
Webmaster:http://www.insidesql.de
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>
Thanks for your Quick reply…
To addup further if you want to know more about features within SQL2008 you could install Katmai Books online alone http://sqlserver-qa.net/blogs/sql2008/archive/2007/06/12/710.aspx) fyi. 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.
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
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.
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
great links thanks for putting the question AKTHAR
Microsoft SQL Server 2008 Product Overview http://download.microsoft.com/downl…a71/SQL2008_ProductOverview.doc#_Toc172596217
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>