charles.gildawie (8/20/2010)

---

A precomputed column for the sequence can lead to problems when someone modifies the data. Say a date changes then you'd need to resequence all the rows at the...

The article does present a good educational example on the use of CTEs and the RANK function. However, I don't think ranking is the most practical and efficient solution to...

A little off topic maybe, but below is a possible technique to hash demographic or personally identifying data for a QA or Development environment. The distribution of the data remains...

The [Services].[ID] column is part of your PK, and you havn't made it clear why you need to insert the table while leaving that column NULL. From what I see,...

When I am developing a stored procedure for reporting purposes, something that is driven by one or more sets of parameters, the parameters are typically contained in a table. I'll...

Jeff Moden (8/10/2010)

---

...

For all of you good folks using XML to split things... I suppose that XML either does something special for you or that your consider its performance...

I'm surprised by some of the strong emotions expressed here regarding the issue of doughnuts and bagles. You sound like a Dilbert cartoon and are reenforcing negative stereotypes about those...

thisisfutile (6/30/2010)

---

Typically our boss brings in donuts on Friday. From time-to-time he doesn't bring any. According to some of the attitudes on this forum (but not exclusive to...

I once had a consulting gig at a .com company that managed to (barely) survive the dotcom bust but employed a skeleton crew of about 40 employees, which was a...

niall.baird (6/23/2010)

---

Commenting:

I like to see a comment block/change register at the top of each stored proc/function, something like

/* ************************************

Name: pu_mytable

Purpose: Updates dbo.MyTable with values from...

Steve Cullen (6/22/2010)

---

I have never found schemas usefull or necessary. They always seemed like a solution in search of a problem to me. I also never like the...

I don't think it should be considered a technical best practice to either use or not use schemas; I think it mostly just an extension of one's overall naming convention,...

Any thoughts about how to comment a block of T-SQL ?

I do this often, but over time I havn't been consistent with it.

/* begin: What I'm doing here...

Here is how I would format the same SQL. I like all lowercase and indent my joins, which makes it easier to read when there are four or more joins.

select

...

ken.trock (6/18/2010)

---

Also, I think it's important to capitalize keywords too. Something handy for that is using highlight the keyword you want to upper case and use Ctrl+Shift+u. Back to one...