Viewing 15 posts - 11,056 through 11,070 (of 59,064 total)
October 3, 2018 at 8:41 am
Ah... be careful, Laurie. You're using rCTEs (Recursive CTEs) that produce an incremental count and they're slower than a well written While Loop and use 9 times the number of...
October 3, 2018 at 8:37 am
October 3, 2018 at 8:31 am
ChrisM@Work - Wednesday, October 3, 2018 2:55 AMWhere are the beers???
What... you missed the side profile of my gut in the...
October 3, 2018 at 8:15 am
scotsditch - Tuesday, October 2, 2018 12:51 PMCan I ... ?
Did you try it before asking?
October 2, 2018 at 7:39 pm
October 2, 2018 at 7:32 pm
The outer apply with the TOP 1 is killing you. It's doing 8443 seeks on the color table. There's only 8443 rows in the whole table.
Of course,...
October 2, 2018 at 7:21 pm
thanks for your response.
Can you please leave your comments on below points.
3. Is...
October 2, 2018 at 1:33 pm
October 2, 2018 at 1:03 pm
We took a NEW user, should be the same as the...
October 2, 2018 at 8:27 am
October 2, 2018 at 8:24 am
October 2, 2018 at 8:11 am
I'm not sure how you're running your test. If I run the first session without the rollback, the second session doesn't run because of the blocking transaction. When I rollback...
October 2, 2018 at 7:32 am
Just a word of caution... I've found that parallel loads are frequently not worth it. Your target doesn't have more read/write heads than it does with a serial load. Because...
October 2, 2018 at 7:07 am
Viewing 15 posts - 11,056 through 11,070 (of 59,064 total)