That's the real killer - people who treat persistent object data storage as dumb storage (generate the database from the...

The use or ORM for object/relation mapping should be called Object Data Mapping since the objects know nothing of relations to any other object. Data elements in objects are supposed...

I think every table design has to stand on its own merits.

I use whetever design techniques are at my disposal.

Like any feature you use, you use it more if it...

Yes, it should be the default.

In hosted Google Apps, there is an option for domain administrators to force HTTPS (http://www.google.com/support/a/bin/answer.py?hl=en&answer=100181)

In regular gmail, users have to set it to...

If it can produce variable number of columns depending on data, its...

If they were to fix extended properties, they should fix it so that they are not lost when altering a multi-step table value function whenever I remove schemabinding and re-add...

While table partitioning has been available since 2005, it's almost easier to continue to manually manage it with regular tables, since tables have to be swapped in and out, and...

The fundamental problems are that there is not a unique identifier for a person (US citizen or not) (whether accurate or not), nor is there a universal way to authenticate...

Almost all of these can be automated pretty reliably:

Run a query to get all tables without a clustered index (heap tables), all tables without a primary key, and all tables...

Shane Petroff (5/8/2009)

---

IMHO one of the biggest mistakes a development shop can make is failing to tap the power of the database engine by placing all the T-SQL in the...

As a developer (currently working mainly in T-SQL for backend processes), it's often better to not have a DBA at all than to have one who doesn't understand development or...

Perhaps my experience is unusual, but I've recently determined that clustered indexes do not perform nearly as well as non-clustered indexes. Perhaps this is because the tables I was...

jwalker8680 (2/13/2009)

---

Actually... "The Data Warehouse Toolkit Second Edition" by Ralph Kimball specifically mentions this on page 60, last paragraph.

You should avoid using a readable date as the key, and instead...

Any particular reason you didn't use a natural int primary key of the form yyyymmdd?

We've found that to be pretty typical in Kimball-style DW designs, and it still leaves options...

Sure looks like it - thanks so much!