Classifier Functions

Question

Post reply

Classifier Functions

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
January 7, 2012 at 5:29 pm

#265913

Comments posted to this topic are about the item Classifier Functions

Viewing 15 posts - 1 through 15 (of 18 total)

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

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 1

"the 'local_net_address' parameter is used to get the IP address of the client."

Yet from books online:

"Returns the IP address on the server that this connection targeted. Available only for connections that are using the TCP transport provider."

In other words, it returns the SERVER IP address, NOT the client IP address, which is returned by the option from the fourth option. Steve, I think you copied and pasted wrong.

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

Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! Or so I thought, perhaps I misinterpreted "IP address of the incoming connection" - I took it to be asking for the client's IP address rather than whichever of several server IP address was connected to. Ah well, perhaps tomorrow.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

TomThomson SSC Guru Points: 104773 More actions · Answer 3

Good question, but I don't like the explanation - it doesn't return the client IP address, it returns the server's IP address to which the client connected.

Tom

TomThomson SSC Guru Points: 104773 More actions · Answer 4

SQL Kiwi (1/7/2012)
Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! Or so I thought, perhaps I misinterpreted "IP address of the incoming connection" - I took it to be asking for the client's IP address rather than whichever of several server IP address was connected to. Ah well, perhaps tomorrow.

The only reason I got this right is that only one of the four options had a valid parametername - all the others would have been uncrecognised so that null would be returned. Judging by the explanation, Steve ment to have client_net_address (but that wasn't an option).

Tom

Ron McCullough SSC Guru Points: 63877 More actions · Answer 5

L' Eomot Inversé (1/8/2012)
SQL Kiwi (1/7/2012)
Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! Or so I thought, perhaps I misinterpreted "IP address of the incoming connection" - I took it to be asking for the client's IP address rather than whichever of several server IP address was connected to. Ah well, perhaps tomorrow.
The only reason I got this right is that only one of the four options had a valid parametername - all the others would have been uncrecognised so that null would be returned. Judging by the explanation, Steve ment to have client_net_address (but that wasn't an option).

+1

And the results are showing:

Correct answers: 31% (4)

Incorrect answers: 69% (9)

Total attempts: 13

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

L' Eomot Inversé (1/8/2012)
SQL Kiwi (1/7/2012)
Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! Or so I thought, perhaps I misinterpreted "IP address of the incoming connection" - I took it to be asking for the client's IP address rather than whichever of several server IP address was connected to. Ah well, perhaps tomorrow.
The only reason I got this right is that only one of the four options had a valid parametername - all the others would have been uncrecognised so that null would be returned. Judging by the explanation, Steve ment to have client_net_address (but that wasn't an option).

That is also the only reason I got this correct. No other option was valid. But the correct answer doesn't seem correct to me. I interpreted the question to be asking for the IP of the Client and not the IP of the server that the client connected to.

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

Steve Jones - SSC Editor

SSC Guru

Points: 734418

January 8, 2012 at 9:01 pm

#1430262

Doh, copied the wrong item.

corrected.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 8

Steve Jones - SSC Editor (1/8/2012)
Doh, copied the wrong item.
corrected.

Too much snow boarding without sun glasses ?

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Steve Jones - SSC Editor (1/8/2012)
Doh, copied the wrong item.
corrected.

Glad to see our complaining was effective;-)

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

paul s-306273 SSChampion Points: 10727 More actions · Answer 10

paul s-306273

SSChampion

Points: 10727

January 9, 2012 at 1:57 am

#1430303

Well, there was only one valid combination anyway.

Rich Weissler Hall of Fame Points: 3286 More actions · Answer 11

Explanation currently says "This function takes an argument, and the 'local_net_address' parameter is used to get the IP address of the client." Probably needs to be fixed now too.

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 12

Rich Weissler (1/9/2012)
Explanation currently says "This function takes an argument, and the 'local_net_address' parameter is used to get the IP address of the client." Probably needs to be fixed now too.

Good catch. Thanks and it's fixed.

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 13

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

January 9, 2012 at 8:54 am

#1430546

tks Steve (& all who helped today!)

Revenant SSC-Forever Points: 42467 More actions · Answer 14

As I got to the explanation when it was already corrected, I am left with nothing to complain about. Darn! 🙂

Thanks, Steve!