OBJECT_NAME() only works in the context of the database in which the object lives. The only thing I can think of is to extract the database_id and object_id and...

The best way to handle this in a production environment is to cap the size of the log file so it does not fill up the entire disk or you...

Did you have your Full Text Index set to update automatically, or did you have to do any maintenance on it?

The preliminary tests I have done show a drastic improvement...

I am not POSITIVE that would work. I was just trying to give you a direction to possibly look. All of our maintenance plans are through SQL Agent...

On your SSIS package, what is your MaxErrors setting for the package. We had a problem like this because if the package itself throws an error, it fill...

Thanks very much. That makes more sense to me now

It is actually an 8 hours job that runs every night to generate a mini DW, along with index maintenance jobs, extract and load jobs that all run over night....

I use sys.dm_db_index_usage_stats to find obselete indexes that have not been accessed and are unneeded overhead in the database.

I also use sys.dm_db_missing_index_group_stats and sys.dm_db_missing_index_details to identofy indexes that are missing...

Yes, boucning SQL will solve the problem, and I can use sp_lock to see what has locks in tempdb at that point in time but that can change byt he...

The DMV's hold information since the last time the SQL service has been restarted

I just created a test and it did script the include, but when I have applied index recommendations from the DB Tuning Advicor and then scripted them out, the include...

That I understand but I was wanting to find out what would be holding resources in tempdb (which process) for 8 days without releasing them

I found what I was looking for

select

j.name as 'JobName',

CAST ( LEFT(CAST(run_date as varchar(8)),4) + '/' + SUBSTRING(CAST(run_date as varchar(8)), 5,2) + '/' +...

I understand their code should not be on the server. The way our organization works, is the development teams are responsible for their own source control - and they...

That gives this error which is what I originally tried

Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72

An INSERT EXEC statement cannot be nested.