Viewing 15 posts - 2,416 through 2,430 (of 9,707 total)
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
So everyone at work is thrilled with me right now for solving a slow-running report issue when I discovered 4 table scans (of the same table) in a proc and...
July 24, 2015 at 9:48 am
Viewing 15 posts - 2,416 through 2,430 (of 9,707 total)