TheSQLGuru (7/24/2008)

---

I respectfully submit that someone with years of training and experience may well be able to develop an indexing strategy much better than you are able to do, so...

Thanks Gail. I appreciate your advice. I will get the network guys onto this.

I've started investigating the TempDB and its greater role in SQL 2005 especially. There are...

It's on a 64-bit server, I don't know the exact layout and specs, but I think it's time I did.

It's not a large database and not clustered or replicated or...

We rolled out the queries using WITH (NOLOCK) overnight, and have just passed the peak hour of daily use on the form which uses these queries, and haven't had any...

Hmmm... I thought that the read-committed row-versioning (as opposed to JUST row versioning without the read-committed option) would allow distributed transactions and distributed queries.

But maybe it was just the former,...

Thanks Roy, for explaining that.

We have been running into some deadlocks lately, due to one main sort of Lookup form our app uses. The number of rows generally returned...

GilaMonster (7/22/2008)

---

It's not so much what it does (which the others have covered), but what it doesn't. Nolock does not solve performance problems. All it does is solve some of...

I've seen several articles and posts where there's a lot of disagreement on the "danger" of using WITH (NOLOCK), but nothing that says specifically why except for "you get dirty...

Thanks for the concern guys, but in this particular instance, I don't think WITH (NOLOCK) will be a problem. The data is not changing rapidly enough to be of...

To tell you the truth, we worked out what the bottleneck was all about.

Apparently a rather complex query we're running to simply track data (so it doesn't have to be...

Thanks again Steve!

Had I not been so lazy, I could've looked back at the example I got from someone prior to yours and noticed that it used the '?' as...

Hi Steve.

Thanks again for your help on this. I had time to test it out today, and it worked a treat!

Now, I just have one more issue with this... on...

If it helps add any fuel to the case for upgrading to 2005, I heard there is a site called SSIS.com or something which I think is the sister site...

Hopefully one of the other posters will get back to you.

We upgraded from 2000 to 2005 about a year ago, and prior to that I tried to avoid DTS like...

Hi Michael. Let's just say that we're starting to take over some of their processes and they're a bit bitter about it... so I don't think they're going to...