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

Sean Lange (6/18/2014)

---

You might be surprised. Often times people in that position will write some beautifully formatted code. Especially if they are shown code with nice formatting from the beginning....

Jeff Moden (6/18/2014)

---

below86 (6/18/2014)

---

andrew gothard (6/18/2014)

---

below86 (6/16/2014)

---

andrew gothard (6/15/2014)

---

Koen Verbeeck (6/14/2014)

---

Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in...

andrew gothard (6/18/2014)

---

below86 (6/16/2014)

---

andrew gothard (6/15/2014)

---

Koen Verbeeck (6/14/2014)

---

Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in your Order Taken...

andrew gothard (6/15/2014)

---

Koen Verbeeck (6/14/2014)

---

Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in your Order Taken timestamp column in...

Evil Kraig F (6/13/2014)

---

Offhand, even in my warehouses, I never really saw a significant value in storing the date as a four byte int instead of the 8 byte datetime....

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This...

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This person also had...

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This person also had the idea to...

viresh29 (6/10/2014)

---

SELECT

t.NAME AS TableName,

s.Name AS SchemaName,

p.rows AS RowCounts,

SUM(a.total_pages) * 8 AS TotalSpaceKB,

...

Sean Lange (6/10/2014)

---

below86 (6/10/2014)

---

Having a consistent naming convention for fields. I am as guilty as anybody at not doing this, but it is driving me nuts now. Years...

Having a consistent naming convention for fields. I am as guilty as anybody at not doing this, but it is driving me nuts now. Years ago we were...

Each day is one day closer to vacation. 🙂

How about doing data transformations in the ETL process. I know that's what the 'T' stands for. I can see changing date formats to work in SQL. ...