if there are allocation unit is present in sys.dm_os_buffer_descriptors but not present in sys.allocation_units then does that mean those are used by SQL server internally. On my DB I see...

Thanks Lutz, I got the DelimitedSplit8K function from this site itself and your code works perfectly well after using that.

Thanks a lot for the help

thanks Jeff for the guideline... I ll be careful in posting the queries next time the way you have suggested.

Thanks Lutz for your code snippet.however your code cannot be...

The number of rows in the real table can be 10,000 to 30,000

yes i was referring to SQL Server 2005 Business Intelligence Development Studio.

thanks

ritesh