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...

Mike B-269836 (6/18/2010)

---

I am all in favor of appropriate indentation and comments, as well as code reviews.

One of the other things that drives me nuts is cryptic naming of...

Talking about the importance of code formatting and naming conventions in the context of computer programming is like talking about fairness in the context of politics. Everyone nods and agrees...

Seeing that Google is developing it's own operating system, Chrome, I guess this move was inevitable. However, the hacking of Google's China division was a targeted attack; they can't hide...

Microsoft developers have better things to do with our time than write computer virusus and hack networks, which is why you don't see as many attacks targeting Mac and Linux.