August 2008 - Posts

• SQL Server 2008 (Katmai)'s new collations

  In SQL Server 2008 release, a number of new collations were added. You can get the list of 79 new collations (only _CI_AS was listed) by using select * from fn_helpcollations() where name like '%_100_ci_as' These new collations are aligned with the linguistic Read More... Posted Monday, August 25, 2008 5:33 PM by Qingsong Yao | 1 Comments Filed under: collation

• Conversion from string to datetime2, time, date is timezone un-awared

  In SQL Server 2008, An instance of DateTimeOffset type can represent: 1) A local time + a time zone offset 2) A UTC time + a time zone offset 3) A local time and a UTC time. When converting such an instance to other date and time types, such as datetime Read More... Posted Monday, August 18, 2008 7:27 PM by Qingsong Yao | 0 Comments Filed under: DateTime

• Why should we bother about Surrogate characer?

  Today, someone ask following questions: 1. We know that the Surrogate Characters have two bytes when counting, so when we design this character in DB table, we should set double size of your original type, shouldn't we? 2. When comparing string, if we Read More... Posted Monday, August 11, 2008 8:53 PM by Qingsong Yao | 1 Comments Filed under: surrogate, collation

• The resolution of SYSTEMDATE function

  In SQL Server 2008, the datetime2, time, and datetimeoffset types can have a optional fractional second part. This decision have several benefit: If user does not care about the fractional second, they can use datetime2/time/datetimeoffset(0), which can Read More... Posted Tuesday, August 05, 2008 5:29 PM by Qingsong Yao | 0 Comments

• Colon(:) and dot (.) in factional second is not the same

  Colon and Dot are two symbol to separate the second and factional second in a given time string. If we create following queries: select CAST ( '1999-12-21 01:01:01.12' as datetime ) ----------------------- 1999-12-21 01:01:01.120 select CAST ( '1999-12-21 Read More... Posted Monday, August 04, 2008 10:53 PM by Qingsong Yao | 0 Comments Filed under: DateTime

• Idea about implementing a time internal type in SQL Serve 2008

  In SQL Server 2008, we implement several new date and time types which follow the ISO SQL standard. The one ISO SQL type which is missing in SQL Server 2008 is the time internal type. Today, I will present some idea about implementing a time internal Read More... Posted Friday, August 01, 2008 6:19 PM by Qingsong Yao | 0 Comments Filed under: DateTime, Time Interval