Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 3,736 through 3,750 (of 66,000 total)

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

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 1

Grant Fritchey (4/28/2009)

You can get two plans into the cache through parallelism. I've done it and seen it.

Mind sharing the secret? Nothing I've tried gets me both a serial and a parallel plan in cache at the same time. Unless I'l looking in the wrong places.

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

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

Lynn Pettis (4/28/2009)

The desert is looking good again...

I might join you this time. For some reason some of the posts over the last few days have been getting to me, they shouldn't and I don't know why they are.

p.s. did you ever get a chance to work through my article? Not nagging, just curious.

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

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 3

I did it in the execution plan book. Let me look it up...

Damn, found a typo. I'm blaming you becuase I wouldn't have seen it otherwise...

Crap... Evidently I just lied... I know I've seen it before. Now I have to figure it out again. Crud.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 4

Hmmm... Now I am confused. I remember seeing that in action, but when you run RECONFIGURE WITH OVERRIDE the cache gets cleaned out, so I couldn't have done it playing with the paralelism cost threshold...

Back in a bit.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 5

Grant Fritchey (4/28/2009)

Hmmm... Now I am confused.

You and me both. I started writing a blog post on this, explaining that there could be serial and parallel plans in cache. It was going to be one of my series on exec plans. When I couldn't get SQL to behave the way I wanted, after a fair bit of trying, I deleted the half-done post.

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: 442447 More actions · Answer 6

GilaMonster (4/28/2009)

Lynn Pettis (4/28/2009)

The desert is looking good again...

I might join you this time. For some reason some of the posts over the last few days have been getting to me, they shouldn't and I don't know why.

p.s. did you ever get a chance to work through my article? Not nagging, just curious.

I got part way through it and the life outside of SQL took over this weekend. Lots of soccer followed by an unrelated to soccer migraine on Sunday. Pretty sure the migraine was due to lack of food and caffeine. Didn't drink much of my soda and lunch and dinner have been minuscule these past few days.

I have another game tonight, but I should be able to finish up by Friday.

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 7

GilaMonster (4/28/2009)

Grant Fritchey (4/28/2009)

Hmmm... Now I am confused.

You and me both. I started writing a blog post on this, explaining that there could be serial and parallel plans in cache. It was going to be one of my series on exec plans. When I couldn't get SQL to behave the way I wanted, after a fair bit of trying, I deleted the half-done post.

I re-checked the documentation. It says there are two plans, one for parallel and one for not. I just can't get it to create both without forcing a parallel query, but when you force one... you've just removed the ability to have an unforced one. Frustrating.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

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

Lynn Pettis

SSC Guru

Points: 442447

April 28, 2009 at 1:54 pm

#985454

You know, I guess it is really hard to teach someone fish when you are in the middle of the desert...

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 9

Lynn Pettis (4/28/2009)

I have another game tonight, but I should be able to finish up by Friday.

No real urgency.

Thanks

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

The Dixie Flatline SSC Guru Points: 53353 More actions · Answer 10

You know, I guess it is really hard to teach someone fish when you are in the middle of the desert...

Somewhere that man is getting well paid for the use of your fishing gear, Lynn. 😉

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 11

Bob Hovious (4/28/2009)

You know, I guess it is really hard to teach someone fish when you are in the middle of the desert...

Somewhere that man is getting well paid for the use of your fishing gear, Lynn. 😉

But, I haven't given him the fish yet, and I actually don't plan on it. I simply refuse to give him the answer to his own logic error. I've pointed him in the direction, if he can't find the fish, he starves.

You could say I have given him 3 lb test fishing line when he needs 10 lb test...

GSquared SSC Guru Points: 260824 More actions · Answer 12

Lynn Pettis (4/28/2009)

Bob Hovious (4/28/2009)

You know, I guess it is really hard to teach someone fish when you are in the middle of the desert...

Somewhere that man is getting well paid for the use of your fishing gear, Lynn. 😉

But, I haven't given him the fish yet, and I actually don't plan on it. I simply refuse to give him the answer to his own logic error. I've pointed him in the direction, if he can't find the fish, he starves.

You could say I have given him 3 lb test fishing line when he needs 10 lb test...

I think it's a broken analogy in this case. You're handing the guy a fishing pole and some line and a hook and all that, and he's trying to use it to shoot deer. Out in the woods, catching the line on surrounding trees and bushes, and thinking, "If I can just learn to cast correctly, I'll be able to hook one of these deer one of these days".

My current inclination on this guy is more to demonstrate the difference between "giving a man a fish" and "throwing fish at someone".

- 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

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 13

GSquared (4/28/2009)

Lynn Pettis (4/28/2009)

Bob Hovious (4/28/2009)

You know, I guess it is really hard to teach someone fish when you are in the middle of the desert...

Somewhere that man is getting well paid for the use of your fishing gear, Lynn. 😉

But, I haven't given him the fish yet, and I actually don't plan on it. I simply refuse to give him the answer to his own logic error. I've pointed him in the direction, if he can't find the fish, he starves.

You could say I have given him 3 lb test fishing line when he needs 10 lb test...

I think it's a broken analogy in this case. You're handing the guy a fishing pole and some line and a hook and all that, and he's trying to use it to shoot deer. Out in the woods, catching the line on surrounding trees and bushes, and thinking, "If I can just learn to cast correctly, I'll be able to hook one of these deer one of these days".