Take a backup and then shrink file, hope this might work for you.

Nag

you just miss spelled the table_name as tabnle_name 🙂 nothing else is the problem.

Nag

Query is looking good.

Nag

Can you please post your quires with some dummy names?

Thanks,

Nagesh S

Hay Jeff thanks for the response, I was bit sad that no one responded to my request.

once again thanks for responding.

Nag.

you can update stats using sp_updatestats procedure, if you still have same problem please post execution plan.

Nag

I think your results from both quires are very clear and your answer is right there, if you look at the out put 1st query (without grouping fright) grouped by...

What about the statistics and log file size?

Nag

A question from what i have understood from your question. 🙂

When both users can access each others data then why do you need different sachems?

Nag.

I dont think there is a global parameter in SSRS, one alternative way is to use report model where you can define your own data source with all the fields...

instead of using use dbname command use database name as prefix in select query like dbname.sys.dm_db_index_physical_stats, hope this will help you.

Nag

Have default collation at Sever level and change the collation of particular column as per your requirement.

Nag.

Using FOR XML you can get it done.

Providing the DDL scripts for the tables, and INSERT statements to put some test data into those tables and some sample result will...

Use INIT option in the WITH clause of backup statement, it will overwrite the existing backup file. for more info try this link

http://msdn.microsoft.com/en-us/library/ms186865.aspx

Nag.

If you restrict permissions to DBA then he should not be called DBA :(.

Nag