that is the exact query i run, nevertheless i'll post the same results again.

what does scan count mean?

(1 row(s) affected)

Table 'EntityCollection'. Scan count 9, logical reads 311554, physical reads 21061,...

ah well, guess im stuck with this proc.

i still get an inaccurate count of rows in my table using the following statement

SELECT o.NAME, p.OBJECT_ID, o.type_desc, p.rows

FROM sys.objects o

INNER JOIN sys.partitions p ON o.OBJECT_ID = p.OBJECT_ID

WHERE

p.OBJECT_ID = 117575457

can...

i need an accurate count

i've run the following

DBCC UPDATEUSAGE ('Wallet0000', 'EntityCollection');

GO

SELECT rows as Count FROM sysindexes WHERE id = OBJECT_ID('[EntityCollection]') AND indid < 2

but i still get a different count to

select count(*)...

anyone? 🙁

does the DBCC UPDATEUSAGE have to run everytime i do a count from my table using sys.indexes

seems like i found something that may help me retrieve the count much quicker

SELECT rows as Count FROM sysindexes WHERE id = OBJECT_ID('[EntityCollection]') AND indid < 2

what are the advantages...

this is what the Client Statistics looks like

Client Execution Time12:26:22

Query Profile Statistics

Number of INSERT, DELETE and UPDATE statements00.0000

Rows affected by INSERT, DELETE, or UPDATE statements00.0000

...

i cant stop myself from clicking the execute button, just to remind me what a huge difference it is... 😀

all of it worked with some minor tweaking but the CTE worked the best, its weird though because i was testing the use of a table variable but wasnt seeing...

sorry bout that, will follow posting hints better next time

firstly, thanks for all the replies...

ive tried various options, but so far the use of a CTE gives me the best result

though i am still busy testing

Are there any disadvantages...

anyone? 🙁

http://www.sql-server-performance.com/articles/per/Monitor_Stored_Procedure_Performance_p2.aspx

for ur viewing plueasure:-)

found a few articles pertaining to monitoring stored procs using Dynamic management views (DMV) and Dynamic management functions (DMF), basically utilizes the cache to return statistics. Problem is i cant...