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.

One really bad data modeling mistake that can appear to work fine fine for months or years in production, but then present a major headache down the road, is when...

A web browser is like an external door on a corporate building; it's where people enter and leave the network. Even if hackers found a way to biggy back an...

Reading articles related to the attack on Google, I am left with the impression that it was a security hole in IE6 that was exploited, not necessarily Windows. What is...

Thomas-282729 (6/9/2010)

---

RichB (6/9/2010)

---

Thomas-282729 (6/8/2010)

---

Again, what you are suggesting is a poorly written query where the developer uses the wrong alias (A.Id instead of B.Id). How does that improve clarity in...

You mentioned earlier that your application may on occasion be executing this procedure thousands of times per second. There are several different things that can cause blocking. One is blocking...