Hi,

Sounds like a nice idea and i'm sure the performance would be great (Is it necessary?), but...

SSD have a certain amount of read / write cycles and the TempDB is...

Seems like a great moment to clean up and implement a better security structure.

Are all 1500+ reports in use?

Is it possible to do this over an extended period of time?...

Hi,

You'll need to download AutoIT to use this. With it you can alter and compile this script to an executable. http://www.autoitscript.com/site/autoit/

Obviously you'll need to tweak this script for your own...

Thanks for your input.

I think I will have to rebuild, shrink then rebuild again.

Rebuilding the index releases any freespace from the table. (As shown in my test code below)

Shrinking will...

Using profiler will give you a good way to find long running queries.

The standard tsql_duration template should be fine.

Just start running it. You can filter the data collection using the...

Have you looked into creating your own script to do this?

I have an AutoIT script that checks the file dates and deletes files older than 1 month that are not...

I have had success shrinking stubborn log files with this code.

Never used it on a mdf before though. A backup might be in order before trying.

Don't know what your...

This may also help :

SELECT * FROM [LinkedServer].[Database].sys.tables

Is_Linked might have to be 1 in sys.servers on the server you are quering from.