Viewing 15 posts - 226 through 240 (of 3,543 total)
November 5, 2018 at 9:21 am
As an architect I would adivse that you consider both the short-term...
November 1, 2018 at 8:54 am
October 25, 2018 at 1:53 am
DesNorton - Thursday, October 11, 2018 10:37 PMand .... He's back
LOL sorry had to laugh at that thread. :blush:
And the answer...
October 12, 2018 at 4:04 am
October 11, 2018 at 6:49 am
Thom A - Thursday, October 11, 2018 4:27 AMMaybe this is MS's way of pushing people to use SSISDB instead.
Is that...
October 11, 2018 at 6:06 am
October 9, 2018 at 1:45 am
I think the issue here is what the estimator does
The testing I have done shows that the estimated row counts in the Actual Plan include rows in uncommitted transactrions when using SNAPSHOT...
October 5, 2018 at 6:07 am
Ran a few more tests on my 2016 dev box.
First query without rollback
Second query with rollback and actual plan
WITH GO between SET and BEGIN TRAN
October 4, 2018 at 2:33 am
Viewing 15 posts - 226 through 240 (of 3,543 total)