1,159 reputation
623
bio website
location Minneapolis, MN
age 28
visits member for 2 years, 3 months
seen 5 hours ago

I'm a database architect/administrator specializing in Business Intelligence out of MSP.


Oct
7
comment How do I Continue After a Failure in SSIS
That'll do fine just fine.
Sep
24
awarded  Autobiographer
Sep
18
comment Can't see some stored procedures in sys.procedures
@WayneFitz don't beat yourself up too hard there guy.
Sep
18
comment Can't see some stored procedures in sys.procedures
I wish I could Upvote Shawn for that edit. You sir are a saint.
Sep
18
comment Can't see some stored procedures in sys.procedures
I agree with @billinkc I think you may be overcomplicating this problem.
Sep
16
comment Encoding Debug UTF8 & Latin 1
Methinks you need to declare those strings like so. N'ForeignGibberish' Otherwise it doesn't assume it's unicode.
Sep
9
awarded  Nice Answer
Sep
9
comment SQL import data when both source and destination has data and identity column
Once you select the table just edit the column mappings.
Sep
8
comment SQL import data when both source and destination has data and identity column
If I can't see the query or the mappings I'm not really sure what else I can do to help you?
Sep
8
comment SQL import data when both source and destination has data and identity column
Can you post the query?
Sep
8
comment SQL import data when both source and destination has data and identity column
Make sure your column mappings are set right and that your source and destination have the same data types.
Sep
8
answered SQL import data when both source and destination has data and identity column
Sep
8
comment SQL import data when both source and destination has data and identity column
Why don't you just exclude that column if it's an Identity value that isn't referenced elsewhere?
Sep
8
comment SQL import data when both source and destination has data and identity column
"Violation of PRIMARY KEY constraint 'PK_Misc_Data' This seems to be your problem. You're inserting dupes. The duplicate key value is (1). you seems to already have an identity value of 1 in your destination table.
Aug
31
awarded  Popular Question
Aug
27
comment Speed up a MySQL BETWEEN query
For starters don't use BETWEEN use >= it's much clearer that way.
Aug
26
comment Unresponsive MySQL database
Split up the work or speed up the query.
Aug
26
comment Best approach for populating date dimension table
@JohnLinux slower than what? When you're joining your DimDate to other tables chances are you will being joining on other date columns right? Therefore it wouldn't it make sense to have your PK be your date column?
Aug
26
comment Best approach for populating date dimension table
No artificial ID. If you are going off of date use Date as the PK if you are using Datetime then use datetime as the PK. Either way the is pretty much always going to be your natural key and your join key.
Aug
26
comment Best approach for populating date dimension table
@JohnLinux ooooo bad move on the YYYYMMDD as int. This will cause you massive heartache.