I want back my Points

Question

I want back my Points

Viewing 7 posts - 16 through 21 (of 21 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Thom A - Thursday, April 6, 2017 8:11 AM
Jeff Moden - Thursday, April 6, 2017 8:04 AM
right after the one about how to get the current date and time. 😉
Out of interest, how many people fail that one? I feel like I'm going to be... Unpleasantly unsurprised?

In interviews I have conducted involving that question, 8 of 10 failed that one. These were "senior dbas" with 10+ years experience.

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: 281334 More actions · Answer 2

I want my points back. This was ridiculously unfair.

:Whistling:😀😀

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

Jeff Moden SSC Guru Points: 1003867 More actions · Answer 3

SQLRNNR - Thursday, April 6, 2017 10:15 AM
Thom A - Thursday, April 6, 2017 8:11 AM
Jeff Moden - Thursday, April 6, 2017 8:04 AM
right after the one about how to get the current date and time. 😉
Out of interest, how many people fail that one? I feel like I'm going to be... Unpleasantly unsurprised?
In interviews I have conducted involving that question, 8 of 10 failed that one. These were "senior dbas" with 10+ years experience.

Same here and same level. I'll also state that (before I quit counting) 20 out of 22 front end candidates that required "some knowledge of T-SQL" didn't have a clue. And, no... this isn't a new phenomena... this has been going on for a decade of interviews. Really, really sad state for the community at large here in SE Michigan. As I've said in many previous posts, I originally started asking the question because it was a ridiculously simple question that I thought would help break the ice and set candidates at ease a little bit. I had no idea that it would become a defining litmus-strip test of how the rest of the interview was going to go.

Shifting gears and if you want to have some fun on an interview when asked the "Manhole Cover" question, rattle off all the answers and then ask the interviewer "Which shape also has a consistent diameter but is not round and why would you use it as a manhole cover"? Eat your heart out, Google Interviewers. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 4

Taken,easy one for me ...thank you.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

nscheaffer SSC Enthusiast Points: 133 More actions · Answer 5

I have been working with SQL Server for a long time, but I don't fully understand the syntax of this statement; particularly the "AS V([Points])" portion. I would like to understand it more fully, but I don't even know what term or technique to search.

Thanks,

Noel

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 6

nscheaffer - Wednesday, June 7, 2017 2:01 PM
I have been working with SQL Server for a long time, but I don't fully understand the syntax of this statement; particularly the "AS V([Points])" portion. I would like to understand it more fully, but I don't even know what term or technique to search.
Thanks,
Noel

It's the alias and column name for the table value constructor.

The values in the constructor are treated as a sort of derived table with the name V, and a single column, Points. It has 5 rows with the values listed.

Check out https://docs.microsoft.com/en-us/sql/t-sql/queries/table-value-constructor-transact-sql and https://www.simple-talk.com/sql/sql-training/table-value-constructors-in-sql-server-2008/ for a bit more info.

Cheers!

Carlo Romagnano SSC-Insane Points: 22601 More actions · Answer 7

nscheaffer - Wednesday, June 7, 2017 2:01 PM
I have been working with SQL Server for a long time, but I don't fully understand the syntax of this statement; particularly the "AS V([Points])" portion. I would like to understand it more fully, but I don't even know what term or technique to search.
Thanks,
Noel

Simply, 'V' is the alias for the table and between parenthesis [Points] is the alias name for the column. Search for the syntax of FROM and VALUES