Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 12,016 through 12,030 (of 66,712 total)

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

Paul White SSC Guru Points: 150467 More actions · Answer 1

jcrawf02 (2/23/2010)
Paul White (2/23/2010)
Will do. Be brutal 😀
Dear Water, be wet. 😛

I was drinking Coca-Cola when I read that.

I now have a fizzing sensation in my nasal cavity.

I thought it was important to share that fact with the wider community.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Paul White SSC Guru Points: 150467 More actions · Answer 2

Alvin Ramard (2/23/2010)
Before we say too much about Barry as MVP, there's a question that needs to be answered. Has he plagiarized enough articles or blog posts to become an MVP? 😛

Books, you forgot books 😀

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Paul White SSC Guru Points: 150467 More actions · Answer 3

RBarryYoung (2/23/2010)
Umm, I fear I'm being dense, but what is [a Sequence Table]?

You'll have to wait for the article 😛

No, it's a physical table used to implement a custom sequence - a bit like IDENTITY on steroids.

It's often done badly, and has a poor reputation. There may be other (better?) names for it that I am unaware of.

The main use for it is in generating a sequence of values which are often used as key values.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Paul White SSC Guru Points: 150467 More actions · Answer 4

I fear I may, in fact, be a nerd :unsure:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Paul White SSC Guru Points: 150467 More actions · Answer 5

RBarryYoung (2/23/2010)
Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see if a CLR solution come overcome the "call per row" penalty.

Coming right up! It will be a UDA - so there's no call-per-row penalty. It is entirely implemented as a Stream Aggregate operator directly in the plan. If I have my way, you'll see a scan of a covering NC index, a Segement, Sequence Project, and the Stream Aggregate. That's it.

RBarryYoung (2/23/2010)
As for the old Hammer saw (:-P), I actually would defend SQL as an appropriate and even preferred solution for this problem (barring really significant performance differences).

This will be fun!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Steve Jones - SSC Editor SSC Guru Points: 736280 More actions · Answer 6

Steve Jones - SSC Editor

SSC Guru

Points: 736280

February 23, 2010 at 4:26 pm

#1123966

Barry, sourced, quoted, limited to < 1 para, fair use.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 7

Steve Jones - Editor (2/23/2010)
Barry, sourced, quoted, limited to < 1 para, fair use.

Thanks, Steve. good to know I still have some legal chops left... 🙂

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 8

Paul White (2/23/2010)
I fear I may, in fact, be a nerd :unsure:

You know, it's still not too late to bite the head off a live chicken. ... Eh? :-D:-D:-D

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

WayneS SSC Guru Points: 95460 More actions · Answer 9

Steve Jones - Editor (2/23/2010)
Barry, sourced, quoted, limited to < 1 para, fair use.

Steve,

While I agree, my question is whether a quote from a paid subscription site (as where this quote is from), would constitute fair use?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Steve Jones - SSC Editor SSC Guru Points: 736280 More actions · Answer 10

Most sources we use are paid for. There isn't a lot in the public domain. Posting a short excerpt from a book is no different than from a website. You have to give credit, and limit the copying. You also need to comment on it or use it to show a point. Not sure it as the basis for your work, but build on it.

Paul White SSC Guru Points: 150467 More actions · Answer 11

WayneS (2/23/2010)
Steve Jones - Editor (2/23/2010)
Barry, sourced, quoted, limited to < 1 para, fair use.
Steve, while I agree, my question is whether a quote from a paid subscription site (as where this quote is from), would constitute fair use?

That's agreeing? :unsure: 😉

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Steve Jones - SSC Editor SSC Guru Points: 736280 More actions · Answer 12

And I found another great question today. Someone hadn't had an answer in a few days, so they edited and removed their question.

Grrrrrrrreeeeeaaaaaaattttttttttt

john.arnott SSChampion Points: 11882 More actions · Answer 13

RBarryYoung (2/23/2010)

Why do Ozzies (Ozzites? Ozzians? Ozmen?...) also think that jokes involving sheep are funny? I never did get this ... 😀

[/Quote]

In my limited experience, the Aussies usually think sheep jokes are funny cuz they're generally told on the Kiwis. I get the impression (from here in California) that it's much like the Minnesotans telling ice-fishing jokes on the North Dakotans. The rest of us end up just scratching our heads at the humor.

john.arnott SSChampion Points: 11882 More actions · Answer 14

GilaMonster (2/23/2010)
Are we geeks or not?

I know I must be one. My thought on seeing the 12000 mark go by was "less than 300 till the 12K mark."

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Paul White (2/23/2010)
jcrawf02 (2/23/2010)
Paul White (2/23/2010)
Will do. Be brutal 😀
Dear Water, be wet. 😛
I was drinking Coca-Cola when I read that.
I now have a fizzing sensation in my nasal cavity.
I thought it was important to share that fact with the wider community.

Sure now call us fat 😉

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