Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Native Types and Methods   (RSS)
Monday, November 06, 2006 10:20 PM

How are GUIDs compared in SQL Server 2005?

In general, equality comparisons make a lot of sense with uniqueidentifier values. However, if you find yourself needing general ordering, then you might be looking at the wrong data type and should consider various integer types instead. If, after careful
Posted by mathh | 4 Comments
Friday, April 07, 2006 12:21 AM

Sorting undefined characters in Unicode and/or Windows collation

When comparing two Unicode strings in non-binary collations, SQL Server uses a library that is essentially same as the Windows API CompareStringW. It defines a weight for each recognized character, and then use the weights to compare characters. However,
Posted by Jun Fang | 0 Comments
Wednesday, March 29, 2006 6:21 PM

Multiplication and Division with Numerics

It can be surprising to see certain results when doing numeric arithmetic: declare @num1 numeric(38,10) declare @num2 numeric(38,10) set @num1 = .0000006 set @num2 = 1.0 select cast( @num1 * @num2 as numeric(38,10)) Yields: .0000010000 Instead of: .0000006000
Posted by mathh | 1 Comments
Thursday, March 23, 2006 5:41 PM

Newsequentialid (Histrory/Benefits and Implementation)

In general, we made significant improvements in SQL Server scalability during Yukon . One of the areas of improvement is replication scalability. While doing merge replication testing we found out that scaling was severely affected by high number of I/O
Posted by dragant | 11 Comments
 
Page view tracker