Monday, March 29, 2010

Performance Issue: UNPIVOT with a Large Number of Columns

›
I love the PIVOT and UNPIVOT commands. They have saved me a ton of time on quite a few projects. UNPIVOT especially, since many times when w...
1 comment:
Sunday, February 28, 2010

Clustered Index Doesn't Have to be the Primary Key

›
Believe it or not, you don’t have to cluster your primary keys. Most SQL Server mortals assume that their primary keys should be clustered...
Thursday, January 14, 2010

Derived Table, Subquery, Correlated Subquery, etc.

›
I was recently attempting to explain to someone the difference between derived tables and subqueries. I didn't do a great job and came t...
4 comments:
Wednesday, January 6, 2010

Should Foreign Key Columns be Indexed?

›
People seem to be confused when it comes to indexing of foreign key columns. For one, I believe some people assume that when you create a fo...
Monday, December 21, 2009

T-SQL End of Previous Week, Month, Quarter, Year

›
I recently had a requirement to capture periodic snapshots of an incident/activity type OLTP table into a fact table. I already had an accum...

Cognos 8.3 -- Framework Manager -- Model objects and shortcuts

›
I was recently tasked with creating a relational model in Cognos Framework Manager and got a little confused when deciding what kind of obje...
Monday, December 14, 2009

SSIS Error Codes (Hresults)

›
Ever get an Hresult error code and have no idea what it meant or how to figure out what it's related to? The SSIS run time engine and ...