Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 44,356 through 44,370 (of 66,679 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259095 More actions · Answer 1

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

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/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

One for three when shooting from hip. Love the complaints when the info provided is lacking.

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

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/

Grant Fritchey SSC Guru Points: 398815 More actions · Answer 5

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

Koen Verbeeck SSC Guru Points: 259095 More actions · Answer 6

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 7

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.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

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

rodjkidd SSCoach Points: 15914 More actions · Answer 8

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...

Grant Fritchey SSC Guru Points: 398815 More actions · Answer 9

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

Koen Verbeeck SSC Guru Points: 259095 More actions · Answer 10

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Luis Cazares SSC Guru Points: 183700 More actions · Answer 12

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?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

djj SSCoach Points: 18831 More actions · Answer 13

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.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 14

< 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 >

Ed Wagner SSC Guru Points: 287026 More actions · Answer 15

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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions