June 23, 2014 at 2:08 pm
SQLRNNR (6/23/2014)
Sean Lange (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
sweet. Seems that the two of us have been racing for the last few months. 😛
Yeah - you two have been quite busy. Where do you find the time?
Sometimes a dull moment at work but mostly at the evening when the rest of the family went to bed and I'm still watching TV 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 23, 2014 at 2:41 pm
SQLRNNR (6/23/2014)
Sean Lange (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
sweet. Seems that the two of us have been racing for the last few months. 😛
Yeah - you two have been quite busy. Where do you find the time?
DBCC TIMEWARP duh!!! 😛
It is the 134th parameter that allows for extra posting at SSC, unless your current point total is less than 1,000 in which case it is 133rd because the 8th parameter is not required.
_______________________________________________________________
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/
June 23, 2014 at 2:48 pm
One for three when shooting from hip. Love the complaints when the info provided is lacking.
June 23, 2014 at 2:50 pm
Lynn Pettis (6/23/2014)
One for three when shooting from hip. Love the complaints when the info provided is lacking.
The one you nailed blew me away!!! I was still trying to unravel my eyes from the post and your post apparently was a direct hit.
_______________________________________________________________
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/
June 23, 2014 at 4:23 pm
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Nicely done.
"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
June 24, 2014 at 12:07 am
Grant Fritchey (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Nicely done.
Yes, I'm getting closer 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2014 at 1:47 am
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Top work geezer, most of 'em are pretty darned good posts too.
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
June 24, 2014 at 4:54 am
Well done Koen!
And in other news, just read Jeff's article on functions... Another stunning Spackle, and one I need to re-read, probably more than once! Nice job there Jeff
Rodders...
June 24, 2014 at 5:10 am
Koen Verbeeck (6/24/2014)
Grant Fritchey (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Nicely done.
Yes, I'm getting closer 😉
Well, not quite so close now.
"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
June 24, 2014 at 5:20 am
Grant Fritchey (6/24/2014)
Koen Verbeeck (6/24/2014)
Grant Fritchey (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Nicely done.
Yes, I'm getting closer 😉
Well, not quite so close now.
Curses!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2014 at 9:39 am
rodjkidd (6/24/2014)
Well done Koen!And in other news, just read Jeff's article on functions... Another stunning Spackle, and one I need to re-read, probably more than once! Nice job there Jeff
Rodders...
As always. Then again, we've come to expect nothing less. I love the hard-data comparison he shows of how the timing mechanism used impacts the result.
June 24, 2014 at 10:08 am
Congratulations Koen. You're certainly one of the top posters on Bi.
On a completely different subject, I'm taking 20467BC course this week and found some surprises like using while loops to create sample data, recommendations to use partitioning for performance and nolock hints on every view in the data warehouse to prevent concurrency issues. :w00t:
Are they serious? Should I unlearn something?
June 24, 2014 at 10:46 am
I took a course once where I knew more than the teacher. By the end of the week every time the teacher left the room (which was often) the class would ask me for verification. I did learn a couple of things but not what I had hoped to. It was for Visual FoxPro and the teacher kept teaching the pre visual way instead of using the new ways.
Another class I took the first thing the teacher did each day was list the corrections to the Microsoft supplied material.
June 24, 2014 at 10:53 am
< rant >
Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() + 10 doesn't work.
< /rant >
June 24, 2014 at 10:53 am
Luis Cazares (6/24/2014)
Congratulations Koen. You're certainly one of the top posters on Bi.On a completely different subject, I'm taking 20467BC course this week and found some surprises like using while loops to create sample data, recommendations to use partitioning for performance and nolock hints on every view in the data warehouse to prevent concurrency issues. :w00t:
Are they serious? Should I unlearn something?
Create sample data with while loops? Using nolock? I hope you took a shower afterwards.
Viewing 15 posts - 44,356 through 44,370 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply