andrew gothard (1/27/2015)

---

Eric M Russell (1/21/2015)

---

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

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

---

Eric M Russell (1/26/2015)

---

So, deploying a new procedure, table, or column days or weeks before the associated application change is deployed? Yes, that happens all...

Charles Kincaid (1/26/2015)

---

Eric M Russell (1/26/2015)

---

Hey, it's 2015; the developer should code the application first, and then with a few clicks of the mouse they can auto-generate all the database...

Hey, it's 2015; the developer should code the application first, and then with a few clicks of the mouse they can auto-generate all the database junk in the background for...

So, deploying a new procedure, table, or column days or weeks before the associated application change is deployed? Yes, that happens all the time in my universe where the database...

Jeff Moden (1/24/2015)

---

Yes. I agree with that 100%....

sm_iransoftware (1/22/2015)

---

THX All

Feedbacks was very nice and wide

I should have read more carefully down the Answers

(specially about Hadoop and HiveSQL)

-----------------------------------------------------------

And now more details about your questions and ideas :

1- We...

I am thankful for introduction of the short Date and have made heavy use of it last few years.

Charles Kincaid (1/23/2015)

---

Eric the folks in the UK just went, "What?". Over there "biscuits" means something else. However free food and coffee is likely to clear out a...

If you want to "Get IT Out of the Data Center", then send an email to the DBA team informing them that there are Chick-Fil-A breakfast biscuits and StarBuck coffee...

ScottPletcher (1/23/2015)

---

TomThomson (1/23/2015)

---

I suppose if your dBMS is anccient enough that's excusable. But it...

A single SQL Server Enterprise instance running on a moderately powered server can house multiple OLTP applications for even large organizations. I've seen cases where organizations are using multiple instances...

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