Yup.

I'd still suggest applying SP3 to it when you have a maintenance window.

Index 255 is the table's LOB data (text, ntext, image, varchar(max), nvarchar(max), varbinary(max)). It's not a real index.

p.s. since you're on 2005, perhaps start using sys.dm_db_index_physical_stats, ALTER INDEX ... REBUILD...

Restore a backup taken before the data was deleted.

RTM means 'Release to Manufacturing' (or 'release to market'). It's the first release of a product pre service pack or patch.

One of our clients is in Microsoft SQL Server 2005...

They'll be the same. As part of the parsing/algebratisation that SQL does, IN with a list of values is converted to OR. Easy to test for yourself, write a query...

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

What recovery model is the database in? Are log backups been done? What's the recovery requirements for this database should something fail (lose a day's daya, lost 5 minutes data,...

Grant Fritchey (8/10/2009)

---

Where is the author to address the information? Please. This isn't, nor should it be, a public lynching. Your peers have raised serious questions about the work...

A boring one.... 😉

Now where's that pic of Qui-gon I had lying around.....

Paul White (8/10/2009)

---

...unless a RECOMPILE hint is added, in which case the number of rows is available to the optimizer. The deficiency is in the lack of distribution statistics....

Tuning advisor is used to get recommendations for indexes. It doesn't offer suggestions on rewriting code.

You can either submit a single query to DTA, or take a trace (a representative...

Hemantjemmy (8/11/2009)

---

good story.

One more lesson to be learned from above story to add the Maintenance Job of Truncating Transactional log files regularly so that you dont run out of...

You've got SQL 2005 RTM there (unpatched). I would suggest that you apply service pack 3 as soon as you can. Once that's applied you shouldn't see these errors any...

mtassin (8/10/2009)

---

And who determines who should be in...

I'd probably use the built-in date functions, like dateadd. They've been sufficiently tested that there should be no edge cases left.