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...

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...

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...

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...

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...

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...