You should not be shrinking your files as a regular part of your operations. If you are, that's indication of problems somewhere. It does sound like you're in Full Recovery,...

I'd look to see if there are blocks of some sort going on in production, but other than that, I'd want to see more data gathered. You said the servers...

I go with PowerShell and use remoting and then you can thread it and fire it on every server, all at the same time, no issues. Here's a small blog...

There is no alternative tool. That's the best one.

You will absolutely need to plan for thorough testing. One of the issues we found early on when migrating to 2005, but...

yes, the problems do occur in the engine, but they're very rare. If you're hitting them all over the place, then I'd suggest one of two things is true. You...

Nuts. I'm slow. Yes, the Upgrade Advisor is the best source for this information. It's the required first step to perform this kind of upgrade anyway. Follow Microsoft's documentation. It's...

It's possible you've hit a regression, a piece of code that worked well in 2000 but not so well in 2008. Usually this happens on code that is problematic to...

The traceflag puts a lot more information than that into the error log. You should be able to get the database id, the spid involved, the exact resources at the...

If updating the stats works, then are you updating stats in production? Is production on a different version of SQL Server? If so, it's possible that you're effectively performing an...

The amount of work to DELETE your data down to 5% of the size of production is probably just as much work to INSERT data up to 5% of production....

First thing that comes to mind is that it's the compile time. Probably not since the next query can run much quicker. Second thing that comes to mind is that...

Jack Corbett (5/4/2011)

---

GilaMonster (5/4/2011)

---

Jack Corbett (5/4/2011)

---

Hmmm, I'm surprised that they wouldn't allow you to present jointly with Adam since all the training wouldn't be on your shoulders and Adam has...

Whether in Simple or in Full, you need enough space in your log to support the transactions you put through it. Exactly what that size represents is something that you...

Did I find any difference between what and what?

The right protocol is the one that supports your network. If you are on a network that doesn't have TCPIP packets (which...

You can't do both. If your database is in Full recovery, you have to run log backups. If you don't want to run log backups, you take the database to...