I would jump at your explanation but for the fact that most if not all our joining and whereing is done using fields/parameters of duplicate type and size.

Consider a...

Svetlana,

Many thanks for the suggestion. We have already tried updatestats and also dbcc dbreindex. These made no difference at all.

I tried your script and was pleasantly surprised at how quickly it...

The following code will get you the Logical name of the Database. I believe you have sufficient info in earlier replies to use this to construct the recover query.

Declare @Script...

I have had this happen to me just once - and it was because the hard disk on which the database lived had become full. (In earlier days when I...