336 reputation
212
bio website
location Velp, Netherlands
age 25
visits member for 2 years, 3 months
seen Dec 11 at 7:19

Sep
2
awarded  Popular Question
Aug
9
comment SSIS Failed to start project
I didn't het an error about the objectname. When I'm back in the office I'll try and zee if there is an error somewhere. The strange thing is that SSIS 2008 is running fine.
Aug
8
revised SSIS Failed to start project
Added the error in text.
Aug
8
comment SSIS Failed to start project
Thank you for posting an answer so fast. The problem was not upgrading a solution, because I created it in Visual Studio 2012 with the Project Deployment Model.
Aug
8
answered SSIS Failed to start project
Aug
8
asked SSIS Failed to start project
Oct
24
comment Can CDC or Change Tracking be against a read only secondary?
CDC enabled databases can be added to AlwaysOn Availability Groups, and databases that are members of an AlwaysOn availability group can be enabled for CDC. In both cases, however, CDC configuration is always performed on the current or intended primary replica.
Sep
10
comment Database Design for lookup tables
I agree with @AndriyM. It would be a more self explaining database design when you create separate tables.
Sep
9
awarded  Yearling
Sep
9
comment Database Design for lookup tables
You can add a new foreign key between questionnaire and question_codes.
Aug
14
awarded  Revival
Jul
30
awarded  Revival
Jul
23
comment Cannot create FOREIGN KEY for a table
This is not the answer to the problem Brady Chu is having. Try to identify the rows that have a missing reference and fix those issues. After fixing those rows (maybe link them to a dummy record if you have no other option) you can create the Foreign Key without errors.
Jul
23
awarded  Critic
May
21
awarded  Caucus
May
21
awarded  Constituent
May
16
answered Efficiently Filter Large Set With Disjunctions
Apr
16
answered How does order of index affect performance in SQL Server?
Mar
28
comment using IDENTITY column with increment -1
I meant your idea of using a BIGINT with a gigantic number as offset is nice. :)
Mar
28
comment using IDENTITY column with increment -1
I'd love your thought on this topic!