I am also an administrator on Wiktionary and have been for over 3 years. I edit mostly in French, Dutch, English and Mandarin, but I also dabble in Italian, Japanese, Maori and Swedish. We are constantly looking for competent volunteers/lexicographers to contribute to this wonderful multilingual dictionary website.

Index defrag takes forever to runI give you the credits for sound advice which helped me resolve the problem. I will start looking at other options than reorging the indexes every night. Have updated my answer with the resolution.

Index defrag takes forever to runThis is a legacy Agent job left over from previous DBAs. I will give reorganize a try tonight. It still doesn't explain why all of sudden it's taking more than 20x longer for the defrag to complete though. The clustered index has 2,146,312 pages in total and the table has 234,001,728 rows.

Find old linked servers on a restored copy of master/msdb dbI was not able to look up the definition of sys.servers, but was able to look up sysservers which is a view that uses sys.servers. I connected using DAC and did a select on sys.servers, but the results were the same as what's stated in the question :(...

How to see the value of a variable being used in an sql statement during a server trace?I figured it. Looks like we don't need the last parameter. This is what I did: declare @@oldcust_id varchar(10) set @@oldcust_id = 'daf' exec sp_trace_generateevent 82, @@oldcust_id. Two changes here: 1) I removed the 3rd parameter. 2) I unquoted the second parameter. If your parameter is something other than a varchar, than cast it into a different variable and use the second variable instead of the original one.