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

All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.

1
vote
I think you could definitely use SSIS to do this task. I would start by selecting your distinct ClientID's into an object variable and then using a ForEachLoop with a Foreach ADO Enumerator and then …
answered Feb 3 '14 by njkroes
1
vote
Seeing some comments saying not to use SSIS for this, but my vote would be for using SSIS based on the fact that you said that the data would be transferred between servers. If you used a stored proc, …
answered Feb 3 '14 by njkroes
2
votes
1answer
I'm looking for a strategy for extracting data from a SQL Server database that is configured for change data capture (CDC) using SSIS. Most of the documentation I have seen around using CDC and SSIS …
asked Feb 26 '16 by njkroes
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
1
vote
If you have the Enterprise version of SQL Server, then I would recommend doing this using Change Data Capture (CDC). This is much easier and cleaner than setting up triggers to watch for changed data. …
answered Apr 18 '14 by njkroes
1
vote
If you want to see measures from two different fact tables side by side but different granularity, it's possible but not perfect. For example, the measure for purchase amount in FactPurchase has no mo …
answered Mar 6 '14 by njkroes
2
votes
1answer
I'm attempting to write a query to denormalize some data for integrating to our data warehouse, specifically around generating some time slots. In my source system, I have table that has a start time …
asked Feb 20 '14 by njkroes
13
votes
3answers
My developers have setup their application to use GUID's as PK for pretty much all of their tables and by default SQL Server has setup the clustered index on these PK's. The system is relatively you …
asked Oct 31 '13 by njkroes
2
votes
Does DimCategory have any Type 2 attributes that you are tracking? If it is not, then you would only need to add a new record to your bridge table based on whenever a Type 2 attribute in DimPerson ch …
answered Nov 1 '13 by njkroes
0
votes
Another option would be to leverage Change Data Capture to look for specific writes to the Data Warehouse that need to be written back to your source DB's. However, if you are using CDC on your source …
answered Nov 1 '13 by njkroes