Viewing 15 posts - 1,396 through 1,410 (of 7,484 total)
Nice question. Yesterday's was so bad it had me despairing of QotD, today you've restored my faith.
November 6, 2015 at 9:38 am
it would have been a nice question if the right answer had been correct, but with the nonsensical and simply applling "correct" answer it must be in the running for...
November 6, 2015 at 9:06 am
Steve Jones - SSC Editor (11/5/2015)
No snow🙁
Grey Christmas
November 5, 2015 at 4:53 pm
Kim Crosser (11/4/2015)
TomThomson (11/4/2015)
SP......... cached_time............exec count.. AvWorkerTime.. tot_wt...min_WT.. max_WT...AvElapsedTime....
November 5, 2015 at 2:42 pm
Kim Crosser (11/3/2015)
Thank you for all the work here, but I think the rollbacks and "update" transactions in your test scenario may be creating some of the difference.
That the rollbacks...
November 4, 2015 at 3:40 pm
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
If taking wouldn't lead to my wife putting out a contract on me (:w00t: exaggeration) I...
November 4, 2015 at 2:43 pm
Brandie Tarvin (11/4/2015)
Okay, so the problem is that I can't post the code for my stored procedure. Grrrrr.See attached text file.
Perhaps it could be those " characters? I haven't...
November 4, 2015 at 2:19 pm
I looked some more at the amount of performance difference caused by NOLOCK (when it is safe) and because 1 or 2 percent seemed rather tight I devised some tests.
I...
November 3, 2015 at 4:01 pm
Luis Cazares (11/2/2015)
That's what I thought when answering. And also got it wrong. Yes, the answer is technically right, but might mislead people. It's a good question, though.
Yes, it's a...
November 2, 2015 at 9:23 am
I got this one wrong because I reckoned that when there is no concurrent activity the saving from not requesting shared locks is so small as to be absolutely...
November 2, 2015 at 7:57 am
Eirikur Eiriksson (10/30/2015)
jasona.work (10/30/2015)
Brandie Tarvin (10/30/2015)
November 1, 2015 at 4:46 am
ChrisM@Work (10/29/2015)
Ed Wagner (10/29/2015)
yb751 (10/29/2015)
I was thinking about unleashing it but then I...
October 31, 2015 at 8:27 pm
SQLRNNR (10/31/2015)
Eirikur Eiriksson (10/30/2015)
😎
(mis) Quoting William Edward Hickson
Tis a lesson you should heed:
Try, try, try again.
If at first you don't succeed,
Try, try,...
October 31, 2015 at 8:10 pm
Viewing 15 posts - 1,396 through 1,410 (of 7,484 total)