Viewing 3 posts - 16 through 18 (of 18 total)
Based on me, When we have FK constraint on Fact tables then mostly we use in join to get the DimTable data in any report or DW Cubes(in DW world)....
April 26, 2016 at 3:43 pm
#1874810
In job setting we have to give the retry Attempts(5) and Retry Interval (After 2 min or 30 min)
Got to job properties-->Select steps-->Edit the step-->Just below the on Success action...
April 22, 2016 at 9:03 am
#1873940
Yes, you are right. Immediately after the Lock Escalation successful the other row locks will be release(Memory hold by the row locks).
To escalate locks, the Database Engine attempts to change...
April 22, 2016 at 8:49 am
#1873927