Alvin Ramard (3/23/2010)

---

I think Paul Randall has been successful in convincing our "plagiarizer" that there was an error in his way of doing things. We just have to wait...

Are you able to re-attach the file?

I have seen where it was necessary to reattach and then detach again in order to rename.

Another scenario is the file permissions. Verify...

Nice Question. It was good to have this question and discussion.

Kenneth Wymore (3/23/2010)

---

Not to be too picky but if cell level encryption was available since SQLServer 7 wouldn't SQLServer 7 have been the correct answer? Even if it was undocumented...

What is your idea of rebuild?

Microsoft offers...

That depends. Are you running it on the same server or comparing different servers?

For my environment, I have noticed an improvement.

It will depend on your knowledge of the code running against the database. Check your execution plans.

tstaker (3/23/2010)

---

One of these days (probably nights) I'm going to have to check out what this twitter thing is. It's blocked at work. Am I the only person...

Alvin Ramard (3/23/2010)

---

Looks like he may be learning!!!!

http://sqltechconsulting.com/2009/12/25/top-tips-for-effective-database-maintenance/

Pay attention to: Exerpt from Paul Randal’s Effective Database Maintenance Tips,”

At least he's making...

I am missing the twitter debate. However, I don't agree with the defendant - guilty as charged. I read...

I figured as much and was trying to be a smart alec about it. I left...

In reference to?

I've been wondering the same thing.

What were the actual commands that you have used?

I think first and foremost is formatting.

Equally important is documentation. Leave notes in the proc. I like to use a header section also that describes what any changes...