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...

Eirikur Eiriksson (1/19/2016)

---

WayneS (1/19/2016)

---

Eirikur Eiriksson (1/19/2016)

---

Suddenly everythings is so quiet, no notifications or emails blimping on the phone, not a single message since early afternoon, am I lucky or maybe...

create a .NET project to do so: https://support.microsoft.com/en-us/kb/555070

http://www.codeproject.com/Articles/18147/Accessing-MSMQ-from-Microsoft-SQL-Server

Could use sp_oaMethod as well: http://stackoverflow.com/questions/11550593/is-there-any-straightforward-way-to-send-a-message-to-msmq-inside-sp-in-sql-serv

AFAIK, there are no native interfaces inside of SQL Server to access MSMQ. I would recommend SQLCLR.

Disclosure: I work for Redgate Software.

We, obviously, sell a backup product. Prior to SQL 2014, the security advantages of encryption were a bigger selling point. With 2014 +, if you...

Not quite enough time to completely debug, but if you're on SQL 2012+, you might be able to use windowing functions and an OVER() clause to help.

A couple of things....

I think you've hit it. Each test runs as a separate tsqlt.run call rather than a larger call with all results.

At the end of the day, I really only worry...