Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 30053

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

4
votes
Here are my answers: Define relationships based on your surrogate keys and not your business keys. This is because this is what the SQL engine will use to optimize queries and this is the reason you …
answered Apr 15 '14 by njkroes
0
votes
Figured it out shortly after posting. Although SSIS doesn't allow you to delete the error columns in the error output of the first insert, it does allow you to change the names. I was able to modify …
answered Apr 7 '14 by njkroes
1
vote
1answer
I'm writing a simple package to load data into tables and a I have multiple destinations within the same package. I'm attempting to first attempt batch inserts but want to fall back to row by row in c …
asked Apr 7 '14 by njkroes