What exactly do you mean by 'logical' backup and why do you want one?

You tried to insert into a page that did not have enough space. Can't fit. So SQL allocates a new page, moves half (or other fraction) of the rows on...

Did you read the article I referenced?

Clustered indexes don't have to be unique, though it is recommended.

Discussion on clustered indexes

http://www.sqlservercentral.com/articles/Indexing/68563/

patrickmcginnis59 10839 (9/4/2013)

---

GilaMonster (9/4/2013)

How would they go about that?

I'd love the lower-level certs to be respected. I'd love to be able to interview someone with a lower-level MS cert and...

That works OK for tiny databases. Over a couple hundred MB, that generally crashes Management...

Braindumps, bootcamps, not technically rigorous. For example, there's only one exam to test a candidate's ability...

Script all objects (not the data, just the objects)

Create the new database

Use import/export, SSIS or bcp to move the data

'k. The earliest I could get started is after PASS. Too much happening before that.

If you don't mind waiting a few months, I can pick this one up.

If you don't mind waiting a few months, I can pick this one up.

If the log needs to be 30GB to accommodate the daily activity (probably lots of inserts/deletes in single statements), then leave the log file at 30GB. It needs to be...

Really? Why didn't anyone tell me that?

patrickmcginnis59 10839 (9/4/2013)

---

At the same time, Gail offers that some of these barriers are falling, but I'm not able to find any details on that, anybody know what the actual...

I would disagree. The MCM is not an architectural certification (that's the MCA, which required a significant amount of architectural experience). The MCM was a technical certification, implementation, not architecture.