RTaylor2208 (8/27/2013)

---

You can use the free RML utilities by microsoft to perfom this very action

http://support.microsoft.com/kb/944837

Not the easiest apps to use but very effective.

PRR.DB (8/22/2013)

---

Are you running this as a query from SSMS from your local machine?

yes..

sql-lover (8/22/2013)

---

SELECT ss.sum_execution_count

,t.TEXT

,ss.sum_total_elapsed_time

,ss.sum_total_worker_time

,ss.sum_total_logical_reads

,ss.sum_total_logical_writes

FROM (SELECT s.plan_handle

,SUM(s.execution_count) sum_execution_count

,SUM(s.total_elapsed_time) sum_total_elapsed_time

,SUM(s.total_worker_time) sum_total_worker_time

,SUM(s.total_logical_reads) sum_total_logical_reads

,SUM(s.total_logical_writes) sum_total_logical_writes

FROM sys.dm_exec_query_stats s

GROUP BY s.plan_handle

) AS ss

CROSS APPLY sys.dm_exec_sql_text(ss.plan_handle) t

WHERE t.TEXT LIKE '%PROCEDURE NAME HEREt%'

ORDER BY sum_total_logical_reads DESC

Lowell (8/6/2013)

---

WinMerge, which is free, can compare folders vs folders or files vs files, and identifiy differences:

http://winmerge.org/

will that do what you want?

curious_sqldba (7/23/2013)

---

i) if a table has no clustered index and has non-clustered indices, do i need to compress the table first and then the nc indices?

GilaMonster (5/30/2013)

---

No. A restore always recreates the database as it was at the time of the backup. That includes the size of all files.