I use the following script to put the freespace in a table.

set @sql = 'insert into #TmpFS select * from OPENQUERY ([' + @ServerName + '], ''SET...

Interested in an example?

In my company we have a internal system (tracking the performance of employees). Everything was in unicode, department codes an so on. The system has an performance...

I'm working at an insurance company. Car insurance and travel insurance are different tables, but account numbers are unique. Okay, we resolved it another way, because we have DB2, SQLServer,...

Mayby you can use the Microsoft Health and History tool, especially the performance collector add in.

An article here at sqlservercentral describes the tool: http://www.sqlservercentral.com/columnists/kKellenberger/sqlh2thefreehealthhistoryandperformancemonitoringt.asp

The advantage of a sequence is that it can be used for more than one table.

DTS uses bulk copy. So, in most cases DTS is faster.

Sorry, i was a little short in my answer.

Blocked by -2 means it's blocked by an orphaned distributed transaction. Look it up in books online by performing a search on...

blocked by -2 means that the proces is blocked by a distributed transaction.