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 ...
Tuesday, December 8, 2009

SQL Server 2005/2008 Maximum Server Memory - What should it be?

›
While questions like this don't have black or white answers there is some simple guidance here . . . You probably want to change it fr...