February 18, 2010 at 10:49 am
Signal : noise is getting worse in some ways. More people trying to be MVP or show off, so there's more participation.
Just like with anything, as more people participate, the chances of lower knowledge/bad advice increase. Not sure what to do other than just correct what you can, include references, and hopefully increase the signal portion.
February 18, 2010 at 10:55 am
Steve Jones - Editor (2/18/2010)
Signal : noise is getting worse in some ways. More people trying to be MVP or show off, so there's more participation.
Sorry, I'll cut back. 😉
I hope people don't really think they can do it that way alone. Is this typical behavior this time of year (after MVP nominations open up)?
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
February 18, 2010 at 11:00 am
Steve Jones - Editor (2/18/2010)
More people trying to be MVP or show off, so there's more participation.
That was my impression as well. Everyone thinks they're an ex-spurt
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
February 18, 2010 at 11:01 am
CirquedeSQLeil (2/18/2010)
Is this typical behavior this time of year (after MVP nominations open up)?
???
MVP nominations are open all year round, awards given every 3 months.
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
February 18, 2010 at 11:02 am
jcrawf02 (2/18/2010)
Gianluca Sartori (2/18/2010)
GilaMonster (2/18/2010)
Gianluca Sartori (2/18/2010)
In that particular case, with the identity column as primary key clustered, yes, doesn't it?Logical order of the index - yes
Physical order of the data - no
Order that the rows will be returned in - no.
Ok, it's not guaranteed and I would not rely on it, but honestly I have to say I've never seen it behaving differently.
I've been spending some time trying to make it return rows in a different order, but I did not succeed. Does anybody have a script to do that? It would be interesting to see.
It's like the Yeti, just because you've never seen it doesn't mean it doesn't exist. 😛
Found an example of an easy way to break this, check out this thread, bogus (negative) identity values throws this off.
---------------------------------------------------------
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."
February 18, 2010 at 11:03 am
GilaMonster (2/18/2010)
CirquedeSQLeil (2/18/2010)
Is this typical behavior this time of year (after MVP nominations open up)????
MVP nominations are open all year round, awards given every 3 months.
See what I know about it? I thought it was an annual deal and nominations were open only for a short period.
Thanks for that info.
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
February 18, 2010 at 11:06 am
GilaMonster (2/18/2010)
Steve Jones - Editor (2/18/2010)
More people trying to be MVP or show off, so there's more participation.That was my impression as well. Everyone thinks they're an ex-spurt
Is the noise in reference to the "Emergency!!!" / "suspect" thread?
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
February 18, 2010 at 11:06 am
The award is annual, but they award 4 times a year. So if you are awarded in April, you are an MVP until next April, when you get renewed or dropped. Nominations occur all the time.
It's not bad that more people are trying to be awarded. I think it could be good for the community with more people speaking or trying to help others. It's that along with all those that are qualified, and there are lots that are and haven't been awarded, there are those that aren't qualified participating as well and adding to the noise level.
February 18, 2010 at 11:12 am
CirquedeSQLeil (2/18/2010)
GilaMonster (2/18/2010)
Steve Jones - Editor (2/18/2010)
More people trying to be MVP or show off, so there's more participation.That was my impression as well. Everyone thinks they're an ex-spurt
Is the noise in reference to the "Emergency!!!" / "suspect" thread?
Mostly, but not solely.
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
February 18, 2010 at 11:17 am
CirquedeSQLeil (2/18/2010)
See what I know about it? I thought it was an annual deal and nominations were open only for a short period.
It is an annual deal. If I were to nominate someone now, they would be evaluated for potential award in April. If I were to nominate someone at the end of March, they would be evaluated for potential award in July.
I was awarded in July (Steve's in the Jan cycle, Grant in the April. Don't know anyone here in the Oct), so come June my contributions for the previous 12 months go under the spolight and beginning of July I either get reawarded or dropped.
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
February 18, 2010 at 11:18 am
As I thought.
When I cause noise - I appreciate the corrections.
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
February 18, 2010 at 11:22 am
GilaMonster (2/18/2010)
CirquedeSQLeil (2/18/2010)
See what I know about it? I thought it was an annual deal and nominations were open only for a short period.It is an annual deal. If I were to nominate someone now, they would be evaluated for potential award in April. If I were to nominate someone at the end of March, they would be evaluated for potential award in July.
I was awarded in July (Steve's in the Jan cycle, Grant in the April. Don't know anyone here in the Oct), so come June my contributions for the previous 12 months go under the spolight and beginning of July I either get reawarded or dropped.
As a part of the evaluation, do you submit your own supporting documentation or does MS go and find it? Just curious how much input the nominee has in the award during the eval/re-eval process.
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
February 18, 2010 at 11:23 am
And when I cause noise you can slap me on the head... :hehe:
About the MVP topic, only MVPs can nominate someone...Right?
-Roy
February 18, 2010 at 11:24 am
GilaMonster (2/18/2010)
CirquedeSQLeil (2/18/2010)
See what I know about it? I thought it was an annual deal and nominations were open only for a short period.It is an annual deal. If I were to nominate someone now, they would be evaluated for potential award in April. If I were to nominate someone at the end of March, they would be evaluated for potential award in July.
I was awarded in July (Steve's in the Jan cycle, Grant in the April. Don't know anyone here in the Oct), so come June my contributions for the previous 12 months go under the spolight and beginning of July I either get reawarded or dropped.
Actually I already got notice that my stuff was under review. I won't find out if I've done enough to qualify again for six more weeks. Based on that though, I won't ever publish a book or attend a major conference between February & April or it won't hit the review period. Weird stuff.
"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
February 18, 2010 at 11:24 am
CirquedeSQLeil (2/18/2010)
As I thought.When I cause noise - I appreciate the corrections.
+1 there. If I am wrong or don't understand something correction is greatly appreciated. Only way I know to improve my knowledge.
Viewing 15 posts - 11,761 through 11,775 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply