When we migrated from 2000 to 2005, we left the DTS packages as DTS instead of migrating them to SSIS. It seemed like too much work at the time, since...

What are you trying to accomplish ?

Since the script is based on sys.dm_db_index_usage_stats, it only returns unused indexes that exist in sys.dm_db_index_usage_stats. Other unused indexes can be found by a different query with "WHERE NOT EXISTS...

How many do you have ? (To have...

After you set back to Full Recovery, you need to take a full backup because you have broken the log chain.

Full backup just once a week ? If it's production, you could take DIFF backups during the week so that you don't have huge numbers of transaction logs to...

You CAN shrink it. Doesn't mean you SHOULD shrink it. Shrinking causes fragmentation.

Leave it alone and as your database grows again the space is already allocated, so you don't lose...

Sorry for the newbie trace question...

Looks like your Stored Proc "sp_AddMyTrace" starts the trace, but how do you know the traceid to stop it ?

What do you consider long duration...

If you search "shrink tempdb" you will find some good threads on this topic.

I think the original version of SQL 2005 did not let you script one file per table, but everyone should be on at least SP2 by now.

Is there a way...

gmartin (6/11/2009)

---

Cool. I only want it for Selects.

So, last question. What would be a good way to set it back to default?

Set Isolation Level Read Uncommitted

begin tran

...

This will dump all the MDF & LDF file drive letters to a table, then you can select distinct. Probably a better way though

CREATE TABLE dbo.DBFileLocations

(

DBName nvarchar(50) NULL,

Physical_Name nvarchar(260) NULL,

Drive_Letter...

Thanks for the info. I should have read the earlier posts a little more closely.

I don't understand the distinction between profiler & server-side trace. If I go into profiler and script out the trace from the GUI, it gives me the same script that...

Lumigent Log Explorer is another product. Not sure if it would help in this case.