January 14, 2015 at 11:34 am
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:
Action figures will soon be available! 😎
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2015 at 12:01 pm
Koen Verbeeck (1/14/2015)
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:Action figures will soon be available! 😎
With or without superhero capes?
January 14, 2015 at 1:02 pm
Brandie Tarvin (1/14/2015)
Koen Verbeeck (1/14/2015)
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:Action figures will soon be available! 😎
With or without superhero capes?
Edna Mode
No capes!...
Do you remember Thunderhead? Tall, storm powers? Nice man, good with kids.
...
November 15th of '58! All was well, another day saved, when... his cape snagged on a missile fin!
...
Stratogale! April 23rd, '57! Cape caught in a jet turbine!
...
Metaman, express elevator! Dynaguy, snagged on takeoff! Splashdown, sucked into a vortex!
...
No capes!
January 14, 2015 at 1:11 pm
Koen Verbeeck (1/14/2015)
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:Action figures will soon be available! 😎
Certainly there is a branded Witbier on it's way too:w00t:
😎
January 14, 2015 at 1:20 pm
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
January 14, 2015 at 1:24 pm
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
Don't worry about it. Some people just have to nitpick everything.
January 14, 2015 at 1:35 pm
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
The question of today wasn't bad at all. A bit simple maybe (because there was this big discussion last week about aggregates and NULL, so I am amazed people still got it wrong). People just being pedantic over rows vs nulls.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2015 at 1:44 pm
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.The question of today wasn't bad at all. A bit simple maybe (because there was this big discussion last week about aggregates and NULL, so I am amazed people still got it wrong). People just being pedantic over rows vs nulls.
My guess is that the people complaining today are the same ones that got it wrong because they just don't understand the concept. The question today was a good one imho.
_______________________________________________________________
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 14, 2015 at 1:47 pm
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.The question of today wasn't bad at all. A bit simple maybe (because there was this big discussion last week about aggregates and NULL, so I am amazed people still got it wrong). People just being pedantic over rows vs nulls.
My guess is that the people complaining today are the same ones that got it wrong because they just don't understand the concept. The question today was a good one imho.
Although I have to admit you're a bit generous with the points lately Steve.
But I don't mind, it brings me closer to Grant mwoehahahahahahaha.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2015 at 3:18 pm
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.The question of today wasn't bad at all. A bit simple maybe (because there was this big discussion last week about aggregates and NULL, so I am amazed people still got it wrong). People just being pedantic over rows vs nulls.
My guess is that the people complaining today are the same ones that got it wrong because they just don't understand the concept. The question today was a good one imho.
I agree. I almost picked the wrong answer then I looked at the query again. I wasn't registering the * initially. It was a good question.
"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
January 14, 2015 at 3:22 pm
Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!Thanks everyone for voting!
Outstanding! Well done, Koen!!!
--Jeff Moden
Change is inevitable... Change for the better is not.
January 14, 2015 at 3:50 pm
Back on topic for a moment.
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off the wall, no?
"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
January 14, 2015 at 4:04 pm
Grant Fritchey (1/14/2015)
Back on topic for a moment.Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off the wall, no?
Meaning my QotDs?
January 14, 2015 at 4:41 pm
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:
I'll second this.
Congratulations Koen!
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 14, 2015 at 5:33 pm
Steve Jones - SSC Editor (1/14/2015)
Grant Fritchey (1/14/2015)
Back on topic for a moment.Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off the wall, no?
Meaning my QotDs?
Heh... nah. Those have always been weird. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 46,921 through 46,935 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply