Viewing 15 posts - 5,881 through 5,895 (of 22,211 total)
And if you don't have a plan that will go parallel on its own, just use TRACEFLAG 8649. That will drop the query cost to zero so you'll see a...
July 2, 2015 at 7:20 am
It really depends on your transaction load, but you have a couple of options. Use Extended Events and capture all the RPC Completed and SQL Batch Completed events for one...
July 2, 2015 at 3:33 am
rodjkidd (7/2/2015)
I liked Belgium when I visited. The beer does help of course 😀 Must go back again soon.
Grant when and where will you be in the UK?
Don't stand a...
July 2, 2015 at 3:09 am
Koen Verbeeck (7/2/2015)
When are you coming to Belgium? We are currently in a heat wave, so bring sunscreen 🙂
Week after next. Next week is in the UK.
July 2, 2015 at 3:07 am
Lynn Pettis (7/1/2015)
July 1, 2015 at 3:44 pm
Sean Lange (7/1/2015)
Grant Fritchey (7/1/2015)
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days...
July 1, 2015 at 3:42 pm
Koen Verbeeck (7/1/2015)
Grant Fritchey (7/1/2015)
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days...
July 1, 2015 at 3:38 pm
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days off, and the people...
July 1, 2015 at 12:21 pm
Being a college drop-out and utterly w/o degree, yet, I'd argue, a relatively successful career within IT, I'm frankly not sure what a college degree would have done for me....
July 1, 2015 at 10:34 am
It's still just about standard monitoring. Keep an eye on your wait statistics, watch to see if these change in a negative fashion. Same thing goes for the queues within...
July 1, 2015 at 8:08 am
If you don't have the capabilities to do disaster recovery, your company can go under.[/url] That's the number one argument for me. We have to be able to do disaster...
July 1, 2015 at 7:59 am
A second vote for the Internals book. It's great. My book on execution plans does go over how the optimizer works, but not in as much detail. Plus, you can...
July 1, 2015 at 7:55 am
Also, as much as I'm guilty of saying this, it's not about improving the plan. It's about improving the performance of the query. The plan just exposes how the optimizer...
June 30, 2015 at 12:41 pm
DBA From The Cold (6/30/2015)
Grant Fritchey (6/30/2015)
DBA From The Cold (6/30/2015)
June 30, 2015 at 6:24 am
GilaMonster (6/30/2015)
Eeep. Just realised that tomorrow's the 1st of July. Or the 'refresh email every 5 seconds' day.
Mine is April 1st, which also means that it's "check the header and...
June 30, 2015 at 5:37 am
Viewing 15 posts - 5,881 through 5,895 (of 22,211 total)