There's a few burnouts, I think I've ran into all of them. (No, these aren't in your psych 101 class, either, just my take on 'em).

The worst for me is...

I couldn't resist......

r.vanlaake-1086273 (11/15/2010)

---

I was having a discussing with a collegue. I believe it is not wise to put a CHARINDEX in a WHERE clause because of degrading performance. He believes that...

Hey,

Couple of questions.

This requirement for 'UPPER' implies case sensitivity on your server:

so, since the 'only' thing that changed was your re-indexing, did you modify case sensitivity as well...

Sorry, can't really help you there. What you need is the proper topic to research. This...

Michael Valentine Jones (11/12/2010)

---

You might find it easier to understand it this way to overcome the confusion of -7 -1 and to just see it done with dates:

First, find the...

10% acid is 10% of the acid suspended...

Craig Farrell (11/12/2010)

---

SAN engineers tend to not want to do a proper SQL Setup, and I don't do their jobs well enough to understand why they're usually against it besides...

It's there, just got to be on the right tab. There's two sets of expressions to build in that object. One controls external properties, the other internal properties....

One problem with the simple...

If you click on the background of the package and go to options, you'll find under 'Security' an item called 'Protection Level'.

This is how you set the SSIS to store...

michaelkinlb (11/12/2010)

---

Does using a SAN for SQL Server data and log files invalidate the "Best Practice" of having .mdf and .ldf files on separate storage arrays? I would be interested...

Need to have it store the SQL password, which means you'll need to use one of the save security information options, using a package password and the like.

The other option...

Jeff Moden (11/11/2010)

---

Perhaps the following code will make it easier to explain what was going through my head when I wrote the forumula. A couple of big hints here...

Haven't seen that before, dfalso, except when I'm getting different defaults off my procedure declaration.

I know you're trying to keep the code to a reasonable length here, but this is...