The specs posted for the Jeopardy system include 2880 cores and 16TB of RAM. That's not the size of system many of us every get to work with. The software,...

My experience has been that the best way for one to avoid micro-managment, at least the "hovering over your desk" variety, is to efectively manage oneself. After all, it's the...

mhroche (2/3/2013)

---

While end users tell you all day what they want to be able to, do a system or tool cannot be successful without accomplishing whatever goal was set forth.Sometimes...

The first I look at are blocked processes, query wait times, and wait types, which can also be baselined just like CPU and I/O. Blocking and waiting are normal in...

What about containing customer contacts?

I still that one Customer_Contact table that contains something like Customer_ID, Contact_Type, Contact_Code columns (Entity-Attribute-Value ???) is better than seperate Customer_Phone, Customer_Fax, Customer_Email, Customer_Tweet, ad...

The Thinkmap Visual Thesaurus links a database of 145,000 words

http://www.visualthesaurus.com/

It would be interesting to see MSDN do something similar with .NET or SQL Server Books Online.

bryce.hill (1/25/2013)

---

It is painfull to make changes because you use SQL Server. It is a shite product that should never be used by a real company and not real companies...

Ross McMicken (1/25/2013)

---

No movies stand out for me this year, but for TV with a sci-fi component, I highly recommend the UK TV shows Life on Mars and Ashes to...

I'd highly reccomend, 'Game Of Thones', although it's not a movie but an HBO series.

The Showtime series 'Spartacus' is good too, although it's heavy on violence and sex;...

This is why service, application, and user accounts should not be members of the SYSADMIN or DBO role. That would help prevent mysteriously dropped objects and also narrow the list...

LOL! All of you guys who added a [Customer_Tweet] table to your database, are you going to add tables for supporting Hoots and Chirps too?

BillyJack (1/21/2013)

---

I think Eric's example demonstrates the strength of an EAV design..you can add new attributes via data and not table structure.

David, I see from the responses that...

David.Poole (1/21/2013)

---

@eric, it depends on what you want to do with those contact details. If it is just a block of unstructured data that you want to eyeball whenever...

Peter Schott (1/21/2013)

---

For Customer Contacts, why wouldn't I make a "Contact Type" table and just normalize this? Sure it can store just about anything, but since all contacts are going...

David.Poole (1/21/2013)

---

...

...

Personally I would have a PhoneContactPoint table and an EmailContactPoint table

CREATE TABLE PhoneContactPointType(

PhoneContactPointTypeID SMALLINT NOT NULL

CONSTRAINT PK_PhoneContactPointType PRIMARY KEY CUSTERED,

...