Viewing 4 posts - 1 through 4 (of 4 total)
mysearchresult (9/9/2011)
GO
SP_SPACEUSED 'yourschema.yourtablename'
GO
The above gives the number of rows and other information regarding the table. This is the faster way to see the number of commited rows in a...
September 9, 2011 at 11:43 am
HowardW (9/9/2011)
What are you using the counts for that requires them to be so accurate to a point in time?
It's record counts for customer data imports. Truthfully it's probably...
September 9, 2011 at 9:32 am
Thanks for the feedback, much appreciated.
June 30, 2011 at 11:12 am
SQLkiwi (6/30/2011)
Code sprinkled with index name hints and (nolock) in particular is rarely good code, in my experience at least.
That was my gut feeling. We have members of the...
June 30, 2011 at 8:57 am
Viewing 4 posts - 1 through 4 (of 4 total)