...maybe Microsoft should drink its own KoolAid. After all - Team Foundation Server seems to heavily promote using an Agile development, which among other things, would imply that pretty...

First - you might care to implement this as an INSTEAD OF trigger, since you're running an UPDATE in an UPDATE trigger (if anyone changes some of the database settings...

Turn Auto-Shrink off (or - leave it off since that's the default setting). If you DO have to shrink a database, at least you should decide when you are...

We had a lot of the same challenges, until we started publishing IT's to-do list as part of the documents going out with the roundtable announcements.

It sometimes helps...

It's even more confusing than that. They now seem to have the "deprecated"...

Then - focus on getting the cert, and then perhaps ask him what kinds of things you should focus on (there are several "kinds" of DBA's and not every shop...

I agree - there are lots of questions that are highly detailed in nature, that unless you happen to work with a LOT, you're going to have trouble remembering. ...

dharris (1/29/2008)

---

Thanks for the reply. The reason I brought this up was the application seemed little slower, wasn't sure if this was the cause. Either way I'll do a shrink...

That is a cute one there Jeff.

By the way - any one notice the little poison pill they snuck into the Deprecated features about the %$##%%^&* semi-colons? They're going...

I'm not sure I follow. SQL Server has given us the ability to use XML to create said snapshots should you desire to do so - but it's not...

Having been burned before by MS' hype - I was almost ashamed to say - I was entirely expecting this to happen. It's annoying as all get up, and...

All due respect, but the connection pooling when dealing with SQL server CAN cause SQL server to "hang on" to various things. especially if it's detecting dropped connections. Meaning...

Are you licensed for the Team Suite? Because if you're not - I'm not sure where you would download DataDude from.

If you ARE licensed for it and have only...

it's never quite what you expect...for XML explicit is tricky, and particularly due to the ordering.

you're right - it did end up creating the reports level (I didn't think it...

I'm not sure why you haven't seen this error yet, since there seems to be a logic flaw in how you're building level 4.

To highlight it:

SELECT DISTINCT 4...