You didn't specify next criteria so there will be none.

Without stopping an instance eg. http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/

Or if this will not work, run an instance in single user mode, and then add a sysadmin account.

http://technet.microsoft.com/en-us/library/dd207004.aspx

MSDN iso are pre-PIDded, you can get PID from installation media

http://blogs.msdn.com/b/streaminsight/archive/2010/05/14/where-is-the-pid-for-streaminsight-on-the-msdn-iso.aspx?Redirected=true

Use the same installation media as for SQL engine, during install check just "Sql Server Data Tools"

You could try a Process : Working Set performance counter for all process that you suspect or for all process.

May help http://blogs.msdn.com/b/chrissk/archive/2009/04/07/how-to-create-a-sql-server-link-server-with-a-different-name.aspx

Or you can install an evaluation edition on another server, restore db, remove partitioning and...

But still better solution is to use developer license.

Yes, all this operations are generating much IO, and should be performed during a maintenance window

You change a MAX_QUEUE_READERS parameter to start more activation procedures.

http://technet.microsoft.com/en-us/library/ms189529.aspx

But are you sure that it will speed up and actication proc don't need a tuning?

The name is self explanatory.

"This pane shows information about the most expensive queries that have been run on the instance over the last 30 seconds."

http://technet.microsoft.com/en-us/library/cc879320%28v=sql.105%29.aspx

Use xp_delete_file eg:

http://www.patrickkeisler.com/2012/11/how-to-use-xpdeletefile-to-purge-old.html

but maybe better will be using a very good script which create and delete old backups http://ola.hallengren.com/sql-server-backup.html

RTaylor2208 (9/3/2013)

---

You cannot shrink the files to smaller than when they were initially created. Shrinking the files will only shrink down to the inital creation sizes if there is...

Use DBCC SHRINKFILE http://technet.microsoft.com/en-us/library/ms189493.aspx or in SMSS choose to shrink a file not a DB.

Use a sp_WhoIsActive with the @delta_interval option:

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/26/delta-force-a-month-of-activity-monitoring-part-26-of-30.aspx

and you can also save the results in a table, but the @delta_interval option should be enough for you:

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/25/capturing-the-output-a-month-of-activity-monitoring-part-25-of-30.aspx

And what was when you executed:

ALTER DATABASE TestDB SET ENCRYPTION ON;

Because I can simulate this when during executing set encryption on the DB is in single_user. Then even after...