Useful information in the article.

Compressed pages are persisted as compressed on disk and stay compressed when read into memory.

There is no in-memory, decompressed copy of the compressed page....

Count(1) and count(*) are technically the same. They can be different as 1 is not a column and SQL can thus leave any value.

Execution plan, reads everything will be...

Lol, Looks like the person who gave these comments doesnot follow the forums. How can somebody avoid the contribution of Gale, Kalen, Kim, a long list. Aaah he is...

If you are talking about a query that you have tried to benchmarked it can be pretty straight forward.

Just script your table and post it.

Along with that send...

Brilliant stuff, analyzing it now.

Cheers.

1st graph

<deadlock-list> <deadlock victim="processc25828"> <process-list> <process id="processbbf048" taskpriority="0" logused="28892" waitresource="PAGE: 14:1:340676" waittime="3984" ownerId="484691527" transactionname="ius" lasttranstarted="2010-09-30T10:03:22.080" XDES="0xa50f54c0" lockMode="IX" schedulerid="1" kpid="10288" status="suspended" spid="65"...

Sorry for the delay in sending the information friends. I have to be on the network on this client which I am on weekends only.

Here is the deadlock...

Okay, so recreating the table is the only way to claim space.

Sounds like a bug in the product to me.

I think this should have been at least documented...

Thanks Craig and Wayne. Once I am on that network I will forward the details of the deadlock graph 🙂

Nope Snapshot is not turned on and turning it is not an available option (I have already recommended this).

Yes I ran the query given by you and it gives...

thanks for the early reply

read committed is the server level isolation level.

This is due to the length of the string that you are passing.

Use quotes like I have used below:

This will work

xp_cmdshell 'dir C:\"Program Files"'

This will NOT work

xp_cmdshell 'dir C:\Program...