Every table should have a primary key from the start; that's a given. Beyond that, I add indexes only when unit testing, QA, or post-deployment reveals the need for performance...

... There is a report for that database downtime averages $7900/minutedatabase downtime averages $7900/minute. My guess (if that's true), is that we have something other than a normal distribution....

Regarding this scenario, where a natural primary key would be composed of more than a handful of columns; in the past I've approached this by implementing a computed column on...

If you want to know how much your personal data is worth, then ask your cell phone or internet service provider; they could give you the exact dollar amount they...

Oracle has this special built-in table called DUAL containing (1) row and a single column called DUMMY with a value of 'X'. Because Oracle doesn't support using a SELECT statement...

Microsoft should simply add a system tally table to SQL Server.

I'm assuming we're talking about an OLAP or data warehouse type database here. Regarding the issue of where to contain the Event Description column, I can't say for certain unless...

<sarcasm> C #8 Chip. Some employers are implanting their employees with tracking chips, which not only increases the employee's sense of safety and self worth but also let's them know...

I'm a lot more productive, and I can even code faster with fewer defects, when I have I have a clear set of specifications to work from. Lack of clarity...