Thanks John
I dont have power to change the code but i will email the vendor to change it if possible
Now i will set the LOG file...

Hi Eric
I ran your script and this is what i got keeping the username hidden sorry i cant include the name
Kindly note that i dont have TL...

Hi Everyone
i Checked and it seems there are another 5 stored procedures which run daily and using temporary tables and below are the 2 of them. Hence i...

You know I remember that the application support guy is running reorganization and index maintenance jobs I'll check the jobs tomorrow me see what he is running but my guess...

Yeah I already knew that it's size doesn't shrink and the logs truncate but I will investigate why the size jumped from 100mb to 2gb overnight when there are no...

Thanks guys

@eric wow a 1GB temp file I have 4 files at 500MB and the log is at 50MB

Excuse my question but during a full backup is anything...

Thanks everyone for the help
I just wanted to know what is the general rule of thumb for setting the tempdb
I would think it depends on the following...

I wanted to know the thoughts of the MVPs and yes i think they can create a better query but before going back to the vendor i wanted to get...

Ok so i will increase the file sizes to 500MB each and add 4 more just to be on the same safe side
What is a good size to...

Hi Eirikur

Here are your answers

1. Full
2. Backups are done via EMC:
Differential is done daily
Full is done once a week and monthly...

Hi everyone
First i wanted to say thanks for all the help
I was able to run the script i created and it took 5 mins
Here is...

Hi Thomas
Answers to your questions