In addition to Gail's list:

Different Parameters

Depending on what was deadlocked and how it resolves, you may not get this information. Usually, when we have a system that is experiencing deadlocks, we put a server-side trace...

If you want to literally simulate the entire user experience, with waits and everything, I'd suggest taking a look at Quest's Benchmark Factory. We've been able to use it that...

And there's always the weird stuff. We had a developer accidently drop his access to one stored procedure because he wanted to test security so he revoked his privs, but...

Yeah, true, it doesn't put in pauses. But I don't think that's the worry in this case, unless I'm wrong. Wouldn't be the first time... this hour.

Yes and no. It kind of depends on how big the machine doing the playback is since it will need to thread the calls and may not be able to...

Yeah, I'd go with Profiler as well. The only issue you might run into with that approach is if you have ad hoc SQL that is using deprecated functionality, like...

Brandie is 100% correct. You'll need to reinstall SQL Server.

Simply moving them to a seperate file will get you some, very moderate, performance gains, but moving them to their own disk will help a ton. But, it's still best...

One of these must be returning zero:

SUM(TotalMaterialValue) / SUM(TotalQuantityMade) AS AverageMaterialCost,

SUM(TotalLabourValue) / SUM(TotalQuantityMade) AS AverageLabourCost,

SUM(TotalOverheadValue) / SUM(TotalQuantityMade) AS AverageOverheadCost,

SUM(TotalTotalValue) / SUM(TotalQuantityMade) AS AverageTotalCost,

SUM(TotalTimeBookedMinutes) / SUM(TotalQuantityMade) AS AverageTimeInMinutes,

SUM(TotalTimeBookedHours) / SUM(TotalQuantityMade) AS...

You can use a variable on an insert, but there has to be a column to insert it into. You can't just throw it in as a placeholder.

And yes, it's...

I doubt there's an article out there comparing the two because they aren't really something you compare. Here's the BOL entry for max degree of parallelism and degree of parallelism....

Because you're working with 2000, this will be harder, but what you need to do is analyze the wait states and queues to figure out what you're slowing down on....

Brandie Tarvin (8/4/2010)

---

Grant Fritchey (8/4/2010)

---

Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with...

Complete agreement with Gail. Rather than knock yourself about moving the index locations (you just have to recreate the indexes and reference the new file or filegroups using the ON...