April 25, 2012 at 8:44 pm
Lynn Pettis (4/25/2012)
The Dixie Flatline (4/25/2012)
Lynn Pettis (4/25/2012)
The Dixie Flatline (4/25/2012)
Hi, Lynn.Just... walk... away.
Don't look back again. Delete all those threads from your notification list.
Don't look at it and it will go away. 😉
No, no it won't. I will see that he posted and be drawn to the flame like a moth. I am doomed! DOOMED, I say! 😛
Anytime you see his name on any post, just shut down your computer and go take a walk.
Do or do not. There is no try.
Now I'm going to take my own advice and start ignoring your posts ranting about him. 😉
Well, before you do, I think he is smarter than all of us. He seems to be able to solve all his own problems with no real help from us.
Don't we all?
April 25, 2012 at 11:57 pm
GilaMonster (4/25/2012)
... (for a PASS abstract)...
Does that mean you're going to the Summit after all?
April 26, 2012 at 12:33 am
I love this thread! Just found it and have a way to go in reading it all though. All these people grousing about other posters not giving them the information they need to help. Love that word grousing too... but I digress.
I confess I have encountered the occasional thread where the poster was just asking an inane question or worse yet are just completely clueless about a response that you just made (after hard work) to try and help the poor schmuck.
Alas, I can't comment on whether the questions have degraded in quality recently, as I've only been posting a few months myself.
My approach is from a different perspective though. I'm pretty new to SQL so I just use the questions as a learning tool for myself. Practice, practice, practice or so they say. I figure the more problems I solve, the faster I'll get at it.
That and I like the competition. I try to give a better solution than the ones posted before. Don't always manage it. But that aspect adds to the learning experience.
I do try to limit my answers to those I can come up with in 30 minutes or less though.
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 26, 2012 at 12:44 am
For a change I get to welcome a new member to The Thread. Welcome, Dwain!
Been watching you for a while, and while I myself don't call myself an expert in all SQL, I must say, your posts have been really helpful. Keep it up, man!
Oh, and this thread has really gone off-topic for most of the time in the last two/three years. It is more like a water cooler as other Threadizens will confirm. Topics go left-right-center all the time. So feel free to dump your thoughts any time.
BTW, what's with the fish? Did you eat it or did you toss it back? And, where are you? Judging from the time you posted earlier, you're not in the States. Right?
April 26, 2012 at 12:53 am
I'm no Jedi either, merely an intrepid Padawan!
I live in Thailand. That fish is a 45kg Mekong Catfish I caught last Sept. We have a fishing pond here in BKK. A buddy and I go once or twice a year. We ususally catch >200kg each of fish in one day, in the 8-40kgh range. It's all catch and release and incredible fun.
I'm thinking of changing my mantra to:
No loops! No cursors! No RBAR! No small fish! Hoo-uh!
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 26, 2012 at 1:02 am
LOL!
Forgive my ignorance, but where is BKK? Bangkok? Been there once, a long time ago (1988), plus toured the north of the country. Incredibly beautiful. But fish in Bangkok? There's more Tuk-Tuks than anything else there.
April 26, 2012 at 1:23 am
Yup BKK=Bangkok! More taxis than tuk-tuks now.
You mentioned you were following my posts. What are you, a stalker or something?
Merely jesting my friend. I'll take that as a compliment (along with your comment that you think my posts are helpful :-)). I think my avatar tends to draw people to my posts more than anything else.
I do sort of think of myself as being a little selfish. Most of the time, I'll blast out a solution without trying to teach why it works. As I said, I'm using them as a learning exercise. Many of the Jedi try to lead the posters to their own solutions, which in the long run would be better for them.
I can say that I don't like be stumped on a problem. While there's a lot of questions here that I wouldn't even try because they're not my area of expertise, so far I've only been stumped 3 times.
The first was the only question of my own that I've posted. No responses on that thread and I eventually came up with a workaround even though I did not like it. The second stump led me to submit an article which has been accepted but not published.
The latest was today - on this thread: http://www.sqlservercentral.com/Forums/Topic1289612-391-1.aspx
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 26, 2012 at 1:53 am
dwain.c (4/26/2012)
Yup BKK=Bangkok! More taxis than tuk-tuks now.
Shame, they were fun, although air pollution was horrific
What are you, a stalker or something?
Nope, just following the Newbies and T-SQL threads, and you have been featuring there prominently lately.
I think my avatar tends to draw people to my posts more than anything else.
Nope, there are more people with fish in their hands around. Just check The Thread's history.
Many of the Jedi try to lead the posters to their own solutions, which in the long run would be better for them.
That's an art I haven't mastered myself yet either. Maybe, one day, I'll get to that stage too.
I can say that I don't like be stumped on a problem. While there's a lot of questions here that I wouldn't even try because they're not my area of expertise, so far I've only been stumped 3 times.
What, only three times? You're good!
The latest was today - on this thread: http://www.sqlservercentral.com/Forums/Topic1289612-391-1.aspx
Now that's really a generic question. I hate this answer, but "It depends".
April 26, 2012 at 3:32 am
WayneS (4/25/2012)
Does this mean that you're getting back to blogging? Your backlog of items to finish is done? Your masters thesis? (I didn't know your 1yr sabbatical from blogging was over yet - and I for one have really missed it! :-D)
Eventually.
No.
No.
Wasn't a fixed year, just said taking a break til other stuff is finished.
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
April 26, 2012 at 3:36 am
Jan Van der Eecken (4/25/2012)
GilaMonster (4/25/2012)
... (for a PASS abstract)...Does that mean you're going to the Summit after all?
It means I'm submitting abstracts, that's all.
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
April 26, 2012 at 6:52 am
dwain.c (4/26/2012)
I love this thread! Just found it and have a way to go in reading it all though. All these people grousing about other posters not giving them the information they need to help. Love that word grousing too... but I digress.I confess I have encountered the occasional thread where the poster was just asking an inane question or worse yet are just completely clueless about a response that you just made (after hard work) to try and help the poor schmuck.
Alas, I can't comment on whether the questions have degraded in quality recently, as I've only been posting a few months myself.
My approach is from a different perspective though. I'm pretty new to SQL so I just use the questions as a learning tool for myself. Practice, practice, practice or so they say. I figure the more problems I solve, the faster I'll get at it.
That and I like the competition. I try to give a better solution than the ones posted before. Don't always manage it. But that aspect adds to the learning experience.
I do try to limit my answers to those I can come up with in 30 minutes or less though.
Welcome to The Thread. If you actually take the time to read all the posts you will find that there is much more to this than just complaining about posters. We call this the water cooler and you will find a lot more goes on here.
April 26, 2012 at 7:32 am
If you actually read all the posts and admit to it, rumors are there is a 12 step course to help you out.
DBCC time warp can possibly help you catch up, although some of the parameters may exhibit random behavior.
Fear not - these are features!
April 26, 2012 at 7:41 am
Anybody know policy based management better than I do (shouldn't be too hard). This guys has a question about using ExecuteSql with parameters.
http://www.sqlservercentral.com/Forums/Topic1290088-391-1.aspx
_______________________________________________________________
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 26, 2012 at 7:43 am
I found a bug in AlwaysOn. Anyone want to vote on it?
"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 26, 2012 at 8:00 am
Grant Fritchey (4/26/2012)
I found a bug in AlwaysOn. Anyone want to vote on it?
Voted!
-- Gianluca Sartori
Viewing 15 posts - 35,806 through 35,820 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply