Registration for the BI conference is open at http://www.microsoftbiconference.com/

What's the index? You can see if you have queries that are even capable of using it if you look at the first col in the index and the columns...

backup transaction mydb with no_log

will clear space as well. Then you can run the backup.

Be sure to setup log backups after this along with data backups.

Something like this

update xx

set fld4 = fld1 + total

where fld1 mod 2 = 0

for one of them. The other would be

update xx

set fld5 = fld2 +...

No, no other way around it. The thing you can do is run a report that compares version numbers. They increment by 8 if I remember, so a change of...

While I've rarely had performance issues with RAID 5, there are definitely good arguments to use RAID 10 instead if you can afford the space.

If possible, try to get an...

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...