Just bear in mind that the data in that DMV is since the last time the DB was started up. So if you restart the SQL instance frequently or have...

Douglas Murphy (2/8/2010)

---

I am wondering if I upsize the access back end file to SQL Server 2005 with compatibility mode set to 80 and then detach it if I...

Try a nonclustered index on (BlogID, Page, Deleted) on the DIM_Blog table

If you change to full recovery, you have to be running log backups.

Please read through this - Managing Transaction Logs[/url]

What's your reason for switching from Simple to Full? It's not...

Joan OBryan (2/8/2010)

---

The easiest way I found to recover in this scenario was to take the database OFFLINE (not detach!) and then bring it back ONLINE in Enterprise Manager. This...

Barkingdog (2/8/2010)[hrFor example, a field declared as varchar (100) will generally use less space than one defined as char(100). Assuming, of course, the data comes in a variety of lengths....

Windows Server 2003, Windows Server...

The first draft was a little more vicious. I revised it before posting.

I have...

I would highly doubt it, no more than you can apply SQL 2008 SP1 to SQL 2005...

Steve Jones - Editor (2/8/2010)

---

Actually I think this is the way to do. So many people have complained about features in SPs, myself included. I prefer SPs to be just...

Maybe, maybe not.

Depends how big the DB is, how long it takes to backup full, diff or log, how long the restores take, what the downtime allowance of the...

Because it's not a service pack. It's a set of add-ons for SQL...

A copy_only doesn't reset the differential base. That's about it.

Depending on how active the DB is, those diffs may not be appreciably smaller than the fulls over a period of...

A suspect DB has to be set to Emergency mode before CheckDB can be run. There's a brief (one sentence) mention of running CheckDB in Scenario 3, right before the...

You could make every backup other than the sunday backup a COPY ONLY backup, however there's some problem in restoring copy_only backups using the management studio GUI (T-SQL script works...