Viewing 15 posts - 2,431 through 2,445 (of 9,720 total)
As I dig into this issue (Execution Plans HO!), I come across a thread in which one respondent posts a link to Gail's blog and then Grant shows up to...
July 30, 2015 at 7:54 am
GilaMonster (7/30/2015)
Luis Cazares (7/30/2015)
NOLOCK hints can be useful to get estimates of certain data.
Yup. In fact I told some people recently to put nolock onto a bunch of queries. They...
July 30, 2015 at 7:52 am
ALZDBA (7/30/2015)
Brandie Tarvin (7/30/2015)
...EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
To keep the answer brief and firm: No.
The risk...
July 30, 2015 at 6:55 am
Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing indexes to resolve performance issues?
Work thing. I've...
July 30, 2015 at 5:04 am
SQLRNNR (7/29/2015)
WayneS (7/29/2015)
BL0B_EATER (7/29/2015)
WayneS (7/28/2015)
I love it when I learn something in an area where I thought I knew it all.You have made me very curious. What was the subject?
Table...
July 29, 2015 at 8:00 am
WayneS (7/28/2015)
I love it when I learn something in an area where I thought I knew it all.
Well that explains why I lost all my SQL laarnin' yesterday.
Stop stealing my...
July 29, 2015 at 4:01 am
Careful, guys. Gail-baiting is a sure way to encourage the use of katanas.
July 28, 2015 at 9:19 am
GilaMonster (7/28/2015)
WayneS (7/27/2015)
If I were to say that one of Gail's answers wasn't, well, entirely accurate... do you think this would get her out to Summit this year to whoop...
July 28, 2015 at 5:26 am
Eirikur Eiriksson (7/27/2015)
Brandie Tarvin (7/27/2015)
SQLRNNR (7/27/2015)
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up...
July 27, 2015 at 11:50 am
Ray K (7/27/2015)
July 27, 2015 at 11:33 am
Jack Corbett (7/27/2015)
Brandie Tarvin (7/27/2015)
SQLRNNR (7/27/2015)
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for...
July 27, 2015 at 11:31 am
SQLRNNR (7/27/2015)
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up the topic, Jason. And...
July 27, 2015 at 11:13 am
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up the topic, Jason. And hold still, will...
July 27, 2015 at 9:06 am
Phil Parkin (7/27/2015)
Brandie Tarvin (7/27/2015)
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught...
July 27, 2015 at 9:04 am
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught at that one in...
July 27, 2015 at 4:40 am
Viewing 15 posts - 2,431 through 2,445 (of 9,720 total)