There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...
Updating fact rows inside a star schema set of tables is never a best practice. Even so, some organizations travel down this path. Consultants occasionally will go so far as to embrace the idea of ...