Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 24,031 through 24,045 (of 66,749 total)

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

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 1

GSquared (2/16/2011)

Fal (2/16/2011)

Koen Verbeeck (2/15/2011)
Fal (2/15/2011)
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.
Well, at great risk of embarrassing myself in front of some big names with my initial post on this thread, this is what I've got:
...
I knew I should've lurked longer. But no, I had to help someone! 😛
Steve.
I blame Wayne. Execution at noon.

What's the process for a SQL Server Central execution? Do you highlight him and press F5?

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

GSquared (2/16/2011)
I blame Wayne. Execution at noon.

Who's noon?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

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

Jeff Moden (2/16/2011)
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.
I've got a new splitter I've been working on for the revision of the Tally Table article. It absolutely screams on 8k even compared to the old DelimitedSplit8K. Since it's bad mojo to post code on the thread, I'll send it to you tonight... I could use a little help testing it. 😛

Jeff - I would be interested in testing it as well if possible.

David

@SQLTentmaker

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

GSquared SSC Guru Points: 260824 More actions · Answer 4

GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.
Who's noon?

No, Who's on first.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

WayneS SSC Guru Points: 95461 More actions · Answer 5

Jeff Moden (2/16/2011)
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.
I've got a new splitter I've been working on for the revision of the Tally Table article. It absolutely screams on 8k even compared to the old DelimitedSplit8K. Since it's bad mojo to post code on the thread, I'll send it to you tonight... I could use a little help testing it. 😛

Thanks! Looking forward to seeing this.

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

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

GSquared (2/16/2011)
GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.
Who's noon?
No, Who's on first.

I don't know!

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

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 7

Jack Corbett (2/16/2011)
GSquared (2/16/2011)
GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.
Who's noon?
No, Who's on first.
I don't know!

Third base!

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.

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

Just to clarify, there is nothing wrong with tech talk around the water cooler as long as it is kept quite short.

If you start going into details, that's when it needs to move to a separate thread.

Jan Van der Eecken SSCrazy Eights Points: 9029 More actions · Answer 9

GSquared (2/16/2011)
GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.
Who's noon?
No, Who's on first.

Not me, got K-ed out again last Saturday :w00t:

--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Lynn Pettis (2/13/2011)
I said I'd stay out of MasterBlasters thread, and I will. What he doesn't seem to get is that there was a better way to respond to Gus's comment without getting personal, which is what I took offense to and call insulting.
All he had to do was say something like this: That's three possibilities, but couldn't this, that, or another thing have also been a possibilty?
That would have been much better and without any personal attack.
Just a thought if someone else would like to see how he'd take that type of constructive critisism.

Just got around to reading that thread and it really went sideways. It started off fine - but isn't worth the reading after the first few posts.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

WayneS (2/13/2011)
Are any Threadizens going to SQL Saturday #69 (Philadelphia) on March 5? I just read the email where my presentation has been selected to be presented! :w00t::w00t::w00t:
I'd love to meet any of you'll that are there!

Congrats - not sure I can make it

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.
Who's noon?

Everybody's. We get to have multiple executions for this infraction.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

For the execution of Wayne:

--get spid of code requestor

sp_whorequestedcodeIntheThread 'Wayne'

--use returned spids to verify the request

dbcc inputbuffer(61)

--output

'Wayne definitely requested code on the thread'

--yup that's the one

Kill 'Wayne'

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

Fal Hall of Fame Points: 3143 More actions · Answer 14

Brandie Tarvin (2/16/2011)
... But I'd avoid dark alleys, if I were you....

Well, there goes the joy in life.

But wait, you mentioned something about "tar and feathers"??

Steve.

Jeff Moden SSC Guru Points: 1004441 More actions · Answer 15

CirquedeSQLeil (2/16/2011)
For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the one
Kill 'Wayne'

just one bad underscore in the name of that sp could change its meaning entirely. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)