Thanks for the question.

Though I think it would have been better as a multi-select question. (Of course that would have caused more problems with the multi-server administration option.)

You didn't include the restriction on the index_id in your query on the DMV, so that might be the issue.

Try this and see what you get:

select

sum(row_count)

from

sys.dm_db_partition_stats

where

object_id = object_id('dibs_tmb_saalist')

and index_id in...

Thanks for the question, I think it is good to help people understand the limitations of TRUNCATE TABLE.

Thanks for the question.

Oleg Netchaev (10/19/2010)

---

Very true indeed. I did have quite few unfortunate years in my career when I had to work with Oracle databases. I remember it used to really frustrate...

I answered it correctly because I knew what the author was talking about, but for myself I will stick with COUNT(*). (It runs in under 2 seconds on our 70...

Interesting question, but even better discussion. Thanks all!

Thanks for the question!

Thanks for the question.

As a note I have always hated the round "to even" method that Microsoft sometimes uses.

Is the extractor utility available to people that don't have a LiteSpeed license? (For example if someone is sending me a backup they created using LiteSpeed and I need to...

Thanks for the question.

I almost didn't notice, and was think this is exactly the same as the question from a few days ago......

Nice question, thanks!

Mohammad Meimandi (10/7/2010)[hrWell as far as the application is concerned no error has occured here. The SQLDMO pulled all objects and scripted them successfully. Only when running the generated script...

Nice article, I think it is good to bring light to this situation.

However, I think it is interesting that you only found the problem because of bad data on a...