August 22, 2013 at 1:23 pm
Koen Verbeeck (8/22/2013)
Jack Corbett (8/22/2013)
Man, I better get back to answering questions, I'm #11 all-time in points now and Koen is bearing down on me:w00t:Aw fudge. I was hoping you wouldn't notice it.
My ninja tactics have failed...
ps: the only reason I've been so active last weeks is because Sean is on hot pursuit of me π :hehe:
hehe I just kind of got in the habit of it over the last year or so and then all of a sudden I was moving up the list. Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. π
_______________________________________________________________
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/
August 22, 2013 at 1:34 pm
Sean Lange (8/22/2013)
Koen Verbeeck (8/22/2013)
Jack Corbett (8/22/2013)
Man, I better get back to answering questions, I'm #11 all-time in points now and Koen is bearing down on me:w00t:Aw fudge. I was hoping you wouldn't notice it.
My ninja tactics have failed...
ps: the only reason I've been so active last weeks is because Sean is on hot pursuit of me π :hehe:
hehe I just kind of got in the habit of it over the last year or so and then all of a sudden I was moving up the list. Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. π
I'm no low hanging fruit dammit π I won't give up without a fight! π
Seriously now, the "top 10" has been quiet the last few months (with the exception of Gail and Jeff of course). I had a super busy first half of the year, so I didn't have the time to answer questions unfortunately. (I even had my Microsoft Community Contributor status on MSDN revoked. Sniff. Not that I lost any sleep over it).
But it seems a lot of us have it real busy lately.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2013 at 1:46 pm
Koen Verbeeck (8/22/2013)
Sean Lange (8/22/2013)
Koen Verbeeck (8/22/2013)
Jack Corbett (8/22/2013)
Man, I better get back to answering questions, I'm #11 all-time in points now and Koen is bearing down on me:w00t:Aw fudge. I was hoping you wouldn't notice it.
My ninja tactics have failed...
ps: the only reason I've been so active last weeks is because Sean is on hot pursuit of me π :hehe:
hehe I just kind of got in the habit of it over the last year or so and then all of a sudden I was moving up the list. Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. π
I'm no low hanging fruit dammit π I won't give up without a fight! π
Seriously now, the "top 10" has been quiet the last few months (with the exception of Gail and Jeff of course). I had a super busy first half of the year, so I didn't have the time to answer questions unfortunately. (I even had my Microsoft Community Contributor status on MSDN revoked. Sniff. Not that I lost any sleep over it).
But it seems a lot of us have it real busy lately.
bwahahahaha!!!
I didn't mean you were low hanging fruit. In fact, I don't think I have ever grabbed you. π I was referring to the fact that since the top 10 aren't posting I can come along and toss my crappy responses at them instead. Good for me...but maybe not so good for SSC's reputation as a place to get quality responses.
_______________________________________________________________
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/
August 22, 2013 at 1:53 pm
Sean Lange (8/22/2013)
I didn't mean you were low hanging fruit. In fact, I don't think I have ever grabbed you. π
It's been a while since I actually laughed out loud behind my computer π
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2013 at 2:56 pm
Koen Verbeeck (8/22/2013)
Sean Lange (8/22/2013)
I didn't mean you were low hanging fruit. In fact, I don't think I have ever grabbed you. π
It's been a while since I actually laughed out loud behind my computer π
Now why would you sit behind your computer π
August 22, 2013 at 2:59 pm
Jan Van der Eecken (8/22/2013)
Koen Verbeeck (8/22/2013)
Sean Lange (8/22/2013)
I didn't mean you were low hanging fruit. In fact, I don't think I have ever grabbed you. π
It's been a while since I actually laughed out loud behind my computer π
Now why would you sit behind your computer π
I translated literally from Dutch.
What's the correct term in English?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2013 at 3:00 pm
Koen Verbeeck (8/22/2013)
Sean Lange (8/22/2013)
I didn't mean you were low hanging fruit. In fact, I don't think I have ever grabbed you. π
It's been a while since I actually laughed out loud behind my computer π
He was trying to hide because he was worried I was going to try to grab him!!!
_______________________________________________________________
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/
August 22, 2013 at 3:02 pm
Koen Verbeeck (8/22/2013)
Jan Van der Eecken (8/22/2013)
Koen Verbeeck (8/22/2013)
Sean Lange (8/22/2013)
I didn't mean you were low hanging fruit. In fact, I don't think I have ever grabbed you. π
It's been a while since I actually laughed out loud behind my computer π
Now why would you sit behind your computer π
I translated literally from Dutch.
What's the correct term in English?
In English you would be sitting in front of or maybe at your computer. Sitting behind it would put you on the dusty side with all the cords. π
_______________________________________________________________
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/
August 22, 2013 at 4:17 pm
Sean Lange (8/22/2013)
Good for me...but maybe not so good for SSC's reputation as a place to get quality responses.
Do you mean that we're destroying this site reputation? I'll better continue quiet.:-D
August 22, 2013 at 4:48 pm
Sean Lange (8/22/2013)
..... I don't think I have ever grabbed you. π
Sometimes, it's the small, unknown things in life that end up giving me the greatest pleasure. I'm so glad you haven't tried! :w00t::w00t::w00t:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 22, 2013 at 4:49 pm
WayneS (8/22/2013)
Sean Lange (8/22/2013)
..... I don't think I have ever grabbed you. πSometimes, it's the small, unknown things in life that end up giving me the greatest pleasure. I'm so glad you haven't tried! :w00t::w00t::w00t:
Are you sure you want to say it like that?
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
August 22, 2013 at 4:51 pm
SQLRNNR (8/22/2013)
WayneS (8/22/2013)
Sean Lange (8/22/2013)
..... I don't think I have ever grabbed you. πSometimes, it's the small, unknown things in life that end up giving me the greatest pleasure. I'm so glad you haven't tried! :w00t::w00t::w00t:
Are you sure you want to say it like that?
Since you've quoted me, it's too late to change. But hey... it ties in with the small, hanging fruit, doesn't it?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 22, 2013 at 8:01 pm
Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.
We were thinking of getting a stone benchtop, but depending on the stone you may need to oil it, or it can suffer from thermal shock. Has anyone had any bad experiences with stone benchtops?
Fal.
August 22, 2013 at 8:04 pm
Fal (8/22/2013)
Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.We were thinking of getting a stone benchtop, but depending on the stone you may need to oil it, or it can suffer from thermal shock. Has anyone had any bad experiences with stone benchtops?
Fal.
Have a chat with ChrisM@Work. He's an expert at hobs, kitchent replacements, etc. as he's been working on his for as long as I can remember. π
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
August 23, 2013 at 1:54 am
dwain.c (8/22/2013)
Fal (8/22/2013)
Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.We were thinking of getting a stone benchtop, but depending on the stone you may need to oil it, or it can suffer from thermal shock. Has anyone had any bad experiences with stone benchtops?
Fal.
Have a chat with ChrisM@Work. He's an expert at hobs, kitchent replacements, etc. as he's been working on his for as long as I can remember. π
That's why ChrisM@Home has been so quiet this year π
Fal, we went with quartz worktop. It looks and sounds like natural stone and costs about the same (it's templated and cut the same way) but it's impermeable, acid-resistant and tougher. Natural stone is gorgeous but I wouldn't recommend it for a busy family kitchen unless you're prepared to put in a fair amount of time and effort looking after it and can accept the scratches when they appear.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 15 posts - 41,011 through 41,025 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply