Henrik,

About those 3K byte rows:

If you have one or more BLOB columns, or simply some very wide columns, and if the columns are rarely or never used in searches,...

Oops. My post was inadvertently submitted twice. See the next post for my reply.

Gail

Henrik,

Logical fragmentation means that your data is not in the expected logical sequence in each data page. This is generally not the most efficient way to store data.

Yes, it...

Because a value of 5 tends to cause the parallelization of many/most queries which will interfere with the efficiency of your OLTP environment by not having enough CPU cores readily...

Wow! What a script!

I took the time to carefully research the OLE object creation, method, and property get calls. You did a LOT of research to get this under the...

I sometimes see criticism of posting on old threads. I think the criticism is misplaced.

Good information is never antiquated.

Thanks, Sean. I had already read that and many other posts on the subject.

My original purpose was to alter the "sp_updatestats" stored procedure reduce the sensitivity to data changes...

I apologize for taking so long to respond. I finally had a conversation with Dell-Compellent on the subject of this post.

My email to my management summarizing the conversation follows:

_______________________

I...

I apologize for taking so long to respond. I finally had a conversation with Dell-Compellent on the subject of this post.

My email to my management summarizing the conversation follows:

_______________________

I...

Thanks for the advice, Jamie.

I've fallen back to my original READCOMMITTED transaction isolation level. It should work. I don't know why it appears not to.

As you suggested, I experimented...

I substituted a TempDB table for the TABLE variable. No change.

jvkondapalli,

I am archiving data. Currently, the AUDITMSG table contains 17,303,002 rows. The OLDAUDIT table contains 69,227,085 rows. The tables are not partitioned but use different file groups. The data...

HunterJ (2/18/2013)

---

Hi Gail,

In what isolation level is the query that checks the results running? Do you have Read Committed Snapshot on?

Also, have you considered using the DELETE...OUTPUT clause to...

Why not? If the information people post is useful, what does the age of the thread have to do with anything?

When I...

Thank you all for your responses.

I've been really busy in my new job. I haven't had the time to contact our SAN vendor, Dell-Compellent, and review the situation and/or...