Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2000   (RSS)
Friday, May 12, 2006 8:40 PM

Predicate ordering is not guaranteed

A typical programmer may expect that the predicates are always evaluated in the order that they are specified, but this is not true in database systems. For example, for the following clause, where col11 = 5 and convert(int, col2) = 100 programmers may
Posted by Jun Fang | 2 Comments
Thursday, April 13, 2006 3:04 PM

An article on FOR XML in Microsoft SQL Server 2000 and 2005

I just posted an article What does server side FOR XML return? ( http://blogs.msdn.com/sqlprogrammability/articles/576095.aspx ) which gives some details of the design and performance characteristics of various FOR XML flavors. I also added links to XML
Posted by ekogan | 0 Comments
Thursday, April 13, 2006 2:44 PM

What does server side FOR XML return?

XML publishing functionality exposed as “FOR XML” in Microsoft SQL Server 2000 evolved quite a bit in SQL Server 2005. So, I thought I would document the matrix of what FOR XML results in. This article should help understand some performance characteristics
Posted by ekogan | 1 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 | 1 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
 
Page view tracker