Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 17,386 through 17,400 (of 66,712 total)

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 1

Maybe a compromise would be kossy-yus-ko...

I live in Lafayette county, which was named after another Revolutionary War general. Of course we mispronounce it Luh-FAY- ette.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

Pages and pages of word pronunciations. I can't say I'd have ever thought that would be in here.

One a side note, I thought this was interesting: http://sqlblog.com/blogs/linchi_shea/archive/2010/08/11/performance-impact-forget-about-sets-and-focus-on-loops.aspx

LutzM SSC Guru Points: 107049 More actions · Answer 3

Steve,

you asked for some improvement ideas for the SSC site: add the option to upload (and play) sound files :-D:-D

Then we could actually hear the pronounciation of all the words 😉

That might even turn SSC into a SQLWiki, where "cursor" might be pronounced like "Don't even think about it!!" :hehe:

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

LutzM (8/11/2010)
Steve,
you asked for some improvement ideas for the SSC site: add the option to upload (and play) sound files :-D:-D
Then we could actually hear the pronounciation of all the words 😉
That might even turn SSC into a SQLWiki, where "cursor" might be pronounced like "Don't even think about it!!" :hehe:

I second the notion.:-D:alien:

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

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 5

Steve Jones - Editor (8/11/2010)
Pages and pages of word pronunciations. I can't say I'd have ever thought that would be in here.
One a side note, I thought this was interesting: http://sqlblog.com/blogs/linchi_shea/archive/2010/08/11/performance-impact-forget-about-sets-and-focus-on-loops.aspx

Definitely an interesting read. I would have to see examples though to buy that completely. I know this; I'll be watching this discussion from the sidelines with protective gear on. 😛

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 6

CirquedeSQLeil (8/11/2010)
That's a whole nutha topic there.
Pronunciation: \'wu?s-t?(r)-?shir-, -sh?r- also -?shi(-?)r-Function: noun
Etymology: Worcestershire, England, where it was originally made
Date: 1843
: a pungent sauce whose ingredients include soy, vinegar, and garlic
I never thought it to be pungent. I also thought it was pronounced wu?rs-t?(r)-?shir

Nah, if you listen to Bugs Bunny, you can hear the correct pronunciation of Worchester-chester-shire.

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 7

LutzM (8/11/2010)
Steve,
you asked for some improvement ideas for the SSC site: add the option to upload (and play) sound files :-D:-D
Then we could actually hear the pronounciation of all the words 😉
That might even turn SSC into a SQLWiki, where "cursor" might be pronounced like "Don't even think about it!!" :hehe:

That scares me. I wonder what rabbit hole we'll go down with audio.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

David Benoit (8/11/2010)
Steve Jones - Editor (8/11/2010)
Pages and pages of word pronunciations. I can't say I'd have ever thought that would be in here.
One a side note, I thought this was interesting: http://sqlblog.com/blogs/linchi_shea/archive/2010/08/11/performance-impact-forget-about-sets-and-focus-on-loops.aspx
Definitely an interesting read. I would have to see examples though to buy that completely. I know this; I'll be watching this discussion from the sidelines with protective gear on. 😛

Interesting approach by Linchi. I too am interested to see these demonstrations. I do believe there is a time and a place for procedural over set-based in some cases. The point that should be stressed is to make sure that it is used properly.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 9

LutzM (8/11/2010)
Steve,
you asked for some improvement ideas for the SSC site: add the option to upload (and play) sound files :-D:-D
Then we could actually hear the pronounciation of all the words 😉
That might even turn SSC into a SQLWiki, where "cursor" might be pronounced like "Don't even think about it!!" :hehe:

No, bad pronunciation choice - it should be pronounced "curser" because it curses all your hopes of useful performance.

Tom

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

Steve Jones - Editor (8/11/2010)
One a side note, I thought this was interesting: http://sqlblog.com/blogs/linchi_shea/archive/2010/08/11/performance-impact-forget-about-sets-and-focus-on-loops.aspx

Linchi always posts good stuff. He's absolutely right too: all non-parallel query plan iterators process one row at a time in a looping fashion. Where SQLCLR beats T-SQL it's usually down to more efficient loop-based processing. Processing sets adds overhead (memory grant, work tables) and can lead to hidden inefficiencies. The advantages of loops and seeks will become even more obvious when the disparity between sequential and random I/O performance finally disappears (bye bye spinning disks).

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 11

I just have to say:

Us'n Mid-WESTerners ain't got akcents. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 12

I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of a primary key, but I can't find it anywhere. Anybody remember that/know where I could find it?

Found this, which is similar, but not exactly what I remembered.

Thx

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

spaghettidba SSC Guru Points: 105732 More actions · Answer 13

jcrawf02 (8/12/2010)
I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of a primary key, but I can't find it anywhere. Anybody remember that/know where I could find it?
Found this, which is similar, but not exactly what I remembered.
Thx

PK and UNIQUE are the only ways to create and index on a table variable, AFAIK.

What are you trying to do, Jon?

-- Gianluca Sartori

Jack Corbett SSC Guru Points: 184394 More actions · Answer 14

My kids start school today. I can't believe how early school starts in FL. We are starting earlier than most other schools, but still, it is only August 12th. What happened to starting around Labor Day?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 15

Gianluca Sartori (8/12/2010)
jcrawf02 (8/12/2010)
I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of a primary key, but I can't find it anywhere. Anybody remember that/know where I could find it?
Found this, which is similar, but not exactly what I remembered.
Thx
PK and UNIQUE are the only ways to create and index on a table variable, AFAIK.
What are you trying to do, Jon?

Just general knowledge seeking, not specifically trying to do anything with it 🙂

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."