Forum Replies Created

Viewing 3 posts - 16 through 18 (of 18 total)

  • RE: FK and Index

    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)....

  • RE: SQL Jobs and retrying steps that fail

    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...

  • RE: Lock Escalation: 5000 to 1?

    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...

Viewing 3 posts - 16 through 18 (of 18 total)