January 6, 2015 at 12:03 pm
Ed Wagner (1/6/2015)
Koen Verbeeck (1/6/2015)
Ed Wagner (1/6/2015)
Jeff Moden (1/6/2015)
GilaMonster (1/5/2015)
Jeff Moden (1/4/2015)
I've taken to quoting the original post in many cases simply because too many people delete the original post even if they get a reasonable answer.I've had cases where I've corrected a statement someone made, then they went back and edited the incorrect statement in their post so that it looks like I'm talking nonsense or can't read.
Same here. Another fine reason to quote the original post if someone hasn't done so already.
I see another phenomenon has resurfaced - the familiar "thanks for the question" routine for QOTDs from 2011. We've seen it before. Don't worry, they'll change their username later.
I send a PM saying it's very annoying. He apologized but also remarked that maybe I should unsubscribe myself from those threads.
Apparently he also doesn't think the "Posts added today" being polluted with 3-year old QOTD should be seen either.
Besides, why should we unsubscribe? Now and again someone adds a useful new comment to an old thread. It's only the pointess, useless replies that we don't want to see, and the obvious solution if for people not to make pointless, useless replies.
Tom
January 6, 2015 at 12:52 pm
Grant Fritchey (1/6/2015)
Koen Verbeeck (1/6/2015)
Grant Fritchey (1/6/2015)
If any one thread gets stupid (this one for example)Blasphemy! 😀
Best wishes by the way.
And a Happy New Year to you as well. Seriously hoping to get back out to you for Techorama. Put in a good word for me.
I'll probably not be at Techorama (unless they have an amazing schedule). A bit too developer focused and not enough SQL/BI for me.
Doesn't make it a less great event though. Expertly organized.
I'll put in a good word for you at Gill 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 6, 2015 at 1:18 pm
Koen Verbeeck (1/6/2015)
I never clear out subscriptions, except for the daily questions.You never know if someone stumbles on a thread after an Internet search and has an additional question on the topic.
True dat... ditto dat.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 6, 2015 at 3:12 pm
SQLRNNR (1/6/2015)
Koen Verbeeck (1/6/2015)
Ed Wagner (1/6/2015)
Jeff Moden (1/6/2015)
GilaMonster (1/5/2015)
Jeff Moden (1/4/2015)
I've taken to quoting the original post in many cases simply because too many people delete the original post even if they get a reasonable answer.I've had cases where I've corrected a statement someone made, then they went back and edited the incorrect statement in their post so that it looks like I'm talking nonsense or can't read.
Same here. Another fine reason to quote the original post if someone hasn't done so already.
I see another phenomenon has resurfaced - the familiar "thanks for the question" routine for QOTDs from 2011. We've seen it before. Don't worry, they'll change their username later.
I send a PM saying it's very annoying. He apologized but also remarked that maybe I should unsubscribe myself from those threads.
It's what I end up doing at some point. I have so many subscriptions it is hard to wade through them all to find those though.
I agree completely. Maybe a nice enhancement would be to conditionally add a button in a thread that you are subscribed to that would allow users to unsubscribe or change the settings for a given thread without having to dig through the thousands of threads that I am subscribed to. For example, this thread would be nice to unsubscribe when going on vacation and set it up again when returning. Would be a pretty cool (and should be pretty easy) feature to add.
_______________________________________________________________
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/
January 6, 2015 at 4:59 pm
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...
January 6, 2015 at 6:42 pm
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...
I'm going to miss your countdown clock once you get to wherever it is you're going. 🙂
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
January 6, 2015 at 7:21 pm
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...I'm going to miss your countdown clock once you get to wherever it is you're going. 🙂
IIRC, that's the countdown to return home permanently. 🙂
January 6, 2015 at 7:38 pm
Luis Cazares (1/6/2015)
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...I'm going to miss your countdown clock once you get to wherever it is you're going. 🙂
IIRC, that's the countdown to return home permanently. 🙂
Yes, yes it is! :smooooth:
January 6, 2015 at 8:42 pm
Lynn Pettis (1/6/2015)
Luis Cazares (1/6/2015)
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...I'm going to miss your countdown clock once you get to wherever it is you're going. 🙂
IIRC, that's the countdown to return home permanently. 🙂
Yes, yes it is! :smooooth:
We can always start a new countdown just for Dwain...:hehe:
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
January 6, 2015 at 8:51 pm
SQLRNNR (1/6/2015)
Lynn Pettis (1/6/2015)
Luis Cazares (1/6/2015)
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...I'm going to miss your countdown clock once you get to wherever it is you're going. 🙂
IIRC, that's the countdown to return home permanently. 🙂
Yes, yes it is! :smooooth:
We can always start a new countdown just for Dwain...:hehe:
One thing I've always loved about The Thread and this forum in general is how helpful everyone always is.
Thanks Jason and Happy New Year to you! To Lynn and Luis too!
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
January 6, 2015 at 11:36 pm
dwain.c (1/6/2015)
SQLRNNR (1/6/2015)
Lynn Pettis (1/6/2015)
Luis Cazares (1/6/2015)
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...I'm going to miss your countdown clock once you get to wherever it is you're going. 🙂
IIRC, that's the countdown to return home permanently. 🙂
Yes, yes it is! :smooooth:
We can always start a new countdown just for Dwain...:hehe:
One thing I've always loved about The Thread and this forum in general is how helpful everyone always is.
Thanks Jason and Happy New Year to you! To Lynn and Luis too!
Ok, Dwain, from the top. Repeat after me... "1000"... 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
January 6, 2015 at 11:49 pm
Jeff Moden (1/6/2015)
dwain.c (1/6/2015)
SQLRNNR (1/6/2015)
Lynn Pettis (1/6/2015)
Luis Cazares (1/6/2015)
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...I'm going to miss your countdown clock once you get to wherever it is you're going. 🙂
IIRC, that's the countdown to return home permanently. 🙂
Yes, yes it is! :smooooth:
We can always start a new countdown just for Dwain...:hehe:
One thing I've always loved about The Thread and this forum in general is how helpful everyone always is.
Thanks Jason and Happy New Year to you! To Lynn and Luis too!
Ok, Dwain, from the top. Repeat after me... "1000"... 😉
Or...
99 bottles of beer on the wall, 99 bottles of beer! You take one down and pass it around, 98 bottles of beer on the wall!
Happy New Year Jeff!
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
January 7, 2015 at 12:39 am
Sean Lange (1/6/2015)
I agree completely. Maybe a nice enhancement would be to conditionally add a button in a thread that you are subscribed to that would allow users to unsubscribe or change the settings for a given thread without having to dig through the thousands of threads that I am subscribed to. For example, this thread would be nice to unsubscribe when going on vacation and set it up again when returning. Would be a pretty cool (and should be pretty easy) feature to add.
That would be a great addition.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2015 at 5:21 am
Koen Verbeeck (1/7/2015)
Sean Lange (1/6/2015)
I agree completely. Maybe a nice enhancement would be to conditionally add a button in a thread that you are subscribed to that would allow users to unsubscribe or change the settings for a given thread without having to dig through the thousands of threads that I am subscribed to. For example, this thread would be nice to unsubscribe when going on vacation and set it up again when returning. Would be a pretty cool (and should be pretty easy) feature to add.That would be a great addition.
Add another vote for this one - good idea.
January 7, 2015 at 7:56 am
dwain.c (1/6/2015)
SQLRNNR (1/6/2015)
Lynn Pettis (1/6/2015)
Luis Cazares (1/6/2015)
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...I'm going to miss your countdown clock once you get to wherever it is you're going. 🙂
IIRC, that's the countdown to return home permanently. 🙂
Yes, yes it is! :smooooth:
We can always start a new countdown just for Dwain...:hehe:
One thing I've always loved about The Thread and this forum in general is how helpful everyone always is.
Thanks Jason and Happy New Year to you! To Lynn and Luis too!
Happy New Year and New House to you Dwain
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
Viewing 15 posts - 46,831 through 46,845 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply