An Un-indexed Foreign Key Gotcha

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.

Drive Letter Finder

Find the first available drive letter (working backwards from z)

Using T-SQL CROSS APPLY and OUTER APPLY

That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.

T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses

Query performance can be affected by many different factors. This article introduces another best practice of how and how not to use a function within your T-SQL statements.

Substring comprehension

uniqueidentifier

Identity Crisis

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.

Ceiling, Floor and Round!

DateTime Trick