Now on to data types.

Currency: should it be decimal, numeric, money, int?

Date/Time: datetime, offset, varchar?

Names and descriptions: varchar or nvarchar?

Unique Identifiers: int, guid, timestamp, rowid, identity, sequence? :rolleyes:

I can live with mixed naming conventions, or even no convention, so long as the name given for each column makes sense and is consistent within the scope of that...

GoofyGuy (1/22/2015)

---

IT can work with the business, improve processes ...

In many businesses and governmental organisations, IT is the only part of the organisation which can provide enterprise- wide knowledge of...

I can see now this thread is going to get a lot of comment. This is one niche application where I'd suggest Hadoop and HiveSQL.

As far as doing this...

Comparing the IT department to a utility company may not be accurate for most organizations, but at least it's not as demeaning as comparing IT to a sausage factory. ...

Yes,...

Brian J. Parker (1/21/2015)

---

Eric M Russell (1/21/2015)

---

For those of us in IT, I'm not sure if we need Big Brother standing up for us on the playground; we can vote...

Steve Jones - SSC Editor (1/21/2015)

---

Eric M Russell (1/21/2015)

---

I don't take offense if I'm called after work, so long as it's regarding something that's broke in production. The way I...

I don't take offense if I'm called after work, so long as it's regarding something that's broke in production. The way I see it, if I done by due dilligence,...

ProductID, ProductId, and product_id are all respectable options, so long as it's done consistently.

However, I would take issue with ID by itself, on every table. Anytime I see that,...

The data model of a database is like the foundation of skyscraper. It defines the scope, constraints, and scalability of the database. Get it wrong, and your SQL and data...

alanspeckman (1/20/2015)

---

Is there a DMV that will give me a rate-of-change on a database, amount of log data generated over a period of time?

I need a quick way of showing...

Sean Lange (1/20/2015)

---

Eric M Russell (1/20/2015)

---

I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are also used for...

Steve Jones - SSC Editor (1/20/2015)

---

david.gugg (1/20/2015)

---

We're on 2008 R2 Enterprise at my shop and we've cancelled plans to upgrade to 2012 because of the costs. Once Microsoft stops...

I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are also used for clarity. Also, I don't have...