Gary Varga (1/26/2016)

---

Jeff Moden (1/25/2016)

---

Heh... according to the interviews I've been conducting for the last several years, people have spent way too much time crafting their resume instead of learning...

Thanks, and updated.

Need SP3

https://support.microsoft.com/en-us/kb/955725

I believe your DLL should be in

\WINNT\system32\MQOA.dll

That should be installed on your server system. Might need to add it to development.

This also might help: https://www.microsoft.com/msj/0599/msmq/msmq.aspx

I see a few posts that this should work with SP3, but can't find anything from MS about this.

Don't have a 2005 instance to check this on W2003. If you...

I'd use trace or extended events with a filter that looks at the name.

According to this, sample size changes with table size: http://sqlperformance.com/2013/04/t-sql-queries/update-statistics-duration

It looks like you might need to experiment and then tweak your setting over time to keep performance at a high...

It appears you need SP2 from SQL Server 2005, but it should work.

https://msdn.microsoft.com/en-us/library/ms143506(v=SQL.90).aspx

Those links have some code.

dinner's gonna be late

There are also the fundamental issues of newer structures not working in older versions, and how do you handle that move. I think it's easy to say we can go...

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this...

If there are only 7 days, do you mean 7 days in msdb? If the data is gone, it's probably gone.

Ed Wagner (1/20/2016)

---

I love the internals stuff. I'm currently reading SQL Server 2012 Internals by Kalen Delaney. If anyone's looking for good stuff on the internals, it's one...

If you...