Excellent checklist! May I add a caveat to #1: The latest patch level supported by the front end app's picky vendor (if applicable).

Very good use of narrative style storytelling. Fun to read after dry just-the-facts-ma'am articles.

One lesson the author learned that IMO needs a stronger emphasis: before INSERT (or any...

This article did a good job going over how the 'rowcount' option behaves but I didn't see how to log it to a table. Will that be part 2?

He wants you to optimize the sections that have CASE statements for him too.

Did you consider something like Ingrian (http://www.ingrian.com/) ? The way it works is that ETL passes whatever columns you want encrypted and it sends them on to the...

Perhaps there is a more deeply rooted problem here. Do the DBAs ignore or drag their feet implementing your requests to alter the objects they've kept restricted? Maybe...

I'll bet that at least one of these inequalities is causing a cartesian that is then being distincted away:

select Distinct

... and c.ProductId Between

... ...

By the most amazing coincidence, we have just discovered a developer's query is running out of tempdb space because of the following as his join clause:

where

a.acct_nbr > b1.acct_nbr

and a.acct_nbr...

John Mitchell (12/10/2007)

---

Ramesh (12/9/2007)

In Mathematics, if one cannot prove a statement is true then it termed to be as false. In simple terms, if one says a=b and he...

Charles Kincaid (12/9/2007)

---

The following aside is off-topic, sort of:

I was once quoted the following paradox:

Given set A, which is a set of all sets that do not contain themselves as...

I love the way the technical spec was written and finished first and then they came to the DBA to ask how/if it can be done. Who else has...

Whoa there! SQL would not be Turing complete without GOTO - don't be...

What that means is that each time you rebuild (not reorg/defrag) the statistics related to the index will be built at the same time

I couldn't really figure out this sentence;...

Daily copies of MSAccess .mdb file will be placed on a share.

• These copies need to be migrated from .mdb to SQL...

Dealing with XML in SS has been one of those things that looks really cool and I can think of several pet projects that could use it but I just...