http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-consistency-checking-options-for-a-vldb/

Stone age, but it works. I'm there too. Print,...

Log to a table variable and then, after any...

Alternately, go to the MS web site, get the 'skills measured' list and use Books Online.

Brandie Tarvin (1/16/2015)

---

GilaMonster (1/15/2015)

---

Sean Lange (1/15/2015)

---

I am having a discussion with somebody who swears that using

EXISTS(select 1

is way faster than just select *. I know Gail has an article...

Sean Lange (1/15/2015)

---

I am having a discussion with somebody who swears that using

EXISTS(select 1

is way faster than just select *. I know Gail has an article on her blog...

In this case, you want to find an existing index that has BUSINESS_PROCESS_STATUS as the leading key column and then add the new column as a key column.

Not the system event log. The application event log.

What does the application event log say?

Is the service named "Express2008"? That's not the default for Express.

What are the command-line parameters for the service?

Well there's your problem.

Is the service still running at this point?

Please post the entire, unedited output of

DBCC CheckDB(<database name>) with no_infomsgs, all_errormsgs

If you restored and there's still corruption, it means that the database was corrupt at the time the backup...

That'll work as an average, but only as an average. Different data, different types of data will compress differently.

The backups.