Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 43,051 through 43,065 (of 66,712 total)

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

Revenant SSC-Forever Points: 42467 More actions · Answer 1

SQLRNNR (2/20/2014)
Revenant (2/20/2014)
The Dixie Flatline (2/20/2014)
GilaMonster (2/20/2014)
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
After over 40 000 posts, I don't think it has a topic any longer.
I think that's one of the worst questions ever posted...
By definition: ANYTHING that is not about SQL. Covers ayahuasca technologies of Amazon shamans as well as the newest technologies of covering pistons with synthetic diamonds or the breakthrough research on sea cucumbers physiology or the so-far unparalleled quality of Matsumune blades. Make your pick. And I did not include Leonardo's sfumato as a topic - yet. 🙂
Don't forget hippos in pink tutus guarding the TOTD.

Sorry for that omission, Jason, it gets you an extra drink.

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 2

I have visitors in my ear.

Or is that just Jason again? 😀

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Greg Edwards-268690 (2/20/2014)
I have visitors in my ear.
Or is that just Jason again? 😀

Definitely me:-D:-D

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

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 4

SQLRNNR (2/20/2014)
Greg Edwards-268690 (2/20/2014)
I have visitors in my ear.
Or is that just Jason again? 😀
Definitely me:-D:-D

And it's snowing like crazy here again.

Starts out with 3-6". done before midnight.

Now they say 8-12", done by noon tomorrow.

The chanting is getting louder all the time.

Hopefully an hour or so with the snow blower will clear my head.

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 5

SQLRNNR (2/20/2014)
Revenant (2/20/2014)
The Dixie Flatline (2/20/2014)
GilaMonster (2/20/2014)
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
After over 40 000 posts, I don't think it has a topic any longer.
I think that's one of the worst questions ever posted...
By definition: ANYTHING that is not about SQL. Covers ayahuasca technologies of Amazon shamans as well as the newest technologies of covering pistons with synthetic diamonds or the breakthrough research on sea cucumbers physiology or the so-far unparalleled quality of Matsumune blades. Make your pick. And I did not include Leonardo's sfumato as a topic - yet. 🙂
Don't forget hippos in pink tutus guarding the TOTD.

And potato guns - don't forget potato guns!

Jason Wolfkill

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

SQLRNNR (2/20/2014)
ChrisM@Work (2/20/2014)
SQLRNNR (2/20/2014)
Sean Lange (2/20/2014)
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
What topic is that???
SQUIRREL
NUTS! WHOLE HAZELNUTS!! Careful, this could go downhill very quickly...
You still work in that lingerie factory?

Sadly knot. Bustin' to go back.

^{“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

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

GilaMonster (2/20/2014)
PSA: Yes, my blogs (and email, etc) is down, I have noticed (no email for almost a week is a good hint). Yes, it is being looked into. ETA for site being up is time T where T > Current_TimeStamp. Complaints will be filed in file cabinet 13. I will fire the webmaster on Monday.

The black filing cabinet?

^{“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: 15915 More actions · Answer 8

ChrisM@Work (2/21/2014)
SQLRNNR (2/20/2014)
ChrisM@Work (2/20/2014)
SQLRNNR (2/20/2014)
Sean Lange (2/20/2014)
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
What topic is that???
SQUIRREL
NUTS! WHOLE HAZELNUTS!! Careful, this could go downhill very quickly...
You still work in that lingerie factory?
Sadly knot. Bustin' to go back.

Chris and after talking to you and Richard I too wish to work there! If only for the tannoy messages 😀

Rodders...

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

wolfkillj (2/20/2014)
SQLRNNR (2/20/2014)
Revenant (2/20/2014)
The Dixie Flatline (2/20/2014)
GilaMonster (2/20/2014)
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
After over 40 000 posts, I don't think it has a topic any longer.
I think that's one of the worst questions ever posted...
By definition: ANYTHING that is not about SQL. Covers ayahuasca technologies of Amazon shamans as well as the newest technologies of covering pistons with synthetic diamonds or the breakthrough research on sea cucumbers physiology or the so-far unparalleled quality of Matsumune blades. Make your pick. And I did not include Leonardo's sfumato as a topic - yet. 🙂
Don't forget hippos in pink tutus guarding the TOTD.
And potato guns - don't forget potato guns!

And one of the most important semi-related topics: the high velocity pork chop launcher.

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

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

rodjkidd (2/21/2014)
ChrisM@Work (2/21/2014)
SQLRNNR (2/20/2014)
ChrisM@Work (2/20/2014)
SQLRNNR (2/20/2014)
Sean Lange (2/20/2014)
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
What topic is that???
SQUIRREL
NUTS! WHOLE HAZELNUTS!! Careful, this could go downhill very quickly...
You still work in that lingerie factory?
Sadly knot. Bustin' to go back.
Chris and after talking to you and Richard I too wish to work there! If only for the tannoy messages 😀
Rodders...

"32H to fitting please" ... and all the guys in IT do their best meerkat impression!

^{“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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

ChrisM@Work (2/21/2014)
rodjkidd (2/21/2014)
ChrisM@Work (2/21/2014)
SQLRNNR (2/20/2014)
ChrisM@Work (2/20/2014)
SQLRNNR (2/20/2014)
Sean Lange (2/20/2014)
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
What topic is that???
SQUIRREL
NUTS! WHOLE HAZELNUTS!! Careful, this could go downhill very quickly...
You still work in that lingerie factory?
Sadly knot. Bustin' to go back.
Chris and after talking to you and Richard I too wish to work there! If only for the tannoy messages 😀
Rodders...
"32H to fitting please" ... and all the guys in IT do their best meerkat impression!

Yeah I bet.

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

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

ChrisM@Work (2/21/2014)
GilaMonster (2/20/2014)
PSA: Yes, my blogs (and email, etc) is down, I have noticed (no email for almost a week is a good hint). Yes, it is being looked into. ETA for site being up is time T where T > Current_TimeStamp. Complaints will be filed in file cabinet 13. I will fire the webmaster on Monday.
The black filing cabinet?

The dustbin

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

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

GilaMonster (2/21/2014)
ChrisM@Work (2/21/2014)
GilaMonster (2/20/2014)
PSA: Yes, my blogs (and email, etc) is down, I have noticed (no email for almost a week is a good hint). Yes, it is being looked into. ETA for site being up is time T where T > Current_TimeStamp. Complaints will be filed in file cabinet 13. I will fire the webmaster on Monday.
The black filing cabinet?
The dustbin

That would be the cat.

^{“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

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

Jeff (and all you guys who helped test the delimited split 8k) are solving problems you don't even know about. Found this in my inbox today from a former colleague:

I actually got it to work. Here’s how:
The problem was with how the parameter was being passed into the stored procedure. The sp can’t read the all values as separate and distinct values, it’s read as one which is why when the character length was set to 15 it could read the first value only programid in the program table is 15 characters) but when I was set to 200 it interpreted it as one value. To fix add this to the beginning of the main query:
Select Item
Into #LOBList
From dbo.fDelimitedSplit8K(@rpLOB,',')
and instead of adding the parameter to the where clause create a join like this:
join #LOBList LOB on p.programid = LOB.Item
Everything ing in SSRS was correct already. It appears to work now. Let me know if you have any questions.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

jcrawf02 (2/21/2014)
Jeff (and all you guys who helped test the delimited split 8k) are solving problems you don't even know about. Found this in my inbox today from a former colleague:
I actually got it to work. Here’s how:
The problem was with how the parameter was being passed into the stored procedure. The sp can’t read the all values as separate and distinct values, it’s read as one which is why when the character length was set to 15 it could read the first value only programid in the program table is 15 characters) but when I was set to 200 it interpreted it as one value. To fix add this to the beginning of the main query:
Select Item
Into #LOBList
From dbo.fDelimitedSplit8K(@rpLOB,',')
and instead of adding the parameter to the where clause create a join like this:
join #LOBList LOB on p.programid = LOB.Item
Everything ing in SSRS was correct already. It appears to work now. Let me know if you have any questions.

Very cool

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