j-1064772 (1/15/2014)

---

[font="Comic Sans MS"]Actually I would prefer to know the LAST TIME the procedure was run and by whom, in order to determine which ones have become unused fossils.

Any plans...

To start with. I did not carefully read the entire article.

I stopped at the 5th time I saw "Select *" used in the code for an article about Query performance.

At...

ChrisM@Work (2/23/2015)

---

Since you did not specify I am going to just restate one that this discussion is about -

Never add a where statement to your SQL...

bantrim (2/23/2015)

---

PHYData DBA (2/23/2015)

---

bantrim (2/23/2015)

---

Eric M Russell (2/23/2015)

---

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into...

bantrim (2/23/2015)

---

Eric M Russell (2/23/2015)

---

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table...

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from another table...

That statement says it all.

It is a perfect example of the...

bantrim (2/19/2015)

---

I guess I get to be in the minority here. I don't use it everywhere, but it does have its purpose. One notable example is in building...

TomThomson (2/18/2015)

---

CELKO (2/18/2015)

---

Remember it from Assembly languages? If you dropped it, the line count...

Eric M Russell (2/18/2015)

---

Resender (2/2/2015)

---

ok this is something of a best practice of mine in my queries

I always do

WHERE 1 = 1

I can't remember where I picked this habit up...

CELKO (2/18/2015)

---

Remember it from Assembly languages? If you dropped it, the line count would...

+1 to all of the above.

#1 Reason my production SQL does not work as expected.

...

GPO (2/8/2015)

---

.......Sickness is a complex beast to quantify. Enterprising clinicians, frustrated at the slow pace of change, have played around with a bit of Access or File Maker Pro or...

I read this in a quote from Jeff Moden:

"Well, pre-optimization is the root of all evil"

How stupid. The saying is actually this:

"post-optimization is the root of all...

And cast a maniacal laugh when the table is schema locked for two days because it...