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

For years we struggled with being able to identify where certain transactions came from. We finally added a field in the last year, to a few of our key...

GilaMonster (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

Yes, you assign the result of the expression...