Welcome to TechNet Blogs Sign in | Join | Help

February 2006 - Posts

Tuesday, February 21, 2006 8:00 PM

T-SQL Update Operations: An Answer For Jared

SQL Server update processing is discussed in response to a question from a reader.
Posted by Ward Pond | 4 Comments
Monday, February 20, 2006 8:45 PM

Non-Technical News: New Site With Metric Tons Of Great Music

If you're of a vintage where the name "Bill Graham" means something to you, have I got a website for you..
Posted by Ward Pond | 0 Comments
Filed under: ,
Sunday, February 19, 2006 8:45 PM

Database Programming: Applying APPLY -- Solving Parent Axis Access Performance Issues In XML Access In SQL Server 2005

"Parent axis access", a long-standing performance bottleneck in accessing data stored within XML, is addressed via use of SQL Server 2005's new CROSS APPLY operator.
Posted by Ward Pond | 3 Comments
Friday, February 17, 2006 9:00 PM

Mass Versioning Of Database Components In SQL Server 2005 (or, Jeff Ball Is My New Hero)

A requirement emerged recently for our team's database platform to support multiple versions of code within a single database. The database will know which users are running which versions of our front-end components, and will also know which versions of those components are tied to particular database versions. The challenge is one of maintainability.
Posted by Ward Pond | 2 Comments
Thursday, February 16, 2006 7:30 AM

Database Programming: A More Performant Alternative To COLUMNS_UPDATED()

COLUMNS_UPDATED() isn't much help if you've got expensive code to run when the value of a column changes.
Posted by Ward Pond | 2 Comments
Wednesday, February 08, 2006 11:00 PM

CASE To The Rescue Again: Order Of Operations In SQL Server

Note that even though the ANSI SQL standard describes how various parts of the SELECT statement are evaluated, lot of it is left to implementation on how to produce the results.
Posted by Ward Pond | 4 Comments
Wednesday, February 08, 2006 6:00 PM

Finally, An Answer (and a mea culpa) For Adam Machanic

In SQL Server, if you build an index on a column, and that column is NULL in a particular record, there WILL be a pointer to that row in the index.
Posted by Ward Pond | 0 Comments
 
Page view tracker