Word on the street is that a new cert for 2014 will be out very soon. But, as Gail says, it's not here yet.

I have not seen it have a negative impact on...

Lynn Pettis (2/15/2015)

---

TomThomson (2/14/2015)

---

Lynn Pettis (2/14/2015)

---

TomThomson (2/14/2015)

---

Eirikur Eiriksson (2/7/2015)

---

Tom, must say that I find this comment...

Almost down to the single digits.

WHOOOP!!!!

kkp40 (2/13/2015)

---

Nice.

I would like to read about how to use the execution plans to understand what to change in my sql-query, or in the table, to make it better.

I can...

I agree. This looks like standard parameter sniffing gone wrong. It's always about the data and the data distribution. The parameter values passed from one create a plan for retrieving...

Prior to extended events, I had trace running 24/7 on a lot of systems too. It's work to deal with the data generated, but it's a great way to gather...

dwain.c (2/5/2015)

---

I am surprised and somewhat relieved that I am not entirely full of crap, despite what others may be...

It means that traceflag is not enabled on your system.

Thanks for the kind words.

What if you just work on the inner part of the apply query. Can you get that to filter on it's own, either by changing the...

OK. Regardless of the logic, just add a step with that logic.

Then you can individually go through and REVOKE privileges too.

You can use ddl_admin. But, you may also have to give them security_admin in order to set permissions on the procedures they create.

3 million rows filtered down to 9 by a late filter... Ouch.

Since you're only going for the first row within the cross apply, why not change that to a simple...

Aren't they scheduled through a SQL Agent job? Just add a step to the job to move the files using Powershell.