With a single SAN head (e.g. just one CX300) I don't think I'd waste a lot of time looking at the SAN, much more likely that you've got a bug,...

Best answer in this case is some education, best practice is to specify object owner pretty much all the time, saves SQL server from having to "find" the right object...

Don't forget to have the storage folks take a look at fabric switches as well, if only some of your servers are affected while others are just fine, look for...

With TempDb sitting at 60GB I'd take a good look and make sure that TempDB has enough room to grow as well - SQL 2005 makes a lot more use...

If you're after some serious density and compute power take a look at Sun's Sun Blade 8000/8000p Chassis & Blades... they offer a quad proc blade and each blad has...

If nothing else you can use constraints. triggers and referential integrity to enforce business rules. Ideally you could force your developers to use stored procedures, etc. for access to...

Beat your developers. A simple try/catch/finally can handle just about any error you or I can come up with, if your application is not catching the database disconnect and...

Also check to make sure you're not appending backups to an existing backup... you could very well have a file that contains multiple backups, check the contents of the...

This particular article was short on detail but also pretty telling.

The "magic" of offshoring is rapidly declining, no so long ago the cost differential between a U.S. employee and an...

I've got to chime in here, the locks question is entirely dependent on what type of activity is causing the locking. Though the poster didn't tell us why locks...

30 Hours to backup... are you going straight to tape? Take a look at a backup compression product like Litespeed (Quest), SQL Backup (Red Gate) or SQL Safe (Idera) with...

Lanny-

From your post it sounds like you're trying to identify the cause of your database growing beyond 80GB? If yes, you're likely just beginning an investigation that could take...

In the U.S. I would use a service like Melissa Data that will accept a street address in pretty much any format and return the address broken down into it's...

Probably the first question/answer I would seek is the expected time to recover should the shit hit the fan? As you've pointed out it would take "forever" to...

Ed's comments on the specific behaviors of a SUN SAN are pretty much what I was after/hinting at.

All SANs are NOT CREATED EQUAL and the specific SAN (and fabric) in...