Didn't know about the Alt + F1, thanks for the comments. Currently I find the IntelliSense to more annoying than helpful, so I turned it off.

Welcome back Steve. Can't wait to hear what you did on your sabbatical. That is a nice perk I wish we all had.:-)

Evil Kraig F (7/16/2014)

---

When he did his test, did he use the same source data? When he did, did he remove the new data (or changes) from the target...

Currently we don't have one. The one that suggested this quit.

Thanks Craig and...

I should have mentioned that it's not just this example I mentioned, we have a lot more tables where we are doing the same steps. Extract data from a...

I would like to see the TRIM available. And why not change ISNULL to work the same way COALESCE does. ISNULL just seems to be more descriptive of...

I guess I always look at a problem as always having a solution. I may not have the answer but I believe it is out there. Just last...

I've noticed a pattern in the shots the computer takes, at least on my server. Does that mean I played it too much?:-) Shots start out with E05...

While I agree with not having SQL in...

Eric M Russell (6/25/2014)

---

below86 (6/25/2014)

---

Eric M Russell (6/25/2014)

---

below86 (6/25/2014)

---

Eric M Russell (6/25/2014)

---

Fortunately the construction of the execution plan (for example which table is used as the outer or inner input...

Eric M Russell (6/25/2014)

---

below86 (6/25/2014)

---

Eric M Russell (6/25/2014)

---

Fortunately the construction of the execution plan (for example which table is used as the outer or inner input on a nested loop...

Sean Lange (6/25/2014)

---

How or why is this "best practice"? I create joins...

Eric M Russell (6/25/2014)

---

Fortunately the construction of the execution plan (for example which table is used as the outer or inner input on a nested loop or hash join) isn't...

Visually this looks bad, see the pet pevee posts on formatting your code.

update t1

set a, b, c, d .f

from t1 a

join t2 b on a.poleid=b.poleid

join t3 c on b.t3id...

lptech (6/23/2014)

---

If many/most of your meetings are conference calls, you'll love this:

https://www.youtube.com/watch?v=zbJAJEtNUX0

My manager's manager told us it was shown at off-site for higher ups as an example of what not...