Viewing 8 posts - 136 through 143 (of 143 total)
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...
July 3, 2012 at 6:13 am
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?...
July 3, 2012 at 6:06 am
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...
July 3, 2012 at 4:53 am
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...
July 3, 2012 at 3:58 am
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...
July 3, 2012 at 2:00 am
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...
July 3, 2012 at 1:43 am
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...
June 14, 2012 at 3:11 am
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.
June 14, 2012 at 3:00 am
Viewing 8 posts - 136 through 143 (of 143 total)