Thanks.

I created this as a view, based on this view I create a another view that joins some other tables, performance wise the second method and third one runs a...

Thank you, I tried 3 methods, I like the first one best. then 2nd, then 3rd.

I can understand them, but just cannot think of how to make it like this...

Sorry, I didn't notice the schema.txt change the format. I did try the script to create the tables, and then I save it, but it didn't allow the file...

Ok, here is the reduced size sample data.

Thanks, I just added the attachment.

Thank you a million, Jeff.

Thank you, ColdCoffee,

It works perfectly.

The function seems a very useful one

I wish I have created the tables.

But the tables have already existing there like that given to us, I just help with a query.

I cannot change the table structure in...

Thank you, I will give it a try, might need to upgrade the report in visual studio and redeploy it.

I found out the report runs fast on a 2005 reporting server, but when the same report is on a in-place upgrade 2008r2 server, it runs slow.

Or it only refreshes schema-bound view, but do not refresh non-schema bound view?

Thank you, will give it a try

Thank you very much, that helps a lot.

GilaMonster (4/23/2012)

---

It's the size of that particular object, so the entry for index id 1 will show the size of the table (because that's the clustered index), the entry for...

Here is the query:

SELECT OBJECT_NAME([object_id]),index_id,SUM(record_count),SUM(page_count)

FROM sys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,0,'DETAILED')

GROUP BY OBJECT_NAME([object_id]),index_id

ORDER BY 3 DESC

My question: do the record_count and page_count mean for both data and index, or for index only?

Thanks,