Quite a lot in areas that I work with frequently. When I can't remember...

Clint (5/13/2009)

---

I could restore the diff backup that was created 1st after the full backup. I could also skip a few diffs after that one and restore another. ...

Do you mean that you just copy the database files (mdf and ldf) somewhere for a backup? Do you stop...

Doesn't matter. The extension doesn't set the type of the...

Awesome. I know what google I'm going to use when I have to do a search for someone here now.

Agreed, and if you're going to be using VMs and SQL, get...

Run it often enough so that should it find corruption you can restore backups to fix it.

Once a week is often a good place to start.

Can you stop the SQL Server for a short while?

I'm guessing that SQL's making a bad estimate based on that top. Not sure why. Can you post the two execution plans? (Saved as .sqlplan files, zipped and attached)

Suggestion on...

Is the BuiltIn\Administrators group there? Is it sysadmin?

Are you a member of the Local Administrators group on that server?

Jeff Moden (5/12/2009)

---

I'd prefer a 17" display but will go with a decent 15" display. Of course, it needs to be able to handle presentations and a couple of different...

Ok

Someone started a transaction on the 7th May and hasn't committed or rolled it back. You can either kill session 66, or find out who's running it (using sys.dm_exec_sessions) and...

Take a look at this url: http://www.microsoft.com/learning/mcp/certifications.mspx

As for sample questions, most of the stuff that you'll find online (testking and the likes) are braindumps, questions taken from the actual exam...

Yes.

Mirroring is per database, not at a server level. The system databases on the two servers are completely independent.

John Najarian (5/12/2009)

---

In a query it is better if the table with the least rows is to the right of the join than the left. The table scan...