Update stats on that table manually, see if you get the same error. If so, update stats one by one, see which one gives you the error. Look at what...

It could, yes.

My question was, if there is no way to insert/update/delete rows in some of...

DBCC CheckDB WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY

If you do a SELECT * FROM TableName do you get the same error?

wolfkillj (10/7/2013)

---

Well, there is a definition of "wonderful" as "unusual" or "of a sort that causes wonder", without the value judgment of the more common definition as "excellent; great; marvelous",...

thisted (10/7/2013)

---

I was under the impression that when I would see the 'create procedure' in the sp_whoisactive that meant the SP's were recompiling. My bad. What does that mean...

There's nothing there to suggest anything is recompiling. In fact, if those procedures were in the middle of a recompile they couldn't be causing blocking as they'd still be in...

Maybe. Test it and see if that index helps with the performance of the application. If it does, implement it. If it doesn't, don't implement it. Either way, it's not...

That's generally a bad idea. Anyone who's...

Don't shrink the log.

Take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/

That's actually...

Jeff Moden (10/5/2013)

---

I have a similar problem that turns out to be some rather inefficient code that truncates several very large tables and reloads ALL of the data from an...

Do you want to disable data integrity constraints in your table? Do you want to potentially allow bad data in and have...

Not enough information to tell. A single data point is never enough to say anything decisive.

Bear in mind that SQL is a server product, it's more like Exchange or Lync than Office or Visual Studio.

Drop the clustered index = recreate the entire table and rebuild all nonclustered indexes

Create the clustered index = recreate the entire table (again) and rebuild all nonclustered indexes (again)

Given that,...