Viewing 15 posts - 526 through 540 (of 1,353 total)
RonKyle - why won't you use stored procedures to do a final insert?
I do use stored procedures for the final insert in the sense that there is a stored...
December 19, 2015 at 2:52 pm
I usually use stored procedures as the source. I also use them for the transformations in the staging tables. It makes editing and troubleshooting possible without editing the...
December 18, 2015 at 7:54 am
Correct me if I'm wrong but don't some data flow transformations change from set base processing to row based which is why they perform so poorly in comparison to T-SQL?...
December 17, 2015 at 3:13 pm
Sometimes the best option is to delete the connection and recreate it.
This has often been my experience as well.
December 17, 2015 at 5:49 am
I used to avoid that by using a staging database
I use those, too, though I'm glad to hear I'm not the only one. I've been told by other BI...
December 16, 2015 at 2:23 pm
there are a lot of BI developers who simply won't move data using T-SQL tasks, even when you point out that it's easier to code and 10x as fast.
Really?...
December 16, 2015 at 9:21 am
My interpretation on this editorial is that it is about taking responsibility for those machines under our control
That's helpful. I've been experimenting with encryption on my personal machine...
December 14, 2015 at 4:09 am
It might be helpful to know when we should be concerned about this. Presumably most everyone knows about SQL injection. But is writing an ordinary select statement stored...
December 13, 2015 at 12:21 pm
It used to be possible to move it, and as I recall had to be in the same folder as the master database. It can't be moved any longer....
December 2, 2015 at 7:19 am
It violates Second Normal Form in that the foreign key is NOT dependent on the whole of the primary key. The fact that you had to specify IGNORE_DUP_KEY in order...
November 19, 2015 at 9:55 am
This is kind of an odd-ball situation. GroupID & PayorID, would under normal circumstance, be the natural key for TableA... But there is a requirement that these have temporal "windows"...
November 19, 2015 at 8:18 am
On the contrary. A composite key is very common and has many perfectly valid uses.
I was not commenting on the validity of a composite key. They are of...
November 19, 2015 at 8:02 am
Is there no need or use for a table with the two fields as the primary key? On the face of it, it's more than an odd situation. ...
November 19, 2015 at 7:34 am
This worked great for me, too. Thanks!
November 18, 2015 at 9:54 am
In our environment, for our Type 2 Dimensions, we use [CurrentRowFlag] as a SMALLINT.
We use 1 for current row, 0 for inactive, and -1 for deleted (from Source).
I'm moving to...
November 3, 2015 at 12:17 pm
Viewing 15 posts - 526 through 540 (of 1,353 total)