Excellent ideas; we have on going efforts to document the DW and cubes. I'm certain I'll be looking into this more after the beginning of the year.

I’m not so sure we will see new data types, so much as adding DOMAIN to SQL Server. I didn’t know about it until reading one of Joe Celko’s...

I would suggest an alternative piece of code in one area you are using. When checking your type 2 attributes for change, you are using a lot of “not...

David Greenberg-358875 (6/20/2011)

---

Suppose you have a dimension that contains certain columns that are type 2 where you want to keep track of historical changes. However, the dimension also contains type...

CELKO (12/29/2010)

---

I always did this by...

In the past I reflected on the advantage of INT (IDENTITY) vs. GUID, typically deferring to the INT (IDENTITY) in my database work due to size and speed.

Now, I’m a...

I seem to recall that SharePoint...

I also noted the lack of a GROUP BY clause. After “assuming” that it was intended, my first thought was 8 (4 for the table, 4 for the index)....

You had me going there; while waiting for the forum link to respond was when I got it.

You might have had fun with a different approach: instead of no NULL,...

As it applies to software, I think the early UNIX days work as an example. Each utility addressed a single individual problem, and did it very well. The...

:ermm:

For the dieting areas, might I suggest "The Zone Diet". I haven't looked closely at Atkins, but as I understand it, one of the "phases" that you go into...

For everyone commenting on smoking: In 2007 I lost my mother and sister both to cancer or cancer treatment “after affects”. My mother had quit some years earlier but...

Procrastination and/or completing tasks that I start. This is mostly related to “personal” projects, things around the house, etc.

Is this so "out there" that no one really works with SSIS this way?