Itzik Ben-Gan did a demo last year at PASS. It's got nothing to do with bad data. All it requires is that a page split occurs during a scan that...

I'll third the switch to read-only . Not only does it remove the need to consider locking at all, it also prevents anyone from 'accidentally' changing data in the reporting...

I got those numbers from Kimberly Tripp, and she did demos at the time that confirmed the aprox percentage where the switch was.

It does vary, as it depends on where...

I would argue that if you're getting hacked again and again, your asp code is not good.

All data access should be via stored procedures. Ensure that the user has no...

Dunno if the upgrade will automatically change the compat mode, but you can change that freely from 90 to 80 or even 70 if you wish.

Could be worse. Could be a SQL consultant in spandex....

I'd recommend full daily and log on the hour.

If you switch to simple and the DB crashes just before the diff, you've lost an hour's worth of data. If you're...

And make sure that you check on microsoft's learning site for the material covered by the exam. (http://www.microsoft.com/learning/mcp/mcts/bi/)

You need to schedule regular log backups. If you do, the log won't grow to huge sizes. The frequency of the log backup depends on the activity in the DB,...

Log backups should be more frequent than that. Every hour, every 30 min, every 15 min. The question to ask here is, should the drives of that server fail and...

SQL Agent is a job scheduler. You can access SQL agent through management studio's object explorer.

Before you send any data to the vendor, make sure you're familiar with any legal requirements in that area. I don't know what kind of data's in that table, but...

Not that one, but I did write 71-450 a few weeks back. (2008 administration)

It took me about an hour and a half. I was seriously worn out by the end,...

The term dump (brain dump) means a set of questions from the actual exams that people have posted on sites (in violation of the exam NDA) with the answers that...

The first 5 there shouldn't be run as is.

Shrink database should not be a regular task ever.

If the indexes are rebuilt, then reorganise is redundant, as is update statistics. If...