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

C #7 Cafeteria. I don't mean just a room with chairs, tables, and a vending machine; that's a break room. I'm talking about a real cafeteria serving fresh hot meals...

The ALTER INDEX statement supports an optional PARTITION clause. This is useful if you have very large tables, allowing you to REBUILD or REORGANIZE one partition at a time or...

Job satisfaction is multi-faceted issue: Pay / Commute / Comradery / Career Growth. You can leave a job in search of one facet only to discover that you've ultimately lost...

Hi Ben, I like this topic, but I'd just like to point out that half of the paragraphs in your article are repeated.

Generally speaking, you're going to take a performance hit when applying ranking at runtime, especially if you're joining on a ranked sub-query. Optimal indexing helps, but I'd suggest adding a...