742 reputation
614
bio website
location
age
visits member for 3 years
seen yesterday

Dec
28
answered SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express edition
Dec
14
accepted ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
Dec
14
comment ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
BIML looks very interesting. I was also considering creating each data flow as a separate package and then having them called through a master package. Do you think that's any better? Also, curious if you have an opinion on the T-SQL approach. It's slower but I've tested it and it will work.
Dec
14
comment ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
The databases reside on multiple servers which I think makes it more complicated. I have actually tried creating a view of different tables on my development box against 225 databases and reading of the data was painfully slow.
Dec
14
asked ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
Nov
5
awarded  Popular Question
Oct
27
comment overhead for INSERTS using change tracking and/or change data capture (CDC)
You may find this link useful: databasejournal.com/features/mssql/article.php/3806001/…
Oct
25
comment Data archival strategy that handles schema changes?
Maybe substantial is the wrong word but the functionality is constantly evolving. It would not be unusual to see the addition of new tables and columns as well as modifications to existing ones.
Oct
25
asked Data archival strategy that handles schema changes?
Aug
31
revised Commonly Used Acronyms by Database Administrators
Added MDX - Multidimensional Expressions
Aug
29
accepted Does surrogate key assignment for a fact table require that the source data has natural keys?
Aug
29
comment Does surrogate key assignment for a fact table require that the source data has natural keys?
In this example, I think the rules are one order per one customer and one product (not realistic, I know).
Aug
29
comment Does surrogate key assignment for a fact table require that the source data has natural keys?
I think so. Can you elaborate on what that mapping table might look like based on the example I have?
Aug
29
asked Does surrogate key assignment for a fact table require that the source data has natural keys?
Aug
24
comment How do you roll up header-level values on a fact table with line-item granularity?
The query makes sense. But does this mean that the roll up can only occur within a view of some sort? If you were to take the fact table and build a cube from it, it seems like the customer wouldn't be able to do these roll ups in a pivot table.
Aug
24
revised How do you roll up header-level values on a fact table with line-item granularity?
added 141 characters in body
Aug
24
comment How do you roll up header-level values on a fact table with line-item granularity?
@Jamie: But if I want to do a browse query on the Product dimension (say, all Products who fall under a certain brand), this design means I'll need to somehow filter out all my "magic" products. Is that also correct? It seems like the problem can be solved by having two fact tables: one for header level and one for line-item level. But nobody seems to recommend this.
Aug
24
comment How do you roll up header-level values on a fact table with line-item granularity?
Would the "magic" Shipping product be a placeholder so that a line item with 0 quantity and 0 order amount could exist with the shipping amount? Does this mean you would then zero out the Shipping amount on the other line items?
Aug
24
asked How do you roll up header-level values on a fact table with line-item granularity?
Aug
21
revised Commonly Used Acronyms by Database Administrators
Added DRI - Declarative Referential Integrity