Viewing 15 posts - 2,431 through 2,445 (of 9,725 total)
Alvin Ramard (7/30/2015)
Need more magic crystals.
I am writing code for an automagical solution to all coding problems.
July 30, 2015 at 12:33 pm
How many people knew about this?
I think it is absolutely AWESOME.
July 30, 2015 at 12:19 pm
SQLRNNR (7/30/2015)
Brandie Tarvin (7/30/2015)
And on another subject...I HAVE GUMMY BEARS! (fear me)
That can be taken multiple ways.
Let's guess that means this instead of the surgical process.
https://www.youtube.com/watch?v=mLpNGp-IFIk
edit: better link
That is officially...
July 30, 2015 at 12:19 pm
And on another subject...
I HAVE GUMMY BEARS! (fear me)
July 30, 2015 at 10:12 am
And now I'm finding out our databases aren't set up to allow snapshot or read committed isolation. So do I take the overhead hit or not?
How do people deal with...
July 30, 2015 at 8:29 am
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
Viewing 15 posts - 2,431 through 2,445 (of 9,725 total)