Other than that fact that there's no WHERE clause to filter the data output, I can't see anything immediately wrong with the query.

There are changes in the optimizer and...

I think testing is the way to go on any of this. But, also check the index usage stats to see if they've been used. If an index has been...

You can't do it as a batch. You'll have to create a cursor. You can just query sys.databases to get the list and then dynamically build a backup for each...

There are caveats to all this, but the article...

First, you're estimated to be moving 2.9 million rows into temp tables and that's coming from four scans against your tables. That's just to load #temp_violation. That's going to be...

Check the error log. You can see when backups were fired off there. I think, but would have to look it up to be sure, it's also in the system_health...

Jason-299789 (12/17/2014)

---

I thought all the NC...

You can get the estimated execution plan without ever running the query at all. That's the place to start.

WayneS (12/17/2014)

---

Jeff Moden (12/17/2014)

---

Koen Verbeeck (12/17/2014)

---

Brandie Tarvin (12/17/2014)

---

Brandie Tarvin (12/16/2014)

---

WHOO! #HappySnoopyDance

I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of...

Not seeing the execution plan it's hard to make suggestions as to where exactly it's running slow. Are you sure you have indexes in place that support the query you're...

Instead of MIN why not try a TOP 1 with an ORDER BY to get the dates in the correct order. You should even be able to have an index...

PiMané (12/17/2014)

---

Jason-299789 (12/17/2014)

---

The key question is How long is the window in which you have to do this and how big is the table?

having done something similar, it was a...

Brandie Tarvin (12/16/2014)

---

WHOO! #HappySnoopyDance

I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.

Current execution...

don't forget, it's not just monitoring. There are backup products, deployment, source control, compare, all sorts of tools. Be sure you explore the full offering and, again, understand what it...

There is some crossover between products across those companies, but also you should note that each company also offers some unique tools not offered by the others. Be sure what...