Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 37,831 through 37,845 (of 66,712 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

Stefan Krzywicki (9/14/2012)
GSquared (9/14/2012)
Stefan Krzywicki (9/14/2012)
Brandie Tarvin (9/14/2012)
Stefan Krzywicki (9/14/2012)
GilaMonster (9/14/2012)
Anyone get the increasing feeling people are looking for the 'eazy button'?
Case in point:
"I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"
Pff, a formula for that is easy!
Column A should always go first in an index, possibly followed by B and C, etc...
The number of columns in your index < the number of columns in your table
Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.
🙂
You're doing it wrong.
DBCC Timewarp (# of columns / (pi * # of tables) + 8 )
The 8 is there because everyone knows there are 8 KB per page.
I always thinks DBCC Timewarp is secret and I shouldn't be spreading it around on the forums.
Nah. It's secret now, but since it won't be secret when the year 1900 roles around again, it's okay to post details. In the past-future-imperfect tense, of course.
Excellent, so from then on I will be about to have been going to done so.

Exactly.

- 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

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

Anyone know how to do this?

Search time type between PM and AM

I can't quite figure out a good way to google it or there's just nothing out there on it.

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

GSquared SSC Guru Points: 260824 More actions · Answer 3

Stefan Krzywicki (9/14/2012)
Anyone know how to do this?
Search time type between PM and AM
I can't quite figure out a good way to google it or there's just nothing out there on it.

Answered.

- 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

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

GSquared (9/14/2012)
Stefan Krzywicki (9/14/2012)
Anyone know how to do this?
Search time type between PM and AM
I can't quite figure out a good way to google it or there's just nothing out there on it.
Answered.

Thanks, and slightly different from how you handle it as integers.

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

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

How's the refusing to be baited by Celko thing going, Lynn?

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

SQL Kiwi (9/14/2012)
How's the refusing to be baited by Celko thing going, Lynn?

I had to give in. It hurt too much.

Hey, any comments on what is posted here?

Just curious.

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

Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?

My first reaction was, "LOL!". Posted a more serious comment.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?
My first reaction was, "LOL!". Posted a more serious comment.

Thank you, you saved me the trouble.

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

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

SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?
My first reaction was, "LOL!". Posted a more serious comment.

Remembering that this discussion had occurred before, but not remembering exactly when or where, I really thought it best to defer to others to refute the statement. At least I know I was correct in my own assumptions on this item.

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

GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?
My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved me the trouble.

No worries - I got a good laugh out of it.

I do love it when someone rocks up on a thread and says, "Er, you do realize that [misconception] don't you?"

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

My new career: http://www.geekologie.com/2012/09/now-run-them-through-with-a-katana-londo.php

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

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 12

jcrawf02 (9/14/2012)
My new career: http://www.geekologie.com/2012/09/now-run-them-through-with-a-katana-londo.php

Where do I go to volunteer?

"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

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

SQL Kiwi (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?
My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved me the trouble.
No worries - I got a good laugh out of it.
I do love it when someone rocks up on a thread and says, "Er, you do realize that [misconception] don't you?"

Yup. Very much so.

I must add that one to the list of query execution/optimisation related misconceptions I want to write about sometime.

The person in question there has got a little aggressive about defending his position before (at least to me). Not 'non-updating update' bad, but still more forceful than I would like.

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

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

GilaMonster (9/14/2012)
Not 'non-updating update' bad, but still more forceful than I would like.

Oh don't remind me! Ha ha ha.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?
My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved me the trouble.
No worries - I got a good laugh out of it.
I do love it when someone rocks up on a thread and says, "Er, you do realize that [misconception] don't you?"
Yup. Very much so.
I must add that one to the list of query execution/optimisation related misconceptions I want to write about sometime.
The person in question there has got a little aggressive about defending his position before (at least to me). Not 'non-updating update' bad, but still more forceful than I would like.

Same with me on a totally different topic recently too.

_______________________________________________________________

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/