Welcome to TechNet Blogs Sign in | Join | Help

March 2006 - Posts

Sunday, March 19, 2006 8:45 PM

Technical News: SQL Server 2005 SP1 March 2006 CTP Now Available

A link to the SQL Server 2005 Service Pack 1 March 2006 Community Technology Preview is provided.
Posted by Ward Pond | 0 Comments
Sunday, March 19, 2006 6:30 PM

Database Programming: Feedback Requested -- Which Syntax Is More Maintainable?

Feedback is solicited on a programming issue
Posted by Ward Pond | 2 Comments
Sunday, March 19, 2006 5:30 PM

Microsoft Announces Development Contest

Microsoft recently announced the Made With Express contest
Posted by Ward Pond | 2 Comments
Sunday, March 19, 2006 5:00 PM

Database Programming: The Oldest Performance Trick In The Book

An example of implicit conversion is offered, and a more performant construction is discussed
Posted by Ward Pond | 1 Comments
Thursday, March 09, 2006 9:30 PM

Database Programming: A Word About XQuery Performance Tuning In SQL Server 2005

The validation strategy for an earlier post is revisited in light of the newly-gained insight that Query Costing functionality in SQL Server 2005 Management Studio does not provide accurate results for XQuery statements against unindexed XML.
Posted by Ward Pond | 0 Comments
Tuesday, March 07, 2006 5:30 PM

Loading An XML Document Into SQL Server: Another OPENROWSET Trick

A quick-and-dirty solution for importing file-based XML documents into SQL Server tables is discussed.
Posted by Ward Pond | 6 Comments
Wednesday, March 01, 2006 9:30 PM

Database Programming: IDENT_CURRENT() Behavior Change In SQL Server 2005

New behavior of the IDENT_CURRENT() function in SQL Server 2005 is discussed.
Posted by Ward Pond | 0 Comments
 
Page view tracker