Lynn's code does that. The @num variable will containt the updated value. Try it.

Since it's an important database, wouldn't it have a backup?

You can try any disk undelete tool, providing absolutely no changes have been made to the disk since the files were...

They don't expire. There was a plan for that to happen, but didn't become reality. They are retired and become...

As for should you get certified, this blog post parallels my usual thinking on the subject

http://www.brentozar.com/archive/2009/04/certifications-are-the-icing-on-the-cake/

Got an old developer cert, all the SQL server 2000, 2005 and 2008 (except BI), one Windows Server exam and two sharepoint certs (one of which I managed to get...

Does anyone have time to go into detail on this one?

http://www.sqlservercentral.com/Forums/Topic875858-338-1.aspx

Probably a variant of parameter sniffing, from all that's been said. The procs and exec plans have been made available,...

I'm not going...

Yeah, that's due to the incorrect results bug I mentioned. The functionality was removed quite early, pre SP1. I have demoed this on 2008 RTM and there's a very obvious...

Differential and incremental are not the same thing.

Differential = changes since last full backup

Incremental = changes since last backup (full,...

HowardW (3/3/2010)

---

I don't disagree that it's difficult given SQL's architecture, but in this case (and it's not an unusual case) you're better off if plans aren't reused at all.

It was...

SQL has full backups, differential backups (changes since last full backup) and log backup (backup of log records since last log backup)

In that...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic875690-146-1.aspx

Don't understand the question.

Repair_rebuild will do nothing, seeing as the minimum level to repair is repair_allow_data_loss.

I strongly suggest that you get out a clean backup and restore. Especially seeing as this is sharepoint,...