please don't cross post.

More discussion here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=353532

I think there is good reason to warn people of dangers, but I've always been a practical DBA, using whatever is in my toolbox and works. If inconsistent results are...

Very cool Jasmine, but you need some music on the video. Maybe the Top gun theme? Days of Thunder? Talledega Nights?

Depending on the log volume, RAID 1 or 10 for that.

I'm not sure it's worth separating out the indexes from data for 10GB, or even 100GB. Depends on your query...

OK, OK, apparently you guys can't tell the difference between 2382, the correct answer, and 2382 the wrong one D)

The question has been corrected and points will be awarded back...

Anders,

I'm torn myself, and this is likely something we'll do in the next version. A rewrite is underway as we write this, so I'll send this along.

I wouldn't refuse to work outside of hours. Heck, I could refrain from drinking during the Super Bowl and go to work afterwards if I was needed.

But it's an event...

I'd pass on the deal then. No reason that the deal can't be made on Monday.

Rest and balance are important. The more I deal with "crisis" in corporate situations, the...

Hopefully most of them have jobs

I agree that often people misrepresent their skills, but I think that often they were successful because they...

We've used Litespeed here for years, though now moved to Red Gate's SQLBackup for obvious reasons.

Litespeed works well. A little pricey, so compare the value with other tools (SQL Backup,...

Your jobs run under the SQL Server Agent service account. This account needs to log into SQL Server and likely did so because it got login rights because of membership...

In a clusered environment, you have two different instances (or more) of SQL server running. One is on each clustered node.

The service account is found in Enterprise Manager under...

You can truncate and shrink it, but if there's a process that needs that much space it will grow again. The idea is to size tempdb at it's max, so...

DDL Triggers are SQL Server 2005 only.

In SQL Server 2000 the best solution I've come up with is to log a list of object names and versions from sysobjects and...

The above advice is good and you should be able to use those ideas.

What you want to do is gather as many examples of your addresses that need splitting...