April 19, 2015 at 5:38 pm
dwain.c (4/19/2015)
Eirikur Eiriksson (4/19/2015)
Grant Fritchey (4/19/2015)
Eirikur Eiriksson (4/19/2015)
spaghettidba (4/19/2015)
Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.Did I say something wrong? Was my comment too harsh?
Nothing wrong with your comment, in fact I was about to post almost exactly the same comment when I saw yours.
😎
I looked but couldn't find the post. Link?
It's here.
😎
I saw it but didn't notice it was a republish. Didn't comment though because I expected the author wouldn't like what I had to say. I like what Jeff has added to the thread about the proof being in the performance test.
You can find the asbestos underwear right next to the fish holding hands Luis found on my ecommerce web site.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
April 20, 2015 at 6:30 am
SQLRNNR (4/19/2015)
Eirikur Eiriksson (4/19/2015)
Grant Fritchey (4/19/2015)
Eirikur Eiriksson (4/19/2015)
spaghettidba (4/19/2015)
Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.Did I say something wrong? Was my comment too harsh?
Nothing wrong with your comment, in fact I was about to post almost exactly the same comment when I saw yours.
😎
I looked but couldn't find the post. Link?
It's here.
😎
Yeah, nothing wrong with the comments there.
I don't think the comments were out of line. It was an opinion stated about the article. It was't attacking the person. But, if there was a lot of negative stuff posted before, I can see how you mget defensive. I've been that way once or twice.
"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
April 20, 2015 at 7:47 am
Grant Fritchey (4/20/2015)
SQLRNNR (4/19/2015)
Eirikur Eiriksson (4/19/2015)
Grant Fritchey (4/19/2015)
Eirikur Eiriksson (4/19/2015)
spaghettidba (4/19/2015)
Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.Did I say something wrong? Was my comment too harsh?
Nothing wrong with your comment, in fact I was about to post almost exactly the same comment when I saw yours.
😎
I looked but couldn't find the post. Link?
It's here.
😎
Yeah, nothing wrong with the comments there.
I don't think the comments were out of line. It was an opinion stated about the article. It was't attacking the person. But, if there was a lot of negative stuff posted before, I can see how you mget defensive. I've been that way once or twice.
I think the comments were appropriate. The discussion was also correct - let the code do the walking.
April 20, 2015 at 7:57 am
Steve Jones - SSC Editor (4/15/2015)
http://radar.oreilly.com/2015/04/rebooting-a-1970s-satellite-with-modern-software-and-hardware.html
And here I am thinking this was a MASH reference, http://mash.wikia.com/wiki/Walter_%22Radar%22_O%E2%80%99Reilly😀
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 20, 2015 at 9:26 am
Grant Fritchey (4/20/2015)
SQLRNNR (4/19/2015)
Eirikur Eiriksson (4/19/2015)
Grant Fritchey (4/19/2015)
Eirikur Eiriksson (4/19/2015)
spaghettidba (4/19/2015)
Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.Did I say something wrong? Was my comment too harsh?
Nothing wrong with your comment, in fact I was about to post almost exactly the same comment when I saw yours.
😎
I looked but couldn't find the post. Link?
It's here.
😎
Yeah, nothing wrong with the comments there.
I don't think the comments were out of line. It was an opinion stated about the article. It was't attacking the person. But, if there was a lot of negative stuff posted before, I can see how you mget defensive. I've been that way once or twice.
I read the comments from the first go around. They were article focused as well and along the same lines (e.g. dynamic would be a better solution). I didn't think they were vicious.
In the end, I think the approach of demo'ing via code is good.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 20, 2015 at 9:29 am
I'm off the VMWare for the week, so get ready for a bunch of stuff on why virtualization is the best thing ever and all of you are doing it wrong with physical hosts 😉
April 20, 2015 at 9:37 am
ACK! NO! Not VMware!!!!
(I really need to install that on one of my boxes.)
Also, tales from the dark side. We have someone setting up a demo for a thing. He asked for my help with a data scrub. Which was well and good until he mentioned the word "production."
Fortunately, he's a nice guy and totally understands my not-quite-freak-out. "We're fine with scrubbing QA if we can get access to it," he says. Well, DUH. That's an easy security decision to make. Right?
Brandie wants to keep her job. Will scrub data in QA and give QA access for demo, because otherwise is madness. MADNESS I SAY! :w00t:
April 21, 2015 at 1:00 am
Jeff Moden (4/19/2015)
Excellent. And help that young fellow learn how to wear asbestos underwear when everyone is trying to burn him at the stake.
You try to burn him and give him cancer? 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 21, 2015 at 5:19 am
Koen Verbeeck (4/21/2015)
Jeff Moden (4/19/2015)
Excellent. And help that young fellow learn how to wear asbestos underwear when everyone is trying to burn him at the stake.You try to burn him and give him cancer? 😀
🙂 Go the whole hog and use leaded petrol for ignition!
April 23, 2015 at 8:04 am
Finally made the dive into using TVPs. Pretty neat stuff actually.
April 23, 2015 at 8:37 am
Interesting. I get notifications on old threads when new posts are added but I'm not getting any on the new threads I have posted on. Anyone else having this issue?
April 23, 2015 at 8:50 am
Lynn Pettis (4/23/2015)
Finally made the dive into using TVPs. Pretty neat stuff actually.
They are pretty slick. I was working on an article to explain how to use them both from the database and developer side to demonstrate how super easy they can be to use. Maybe I will have to resurrect this idea and get it finished.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 23, 2015 at 9:16 am
Sean Lange (4/23/2015)
Lynn Pettis (4/23/2015)
Finally made the dive into using TVPs. Pretty neat stuff actually.They are pretty slick. I was working on an article to explain how to use them both from the database and developer side to demonstrate how super easy they can be to use. Maybe I will have to resurrect this idea and get it finished.
That would be a very helpful article. From a database side it seems easy. Using them from a developer side where you may be using a .NET language, or Java, or Cold Fusion to access a database is where I would have no clue.
April 24, 2015 at 1:39 am
What is the world coming to, this one posted the skype but forgot the Credit Card Number 😀
😎
April 24, 2015 at 1:42 am
<Ooops!>Wrong forum</Ooops!>
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
Viewing 15 posts - 48,226 through 48,240 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply