I myself was strugling to remove the existing unwanted indexes on the system and may be adda few more, if needed.

I ran the DB engine tuning wizard with...

1. gzip to copy the backup files. it will reduce you files to few mb's and thus less time to copy.

OR use SQL redgate - it too reduces the...

distinct didnt work, same number of results. Each Index is being repeated 6 times.

The only columns where the value changes are:

--sys.partitions (partition id,hobt_id)

--sys.allocation_units (allocation_unit_id,container_id,total_pages,used_pages,data_pages)

--computed column - index size (which...

ha...... good one...... what do i write on.... on my life?

I checked the web and there was a solution to create a proxy account, but i am not sure how. will it help?

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(2030)-restarting-a-log-backup-chain-requires-a-full-backup.aspx

gave teh detailed explanation and cleared few myths too!

Works perfect. Thank you.

We are using a query and in its execution plan it utilizes 182% CPU cost while performing a sort. Please advice on how to reduce it.

query structure:

SELECT DISTINCT

'Dupility'...

A wild guess, but check out ssma..... it might help you in migrating the objects.

its a free tool by ms

Did you try the copy database option in SQL:

Using the copy database wizard

Create a package to copy the database on the same server with different DB name

Use the copy using...