Viewing 10 posts - 16 through 25 (of 25 total)
CDC is a nice feature to track changes. We have enabled it on one of our primary database on our production server with a retention period of 3 days. We...
April 14, 2018 at 4:02 am
Hi,
If possible and if it is not a performance issue, I would advise bring all the data that you need into staging tables first, and then build a VIEW,...
April 11, 2018 at 2:22 pm
Hi,
Late arriving dimensions are processed in different ways. We have a process were we capture the fact record and keep it separately in a different table and there is...
April 10, 2018 at 10:37 am
Can you run the job by using the Service Account that is running the SQL Agent?
April 9, 2018 at 4:29 pm
I receive emails every time a 500 error occurs on the web server and yesterday I...
April 7, 2018 at 9:44 pm
AccountName Level IsCurrent Parent
District 1 1 0 ...
April 7, 2018 at 2:13 pm
April 7, 2018 at 1:40 pm
Hi,
Looks like you are working with slowly changing dimensions. An alternate way is to split the MERGE statement into two, INSERT and UPDATE separately.
--Use Merge...
April 6, 2018 at 11:31 pm
Hi,
ROW_NUMER() analytical function can be used to generate a new number for each row.
Select t.*, ROW_NUMBER () over (order by sortid) RowNumber
from #tblTasks...
April 6, 2018 at 10:22 pm
Hi,
Reduce the Degree of parallelism setting to 2 and give it a try.
April 6, 2018 at 9:34 pm
Viewing 10 posts - 16 through 25 (of 25 total)