meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 2 years, 1 month |
| seen | May 13 at 4:50 | |
| stats | profile views | 30 |
|
2d |
awarded | Popular Question |
|
Apr 19 |
awarded | Popular Question |
|
Mar 23 |
awarded | Yearling |
|
Feb 6 |
awarded | Notable Question |
|
Jan 12 |
accepted | With the advent of integrated source control, do stored procedure changes still need comments? |
|
Jan 11 |
revised |
With the advent of integrated source control, do stored procedure changes still need comments? edited tags |
|
Jan 11 |
asked | With the advent of integrated source control, do stored procedure changes still need comments? |
|
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? |
