July 30, 2015 at 12:19 pm
How many people knew about this?
I think it is absolutely AWESOME.
July 30, 2015 at 12:28 pm
Brandie Tarvin (7/30/2015)
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 scary. @=)
No. It's not officially scary. It is however pretty damned frightening.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2015 at 12:28 pm
Need more magic crystals.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 30, 2015 at 12:33 pm
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:35 pm
Brandie Tarvin (7/30/2015)
Alvin Ramard (7/30/2015)
Need more magic crystals.I am writing code for an automagical solution to all coding problems.
Try starting all procedures with:
DROP DATABASE ...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 30, 2015 at 1:01 pm
Alvin Ramard (7/30/2015)
Brandie Tarvin (7/30/2015)
Alvin Ramard (7/30/2015)
Need more magic crystals.I am writing code for an automagical solution to all coding problems.
Try starting all procedures with:
DROP DATABASE ...
STOP STEALING MY COPYRIGHTED CODE! @=) :w00t:
July 30, 2015 at 3:06 pm
Can anyone help out here http://www.sqlservercentral.com/Forums/FindPost1706606.aspx? I'm not going to have the chance to write up complex queries til I get home next week, and the nagging is a tad annoying.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 30, 2015 at 4:27 pm
Sure thing.
July 30, 2015 at 4:43 pm
Grant Fritchey (7/30/2015)
Brandie Tarvin (7/30/2015)
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 promote his execution plan book (by posting a link to the free PDF).Hee. You two get around.
Just remember, read the second edition. The guy who wrote the first edition was an idiot. Soon, after the third edition comes out, the guy who wrote the second edition will become an idiot.
Triplets?
July 31, 2015 at 1:37 am
Oops. Obviously need more coffee...
Posted this to the wrong thread!
So I am now wondering what a Gummy Bear surgical operation is...
The youtube Gummy Video preview is, well bizarre!
About the spaceport - new to me, did like the statement something like "approved by FAA who must have a hidden sense of humor"...
So managed to work my way through my photos from the Friday of last weeks SQL Sat Manchester.
Here are the picks so far;
https://www.flickr.com/photos/127113040@N04/sets/72157656570136481
Fought the lighting in a few. But hopefully conveys the fun of the Friday night.
Just over 600 to go through now from the Saturday :O
Gail - good luck with getting everything in and signed off, sounds a very convoluted way to end, seeing as you have done the hard part!
Rodders...
Edit - URL is now a URL!
July 31, 2015 at 6:03 am
Brandie Tarvin (7/30/2015)
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 been trying to stamp out WITH (NOLOCK) use and now because things "aren't working" one group is trying to throw it back in.
ARGH!
Well, this is my battle for the week.
EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
Because it's magic.
We have one piece of software, third party - *not* developed internally, where it's on just about everything. And when I say everything, including, I kid you not, in triggers - on the inserted table. I mean, just what the ...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 31, 2015 at 6:27 am
Brandie Tarvin (7/30/2015)
And on another subject...I HAVE GUMMY BEARS! (fear me)
But Brandie, were they *GIANT* Gummy Bears?
http://giantgummybears.com/[/url]
Ooo, a 26lb Gummy Bear with a bowl shaped tummy so you can have gummy bears in your gummy bear!
Bearception!
July 31, 2015 at 8:46 am
Brandie Tarvin (7/30/2015)
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 been trying to stamp out WITH (NOLOCK) use and now because things "aren't working" one group is trying to throw it back in.
ARGH!
Well, this is my battle for the week.
EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
In our continuous integration server (TeamCity), one of the configurations installs our database. It then fires a "Validation Tool" that I wrote against the installed database and produces a report. One of the tests is to check for NOLOCK, if it is found then it fails the build and sets off the siren of shame[/url] and sends an e-mail to the person that caused the issue. I thoroughly recommend doing something similar for your own development environment.
July 31, 2015 at 8:53 am
jasona.work (7/31/2015)
Brandie Tarvin (7/30/2015)
And on another subject...I HAVE GUMMY BEARS! (fear me)
But Brandie, were they *GIANT* Gummy Bears?
http://giantgummybears.com/[/url]
Ooo, a 26lb Gummy Bear with a bowl shaped tummy so you can have gummy bears in your gummy bear!
Bearception!
No, they were mini-gummy bears. But I LOVE the party gummy. That is awesome! (and somewhat scary from a blood sugar perspective).
Viewing 15 posts - 49,771 through 49,785 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply