Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 29,971 through 29,985 (of 66,819 total)

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

TomThomson SSC Guru Points: 104768 More actions · Answer 1

The responses to this question struck me as being carelessly wrong, so I jumped in with a contradictory response. Could domeone with a really good understanding of the interaction between indexes and locking have a look and join the discussion, please?

fix typos (finger on two keys at once).

edit again - fix accidentally deleted characters

Tom

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Tom.Thomson (9/17/2011)
The responses to [http://www.sqlservercentral.com/Forums/Topic1176445-1550-1.aspx?Update=1]this question[/url] struck me as being carelessly wrong, so I jumped in with a contradictory response. Could domeone with a really good understanding of the interaction between indexes and locking have a look and join the discussion, please?
fix typos (finger on two keys at once).

I don't think he's clearly wrong. He actually made an excellent point. We all assumed that both indexes would have a high beneficial impact on the db but, really how did we all come to that conclusion?

We don't know how big's the table, how large are the columns and how often they are each DMLed, what queries, if any, will go faster and by how much.

He also says that like most of us he'd go for #2, but that it's not an automatic call.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

Tom.Thomson (9/17/2011)
Could domeone with a really good understanding of the interaction between indexes and locking have a look and join the discussion, please?

I already did, but seeing as I'm one of those being 'carelessly wrong' feel free to ignore it.

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

TomThomson SSC Guru Points: 104768 More actions · Answer 4

GilaMonster (9/17/2011)
Tom.Thomson (9/17/2011)
Could domeone with a really good understanding of the interaction between indexes and locking have a look and join the discussion, please?
I already did, but seeing as I'm one of those being 'carelessly wrong' feel free to ignore it.

I don't ignore things you write, Gail. I read them carefully and quite often adjust my own ideas to fit yours better, as yours are quite often the better ones.

Tom

WayneS SSC Guru Points: 95461 More actions · Answer 5

Tom.Thomson (9/17/2011)
The responses to [http://www.sqlservercentral.com/Forums/Topic1176445-1550-1.aspx?Update=1]this question[/url] struck me as being carelessly wrong, so I jumped in with a contradictory response. Could domeone with a really good understanding of the interaction between indexes and locking have a look and join the discussion, please?
fix typos (finger on two keys at once).

Hey Tom, I see that you've got your #sqllearning hat on pretty early today (well, early for me!), and Gail is doing some awesome teaching there (and not just for you, but for all of us).

On a side note, it looks like you were trying to make the above a hyperlink. You need to start it off with [ url=] (without the space), like this (quote this message to see): this question

(Edit: 24 posts to go to reach 30,000 :w00t::w00t:)

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

TomThomson SSC Guru Points: 104768 More actions · Answer 6

WayneS (9/17/2011)
On a side note, it looks like you were trying to make the above a hyperlink. You need to start it off with [ url=] (without the space), like this (quote this message to see): this question

Who stole my "url="? Where did it go to? I've put another one in there now, but if people keep on stealing them I may use so many that we end up with a world shortage of "url="s, and that surely would not be a good thing.

(Edit: 24 posts to go to reach 30,000 :w00t::w00t:)

23 now

Tom

SQLRNNR SSC Guru Points: 281344 More actions · Answer 7

Random plug of the day[/url].

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: 281344 More actions · Answer 8

Oh and 21 now

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

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

And down to 20. This will become an ugly contest 😀

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

WayneS SSC Guru Points: 95461 More actions · Answer 10

Steve Jones - SSC Editor (9/15/2011)
Please let's not have quotes of every post that counts down from 95, 94, 93.
I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:

Jan Van der Eecken (9/17/2011)
And down to 20. This will become an ugly contest 😀

So, we're ignoring Steve (again)? (and this makes 19...)

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 11

WayneS (9/17/2011)
Steve Jones - SSC Editor (9/15/2011)
Please let's not have quotes of every post that counts down from 95, 94, 93.
I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:
Jan Van der Eecken (9/17/2011)
And down to 20. This will become an ugly contest 😀
So, we're ignoring Steve (again)? (and this makes 19...)

Apparently so.

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

TomThomson SSC Guru Points: 104768 More actions · Answer 12

GilaMonster (9/17/2011)
WayneS (9/17/2011)
Steve Jones - SSC Editor (9/15/2011)
Please let's not have quotes of every post that counts down from 95, 94, 93.
I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:
Jan Van der Eecken (9/17/2011)
And down to 20. This will become an ugly contest 😀
So, we're ignoring Steve (again)? (and this makes 19...)
Apparently so.

Well you aren't - you didn't include the number remaining in your comment.

And neither am I - I haven't said the number one less thanm the one you didn't say.

Tom

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

Tom.Thomson (9/17/2011)
GilaMonster (9/17/2011)
WayneS (9/17/2011)
Steve Jones - SSC Editor (9/15/2011)
Please let's not have quotes of every post that counts down from 95, 94, 93.
I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:
Jan Van der Eecken (9/17/2011)
And down to 20. This will become an ugly contest 😀
So, we're ignoring Steve (again)? (and this makes 19...)
Apparently so.
Well you aren't - you didn't include the number remaining in your comment.
And neither am I - I haven't said the number one less thanm the one you didn't say.

I'm keeping to to the word of Steve's request and breaking the spirit of the request. 😀

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 14

GilaMonster (9/17/2011)
Tom.Thomson (9/17/2011)
GilaMonster (9/17/2011)
WayneS (9/17/2011)
Steve Jones - SSC Editor (9/15/2011)
Please let's not have quotes of every post that counts down from 95, 94, 93.
I'm going out of town for a few days. I'm hoping that I don't have 300 posts in this thread when I get back :w00t:
Jan Van der Eecken (9/17/2011)
And down to 20. This will become an ugly contest 😀
So, we're ignoring Steve (again)? (and this makes 19...)
Apparently so.
Well you aren't - you didn't include the number remaining in your comment.
And neither am I - I haven't said the number one less thanm the one you didn't say.
I'm keeping to to the word of Steve's request and breaking the spirit of the request. 😀

The request? I thought we were just hoping to break Steve's spirit in general.

CRAP, I've been doing it wrong again!;-)

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 15

Evil Kraig F (9/17/2011)
The request? I thought we were just hoping to break Steve's spirit in general.
CRAP, I've been doing it wrong again!;-)

Knowing Steve, it'll take far more than a few hundred forum notifications for that. Sanity, now that may be a different matter

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