I'll second the "upgrade to 2005" opinion. That being said, once you DO, consider changing the behavior to take in a SINGLE "large" XML with all of the records...

A few thoughts:

- The point of being in FULL recovery is to do point in time restores. If you DON'T want to do point in time restores, then...

The caveat I usually have with the NOEXPAND hint is about the same as I would with most hints like that: sometimes they hurt more than they help. In...

Keep in mind that you may find that "compatibility" extends only to the client tools and main database engine components if you do NOT have "professional" (or in Vista's case...

Without some examples and possibly the offending code - it's probably going to be tough to see what the issue is. Can you post some specifics?

Also - what build...

An UPDATE is going to cause an exclusive lock no matter what. Of course - it should be only for the length of time it takes to actually update...

Unless I'm missing something, you're setting up a query that ultimately can't be optimized using regular indexes.

Indexing isn't going to help when you're doing a WHERE clause with a leading...

ALZDBA (10/22/2008)

---

Very nice presentation indeed...

roger.plowman (10/22/2008)

---

If you deploy 36 times in one week it means (assuming your coders are coding and testers are testing 24/7) you're deploying every 4.6 *hours*.

Even with scripting languages...

Jeff Moden (10/21/2008)

---

Oh yeah... I forgot to mention that, Matt. Thanks for the reminder,

Shifting gears a bit here... What a PITA.... I hate it when they do stuff like...

Since you're not showing some fields you're using hte group by - there's no obvious way to resolve the duplicates. The bottom line is that you need to come...

Jeff Moden (10/20/2008)

---

Nicely done, Greg. And, if you want the date/time to change no matter which column is updated, just remove the IF...

CREATE TRIGGER tr_your_trigger_name

ON [YourTable]

FOR INSERT,UPDATE

AS

IF @@ROWCOUNT =...

Actually - that kind of pace is what you'd expect on a continuous integration scenario. At least to all environments except for Prod (where you probably want it a...

There's no hard and fast rule about never using IN, so be careful when you see such absolutes being advanced. In 2005 especially - take a look at the...

You should be able to go into IIS admin, and just reset the web folder this is based on to "anonymous access". Keep in mind that this may get...