The status is RECOVERING? Not anything else?

Post the error log?

Michael Smith-356657 (1/21/2014)

---

I'm thinking creating the table ahead of time would be more efficient as the CASTING would make SQL process each record one row at a time rather than...

LOB_DATA is your varchar(max), nvarchar(max), varbinary(max), XML and a few other data types. They have special storage.

Typically you want to filter for 'in row data' when reindexing because reindexing affects...

SQL doesn't track modifications across restarts of the service. If you need to track that, you'll have to put some custom monitoring in place going forward.

SQLRNNR (1/21/2014)

---

GilaMonster (1/21/2014)

---

Be patient.

The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low...

That DMV only tracks data since the last time SQL was started. If a DB has had no data modifications since the last time the server was started, that query...

1) Temp tables

2) Temp tables, no, all users have permission to create those

3) Yes, kinda pointless though

4) See Books Online (the SQL help file), the page on the FROM clause

5)...

Close enough. Shared locks are released no later than the end of the query (assuming default isolation level), exclusive locks are held til the end of the transaction

Do they...

Have you considered one of the row-versioning based isolation levels?

Be patient.

The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low side

My company...

Could you post the queries?

I think it's about a minute before SQL declares an IO failure for the log. It's not instant.

When running compressed backups, SQL initially allocates a file that may well be larger than the final backup will be. This is so that it doesn't have to grow the...

I would consider myself a reasonably competent writer, English is my first language and I've been writing for years. I still, when I submit something for review, get it back...