The most direct way I know of is to look at the "Object Execution Statistics". It will give you execution stats on all executable objects including among others, how...

Thanks for the feedback!

Just remember - they're EVIL!!!! (cursors) 😀

You should be getting a syntax error based on your syntax, since you are missing a quote in the sp_send_dbmail call......

I do know for a fact that there are several on this board. I won't speak for them, but I wouldn't be surprised if you should hear from a...

Welcome to the hell we call...cursors.

Cursors will torpedo your performance faster than damn near anything else I can think of. Since SQL Server is built to apply changes in...

Grant Fritchey (9/15/2008)

---

Matt Miller (9/15/2008)

---

Make sure to go after the multi-threaded aspect of testing. Meaning load-testing with single threads or single connections won't show some of the real uglies...

...and again (like Grant was trying to say) - if you were to replace #AD In Lynn Pettis' example above with the query you use to create it, you wouldn't...

I'd just expand the package a little, using a conditional split. Assuming your condition is true then exit, otherwise go down the brank that has all of the preexisting...

Looks to me that you just have to move the parenthesis, as in:

ISNULL(DC_P_ACTIVE) ? FALSE : DC_P_ACTIVE

Grant Fritchey (9/15/2008)

---

Jeff Moden (9/15/2008)

---

Must be the same "sun" our guys are singing to. I talked with a couple of the more senior C# developers at this new job...

Jeff Moden (9/15/2008)

---

Grant Fritchey (9/15/2008)

---

One thing I'm aware of in our organization, and I think it's universal. Object oriented developers loathe TSQL. I've watched blood pressures visibly rise in meetings...

Agreed (not much in the way of "good" automated code review).

that being said - given the number of objects you need to review - it may be worth focusing in...

A B-tree is a B-tree. It's not an easy question to answer, since...

Ron Kunce (9/15/2008)

---

Without having much in way of a formalized change management system and in a diverse shop with multiple, yet related, database servers and databases, we have a definite...

garethmann101 (9/15/2008)

---

I would be inclined to keep it in string format so as to not lose what may turn out to be important info in the future.

But one final concern:

If...