Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 31,426 through 31,440 (of 66,749 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

SQLRNNR (11/4/2011)
SQL Kiwi (11/4/2011)
SQLRNNR (11/4/2011)
Cadavre (11/4/2011)
Brandie Tarvin (11/4/2011)
SQL Kiwi (11/4/2011)
So, it depends
Someone so needs to come up with an interview question where this is the exact answer that's needed.
Isn't that pretty much every interview question relating to SQL Server?
No - i have some very specific questions about query plan operators.
Ask one. I bet I can start an answer with 'it depends'...:cool:
What is the capital of Alaska?
Oh wait, you meant for query plan operators.
What is this query plan operator?

Looks like a tetris block to me.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Paul White SSC Guru Points: 150468 More actions · Answer 2

SQLRNNR (11/4/2011)
What is this query plan operator?

It depends. It could be a hash join, hash aggregate, flow distinct, or a union...

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Paul White SSC Guru Points: 150468 More actions · Answer 3

SQLRNNR (11/4/2011)
SQL Kiwi (11/4/2011)
SQLRNNR (11/4/2011)
Cadavre (11/4/2011)
Brandie Tarvin (11/4/2011)
SQL Kiwi (11/4/2011)
So, it depends
Someone so needs to come up with an interview question where this is the exact answer that's needed.
Isn't that pretty much every interview question relating to SQL Server?
No - i have some very specific questions about query plan operators.
Ask one. I bet I can start an answer with 'it depends'...:cool:
What is the capital of Alaska?

It depends. Most would say Juneau, but this could be a trick/lateral-thinking question, in which case the answer would be 'A'.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

SQL Kiwi (11/4/2011)
SQLRNNR (11/4/2011)
What is this query plan operator?
It depends. It could be a hash join, hash aggregate, flow distinct, or a union...

+1

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

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

Steve Jones - SSC Editor (11/4/2011)
SQLRNNR (11/4/2011)
Oh wait, you meant for query plan operators.
What is this query plan operator?
Alien ship attacking Beijing skyscraper?

Rats, I thought it was Reverse Jenga

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

SQLRNNR (11/4/2011)
What is this query plan operator?

8-bit cactus

- 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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

SQLRNNR (11/4/2011)
SQL Kiwi (11/4/2011)
SQLRNNR (11/4/2011)
What is this query plan operator?
It depends. It could be a hash join, hash aggregate, flow distinct, or a union...
+1

But the physical operator is a hash match which can be used to accomplish all of the above. So I would have gone with hash match. Now had you asked me what it can be used for I would have only known the join part.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Paul White SSC Guru Points: 150468 More actions · Answer 8

Jack Corbett (11/4/2011)
But the physical operator is a hash match which can be used to accomplish all of the above. So I would have gone with hash match. Now had you asked me what it can be used for I would have only known the join part.

Yeah me too (on the physical operator), but I did promise Jason an 'it depends' answer 🙂

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

TomThomson SSC Guru Points: 104773 More actions · Answer 9

SQLRNNR (11/4/2011)
What is the capital of Alaska?
Oh wait, you meant for query plan operators.
What is this query plan operator?

It depends....

....on whether I'm allowed to call a slightly dishonest DBA a query plan operator.

Looks like a DBA tring to cheat at Towers of Hanoi. I guess that makes him a bit of an operator, and he deals with query plans (when not cheating at simple games) so he's a query plan operator.

Tom

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

L' Eomot Inversé (11/4/2011)
SQLRNNR (11/4/2011)
What is the capital of Alaska?
Oh wait, you meant for query plan operators.
What is this query plan operator?
It depends....
....on whether I'm allowed to call a slightly dishonest DBA a query plan operator.
Looks like a DBA tring to cheat at Towers of Hanoi. I guess that makes him a bit of an operator, and he deals with query plans (when not cheating at simple games) so he's a query plan operator.

sweet - but is it cheating if you didn't catch me?

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

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 11

SQLRNNR (11/4/2011)
sweet - but is it cheating if you didn't catch me?

I think he just did :w00t:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Steve Jones - SSC Editor (11/4/2011)
SQLRNNR (11/4/2011)
sweet - but is it cheating if you didn't catch me?
I think he just did :w00t:

No, it's just an illusion:crazy:

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

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 13

Jack Corbett (10/1/2011)
Hey guys I got some really cool news today. I was awarded MVP status!

Congratulations Jack! I am very happy to see your award. Just keep on helping the community as you have been.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 14

GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!
2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
http://www.sqlservercentral.com/articles/books/76296/

I can't think of a better tech editor than you Gail; with all of that practice telling us that we are wrong! <g>

Do you get any cash from the sales? I want to buy a bunch of copies for employees and also presentation give aways.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph

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

Jim Murphy (11/4/2011)

Do you get any cash from the sales? [/QUOTe]

No

I want to buy a bunch of copies for employees and also presentation give aways.

Please do. It's an excellent resource for troubleshooting (and if you read the forward, I'm not the only one that thinks that) 😀

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