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

Excellent point. Not something I tend to think of since I try so hard to avoid hints.

jvila (12/16/2014)

---

Hi, we have a table, with 10 indexes. This is the columns included

[font="Courier New"]

Name |Writes | Reads | Columns | IncludedColumns

-------------------------------------------------------------------------------

INDEX A| 15.112|2.117| BB,AA with included columns CC,EE

INDEX B|...

New Born DBA (12/16/2014)

---

Grant Fritchey (12/10/2014)

---

It depends on how your virtual environment is set up and managed. Many of them use physical storage, not virtual storage. In fact, a pretty...

Jeff Moden (12/16/2014)

---

Gosh. I can't believe that the Hierarchies On Steroids #1 article made it to the "Bacon" list on the Tribal Awards. I wouldn't mind winning that...

Yeah, a big part of why it's so important to pick the correct location for the clustered index is because it's so difficult later to rebuild them, especially if they're...

Tac11 (12/16/2014)

---

Mr. Grant Fritchey

you said in previous reply 'They don't do the same thing' (VERIFYONLY AND CHECKSUM).

In your article you said 'Verifyonly: Another way you can ensure that your...

In a perfect world, you would not store NULL values. However, in the world we live in, it's pretty normal to store NULL.

The real issue comes down to design and...