Hi Suresh

Very interesting article, thank you. I wanted to clarify one point though. You talk about query performance improvement which, of course, is the holy grail with database applications, especially...

Actually that may provide the explanation. My original post was about...

Well I just ran update statistics and re-ran SP_ROWCOUNT. I still got the same figures, so not only does update stats take longer than select count... it doesn't update the...

OK thanks. Of course that makes it a little less quick if you have to do an update statistics on the table before you can query it :ermm:

This is an interesting (and much quicker) method but I found the figures returned don't correlate exactly with results from 'select count(*) from <table name>'

e.g.

Select count = 14459745; SP_ROWCOUNT...

True, but if you know there will be updates to varchars I guess it's a choice between...

OK that makes sense. What about free space? I assume SS allocates a default % headroom to each row to allow for growth and that the % is adjustable so...

Hi Gail

Very interesting and useful article on clustered index architecture. I've recently noticed a clustered index in our system with a high (43%) level of fragmentation. It's based on an...

If you mean have things improved with later versions, like SPs or the RS version with Sql Server 2005 then I would also be very interested in the...

Thanks for all your contributions. Very interesting and similar conclusions to my own.

The problem I've found with the 'Export to PDF and print from there' option is that if...

For info, we also have RS working happily on W2K3. We did install it on a fairly new W2K3 build though. Maybe if you're able to start from a fresh...