SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: SQL Server 2008 July CTP Available
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 08/01/2007 :  00:21:21  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Microsoft squeeeeezed in the July CTP for SQL Server 2008 with barely a few hours to spare. It includes some interesting new functionality. It looks like separate date and time data types are finally included as well as support for a time zone aware datetime data type. There are also improvements in Reporting Services, Analysis Services, improved dependency handling in T-SQL, improved XML support, large user-defined types and various other enhancements. Microsoft also posted a neat chart summarizing the improvements


Read SQL Server 2008 July CTP Available

Kristen
Test

United Kingdom
22431 Posts

Posted - 08/01/2007 :  01:56:29  Show Profile  Reply with Quote
and a HierarchyID system data type it seems ...

http://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5965

Kristen
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 08/01/2007 :  02:52:02  Show Profile  Visit SwePeso's Homepage  Reply with Quote
If it works

WOW !!


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 08/01/2007 :  03:48:05  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Michael, maybe you have to rewrite your F_TABLE_DATE
quote:
DATE/TIME Data Types

SQL Server 2008 introduces new date and time data types. The new data types enable applications to have separate date and time types, larger year ranges for date value, larger fractional seconds precision for time value, time-zone offset aware datetime type that containing date, time and time zone offset portion, user defined option on fractional seconds precision of time related types and datetime2 and datetimeoffset provide standards conformant semantics. Along with the T-SQL support on the new types, both native (ODBC, OLEDB) and managed (SqlClient) providers also provide the full support through the client driver APIs.



E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 08/01/2007 03:48:19
Go to Top of Page

karuna
Aged Yak Warrior

582 Posts

Posted - 08/01/2007 :  11:48:56  Show Profile  Send karuna a Yahoo! Message  Reply with Quote
quote:
Originally posted by Peso
SQL Server 2008 introduces new date and time data types. The new data types enable applications to have separate date and time types, larger year ranges for date value, larger fractional seconds precision for time value, time-zone offset aware datetime type that containing date, time and time zone offset portion, user defined option on fractional seconds precision of time related types and datetime2 and datetimeoffset provide standards conformant semantics. Along with the T-SQL support on the new types, both native (ODBC, OLEDB) and managed (SqlClient) providers also provide the full support through the client driver APIs.


Does this mean that 2008 is capable of handling TimeZones by itself ?

Thanks
Karunakaran

Edited by - karuna on 08/01/2007 11:49:29
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 08/01/2007 :  12:26:00  Show Profile  Visit SwePeso's Homepage  Reply with Quote
We will see. Have download it now and will install later this evening.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 08/01/2007 :  19:53:52  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Key Properties of hierarchyid

A value of the hierarchyid data type represents a position in a tree hierarchy. Values for hierarchyid have the following properties:

Extremely compact

The average number of bits that are required to represent a node in a tree with n nodes depends on the average fanout (the average number of children of a node). For small fanouts, (0-7) the size is about 6*logAn bits, where A is the average fanout. A node in an organizational hierarchy of 100,000 people with an average fanout of 6 levels takes about 38 bits. This is rounded up to 40 bits, or 5 bytes, for storage.


Comparison is in depth-first order

Given two hierarchyid values a and b, a<b means a comes before b in a depth-first traversal of the tree. Indexes on hierarchyid data types are in depth-first order, and nodes close to each other in a depth-first traversal are stored near each other. For example, the children of a record are stored adjacent to that record. For more information, see Using hierarchyid Data Types (Database Engine).


Support for arbitrary insertions and deletions

By using the GetDescendant method, it is always possible to generate a sibling to the right of any given node, to the left of any given node, or between any two siblings. The comparison property is maintained when an arbitrary number of nodes is inserted or deleted from the hierarchy. Most insertions and deletions preserve the compactness property. However, insertions between two nodes will produce hierarchyid values with a slightly less compact representation.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 08/01/2007 :  20:03:51  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Originally posted by karuna

Does this mean that 2008 is capable of handling TimeZones by itself ?
quote:
Books Online

Note:
Use the time, date, datetime2 and datetimeoffset data types for new work. These types align with the SQL Standard. They are more portable. time, datetime2 and datetimeoffset provide more seconds precision. datetimeoffset provides time zone support for globally deployed applications.



E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 08/01/2007 20:04:16
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 08/01/2007 :  20:27:13  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Have used July CTP for two hours now.
I am positive to the changes. Have to learn more about HierarchyID datatype!



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 08/02/2007 :  03:59:21  Show Profile  Reply with Quote
XRef:

Further discussion of the new date time formats here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85099
Go to Top of Page

Marioi
Posting Yak Master

USA
132 Posts

Posted - 08/08/2007 :  10:39:57  Show Profile  Reply with Quote
For those interested in how .net 3.5 addresses time zones in the datetime data type, see:

http://blogs.msdn.com/bclteam/archive/2007/06/18/a-brief-history-of-datetime-anthony-moore.aspx

http://blogs.msdn.com/bclteam/archive/2007/07/12/a-brief-history-of-datetime-follow-up-anthony-moore.aspx

http://blogs.msdn.com/bclteam/archive/2007/06/14/datetimeoffset-a-new-datetime-structure-in-net-3-5-justin-van-patten.aspx
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 08/16/2007 :  09:33:26  Show Profile  Reply with Quote
>> larger year ranges for date value

Does that mean they've done away with all the nonsense about som King in the 1700's?

How very esoteric



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000