111 reputation
4
bio website None
location Washington, United States
age 53
visits member for 3 years, 10 months
seen Apr 24 at 16:37

I'm a geek. I'm Wednesday's little sister.


Jul
2
comment How to run steps in one job sequentially
So, you're saying that what he wants is what should be happening?
Jun
21
comment Update existing SQL Server 2008 table via Flat File using SSIS
Isn't loading the data one of your first steps in the SSIS package?
Jun
18
awarded  Teacher
Jun
17
answered SSIS Rollback Package
Jun
5
comment Relational database primary key requirements
@ypercube it's better if you just use a integer key rather than a composite key for the primary key. That messes up all sorts of things when something has to move. What if you move a rack from one room to another? Does it get a different key, and so loses all history of when it was elsewhere? Avoid smart keys as much as possible.
May
3
comment Exporting 30 million rows to CSV
What are you going to use the csv for? In other words, what are your goals for the data?
Apr
25
comment How to insert in a table with only an IDENTITY column?
Ok, but why? Where would you use a table with just an identity column?
Apr
10
comment how to show only changed rows
Oh, so everytime the flag changes, you want that record?
Jan
16
comment Relationships in a school database
Perhaps in your design it will always be one to one in case of parents, but in real life, that will not always be the case. Even if you only need one parent listed, the student may have divorced parents and this month he's with one, next month he's with the other: parents die and divorce and remarry and generally make database designs more complex than you want them.
Feb
3
comment Moving tables to another SQL2008 database (including indexes, triggers, etc.)
And it's not all the tables in the database?
Feb
1
awarded  Supporter
Jan
26
awarded  Precognitive
Jan
26
awarded  Autobiographer