Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 54,106 through 54,120 (of 66,712 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.

In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 2

Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.

In an ideal world Luis they wouldn't be, but they have to start somewhere. I used to see one such HAB on a recent gig using the same commuter train home from work. Tall, blue chin, receding hair, wearing a dress. Maybe a crossdresser, maybe not.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.

And there lies the biggest challenge. This isn't about transgender, it is about gender "identity" and there is nothing to prevent that "hairy-arsed bloke" from "identifying" as a woman today.

I can assure you that at things like soccer games where the bathroom right now is currently at the mens room I may feel the need to identify as a woman at half time. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

tindog SSCarpal Tunnel Points: 4892 More actions · Answer 4

Sean Lange (5/13/2016)
Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.
And there lies the biggest challenge. This isn't about transgender, it is about gender "identity" and there is nothing to prevent that "hairy-arsed bloke" from "identifying" as a woman today.
I can assure you that at things like soccer games where the bathroom right now is currently at the mens room I may feel the need to identify as a woman at half time. 😉

If people must use the bathroom that matches their bodyparts, what's to stop some man from entering the ladies and claiming to have been born female?

If someone's perverted enough to want to go into the ladies bathroom to spy on people, let's be fair, they're going to do it either way.

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

tindog (5/13/2016)
Sean Lange (5/13/2016)
Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.
And there lies the biggest challenge. This isn't about transgender, it is about gender "identity" and there is nothing to prevent that "hairy-arsed bloke" from "identifying" as a woman today.
I can assure you that at things like soccer games where the bathroom right now is currently at the mens room I may feel the need to identify as a woman at half time. 😉
If people must use the bathroom that matches their bodyparts, what's to stop some man from entering the ladies and claiming to have been born female?
If someone's perverted enough to want to go into the ladies bathroom to spy on people, let's be fair, they're going to do it either way.

If said person is now a man then their parts would be sticking out right? If they still have female parts then they would be female. Of course there is nobody who is going to inspect but the whole thing is kind of silly.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 6

Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.

Discrimination in any way, shape, size or form is not debatable, it's just wrong!

😎

tindog SSCarpal Tunnel Points: 4892 More actions · Answer 7

Sean Lange (5/13/2016)
tindog (5/13/2016)
Sean Lange (5/13/2016)
Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.
And there lies the biggest challenge. This isn't about transgender, it is about gender "identity" and there is nothing to prevent that "hairy-arsed bloke" from "identifying" as a woman today.
I can assure you that at things like soccer games where the bathroom right now is currently at the mens room I may feel the need to identify as a woman at half time. 😉
If people must use the bathroom that matches their bodyparts, what's to stop some man from entering the ladies and claiming to have been born female?
If someone's perverted enough to want to go into the ladies bathroom to spy on people, let's be fair, they're going to do it either way.
If said person is now a man then their parts would be sticking out right? If they still have female parts then they would be female. Of course there is nobody who is going to inspect but the whole thing is kind of silly.

They could have female parts and a full beard. And no-one would be able to tell if they were being truthful without looking.

I agree it is silly, people get beaten up and killed for being trans, let them pee wherever they feel safest. No idea why it's suddenly an issue - they've always been able to use their preferred bathroom until now.

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

tindog (5/13/2016)
Sean Lange (5/13/2016)
tindog (5/13/2016)
Sean Lange (5/13/2016)
Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.
And there lies the biggest challenge. This isn't about transgender, it is about gender "identity" and there is nothing to prevent that "hairy-arsed bloke" from "identifying" as a woman today.
I can assure you that at things like soccer games where the bathroom right now is currently at the mens room I may feel the need to identify as a woman at half time. 😉
If people must use the bathroom that matches their bodyparts, what's to stop some man from entering the ladies and claiming to have been born female?
If someone's perverted enough to want to go into the ladies bathroom to spy on people, let's be fair, they're going to do it either way.
If said person is now a man then their parts would be sticking out right? If they still have female parts then they would be female. Of course there is nobody who is going to inspect but the whole thing is kind of silly.
They could have female parts and a full beard. And no-one would be able to tell if they were being truthful without looking.
I agree it is silly, people get beaten up and killed for being trans, let them pee wherever they feel safest. No idea why it's suddenly an issue - they've always been able to use their preferred bathroom until now.

I agree that safety is important. I don't know how a 5th grader would feel about a girl walking into the bathroom while he is doing his thing. It seems that no matter what the answer is somebody is going to be in an awkward situation.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

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

tindog (5/13/2016)
Sean Lange (5/13/2016)
tindog (5/13/2016)
Sean Lange (5/13/2016)
Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.
And there lies the biggest challenge. This isn't about transgender, it is about gender "identity" and there is nothing to prevent that "hairy-arsed bloke" from "identifying" as a woman today.
I can assure you that at things like soccer games where the bathroom right now is currently at the mens room I may feel the need to identify as a woman at half time. 😉
If people must use the bathroom that matches their bodyparts, what's to stop some man from entering the ladies and claiming to have been born female?
If someone's perverted enough to want to go into the ladies bathroom to spy on people, let's be fair, they're going to do it either way.
If said person is now a man then their parts would be sticking out right? If they still have female parts then they would be female. Of course there is nobody who is going to inspect but the whole thing is kind of silly.
They could have female parts and a full beard. And no-one would be able to tell if they were being truthful without looking.

And people who are going through the gender change process (usually, afaik) change appearance well before they get the surgery. I have a transgender friend who you would swear blind is female. Medium-length blond hair, more makeup than I wear, skirt/dress, but who won't be getting the gender change surgery for several months still and hence still counts as male by the suggested rules.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Sean Lange (5/13/2016)
tindog (5/13/2016)
Sean Lange (5/13/2016)
tindog (5/13/2016)
Sean Lange (5/13/2016)
Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.
And there lies the biggest challenge. This isn't about transgender, it is about gender "identity" and there is nothing to prevent that "hairy-arsed bloke" from "identifying" as a woman today.
I can assure you that at things like soccer games where the bathroom right now is currently at the mens room I may feel the need to identify as a woman at half time. 😉
If people must use the bathroom that matches their bodyparts, what's to stop some man from entering the ladies and claiming to have been born female?
If someone's perverted enough to want to go into the ladies bathroom to spy on people, let's be fair, they're going to do it either way.
If said person is now a man then their parts would be sticking out right? If they still have female parts then they would be female. Of course there is nobody who is going to inspect but the whole thing is kind of silly.
They could have female parts and a full beard. And no-one would be able to tell if they were being truthful without looking.
I agree it is silly, people get beaten up and killed for being trans, let them pee wherever they feel safest. No idea why it's suddenly an issue - they've always been able to use their preferred bathroom until now.
I agree that safety is important. I don't know how a 5th grader would feel about a girl walking into the bathroom while he is doing his thing. It seems that no matter what the answer is somebody is going to be in an awkward situation.

I agree on safety. I don't agree that a big deal needs to be made of it.

People have been using the bathroom (with or without the big todo over it) for which they identify for a long-time.

Kids have always found a way to take a peek in the other bathroom - that can't be denied.

Making a big deal out of it will encourage many of those peekers to continue to do so. It will also give those who were too timid to peek (but always wanted to) a little more leverage to do so. Those who don't care will continue to not care imho.

I do see this as becoming a bigger problem in schools now though. It is hard enough to keep the kids at bay with the bathroom thing without giving them extra ammunition. I have worked in the school system and have close ties to the school system (family members who teach). In addition my children are still in school. This will become a bigger problem for quite a while. It will eventually die down as people get used to it.

Frankly, the government didn't need to step in and issue an executive order (and this kind of social persuasion is essentially a threat and executive order) for this issue. People just need to grow up and act mature. I have seen plenty of transgenders in the men's room. It's no different than seeing a non-transgender in the men's room.

The line might need to be drawn at allowing boys who identify as girls to shower with the girls (and vice versa) in the group showers in schools. I can't imagine there would be a high level of comfort there. I can also imagine some rather hefty lawsuits coming because of the discomfort that boy caused to somebody's little girl.

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 11

SQLRNNR (5/13/2016)
Sean Lange (5/13/2016)
tindog (5/13/2016)
Sean Lange (5/13/2016)
tindog (5/13/2016)
Sean Lange (5/13/2016)
Luis Cazares (5/13/2016)
ChrisM@Work (5/13/2016)
Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.
In my opinion, that "hairy-arsed bloke" wouldn't be a transgender.
And there lies the biggest challenge. This isn't about transgender, it is about gender "identity" and there is nothing to prevent that "hairy-arsed bloke" from "identifying" as a woman today.
I can assure you that at things like soccer games where the bathroom right now is currently at the mens room I may feel the need to identify as a woman at half time. 😉
If people must use the bathroom that matches their bodyparts, what's to stop some man from entering the ladies and claiming to have been born female?
If someone's perverted enough to want to go into the ladies bathroom to spy on people, let's be fair, they're going to do it either way.
If said person is now a man then their parts would be sticking out right? If they still have female parts then they would be female. Of course there is nobody who is going to inspect but the whole thing is kind of silly.
They could have female parts and a full beard. And no-one would be able to tell if they were being truthful without looking.
I agree it is silly, people get beaten up and killed for being trans, let them pee wherever they feel safest. No idea why it's suddenly an issue - they've always been able to use their preferred bathroom until now.
I agree that safety is important. I don't know how a 5th grader would feel about a girl walking into the bathroom while he is doing his thing. It seems that no matter what the answer is somebody is going to be in an awkward situation.
I agree on safety. I don't agree that a big deal needs to be made of it.
People have been using the bathroom (with or without the big todo over it) for which they identify for a long-time.
Kids have always found a way to take a peek in the other bathroom - that can't be denied.
Making a big deal out of it will encourage many of those peekers to continue to do so. It will also give those who were too timid to peek (but always wanted to) a little more leverage to do so. Those who don't care will continue to not care imho.
I do see this as becoming a bigger problem in schools now though. It is hard enough to keep the kids at bay with the bathroom thing without giving them extra ammunition. I have worked in the school system and have close ties to the school system (family members who teach). In addition my children are still in school. This will become a bigger problem for quite a while. It will eventually die down as people get used to it.
Frankly, the government didn't need to step in and issue an executive order (and this kind of social persuasion is essentially a threat and executive order) for this issue. People just need to grow up and act mature. I have seen plenty of transgenders in the men's room. It's no different than seeing a non-transgender in the men's room.
The line might need to be drawn at allowing boys who identify as girls to shower with the girls (and vice versa) in the group showers in schools. I can't imagine there would be a high level of comfort there. I can also imagine some rather hefty lawsuits coming because of the discomfort that boy caused to somebody's little girl.

Agreed on all counts. It is such a shame that the government had to step and make the situation a big deal. It is the extremes that causes me to think that group restrooms will start to decrease and we will see more like gender neutral stalls. The problem with that is it means the restroom either need to occupy more space or the capacity decreases.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 12

jasona.work (5/13/2016)
So at the Detroit SQL PASS meeting last night, got to put faces to the names of those shining beacons of SQL knowledge and all things pork chop launching, Ed Wagner and Jeff Moden!
While they did go out afterwards, I declined that invite (and with what the weather got like, guys, I'm kind of glad I did!) perhaps next time!

Same here. Good to put a face to the name. Glad to meet you in person!

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 13

Sean Lange (5/13/2016)
Brandie Tarvin (5/13/2016)
For those who hadn't heard, THIS happened.
Yay.
EDIT: I should add I'm not trying to start a debate. I just wanted to pass along the news.
IMHO people should use the bathroom that matches their parts. The whole nonsense of identity is rubbish. We are setting our children up to see things they shouldn't be seeing on other students when people with mismatched parts are using the same bathroom. To be honest what is going to happen as a result of this absurd legislation is we are going to see group bathrooms disappear. All restrooms will be gender neutral but only have enough space for 1 person.

Oh, if only that were ever to come true.

I'm a guy, I know that public culture suggests that I should be perfectly comfortable baring my private parts while standing next to other guys. Well guess what - I am not. I much rather wait, even if it is a few minutes for a cubicle to come available so I can relieve myself in private, without anyone seeing it.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 14

Not to stoke the fires, but this isn't a big deal in Europe.

6 or 8 stalls in here, anyone using any one. No issues. This in a public, IMAX theater, in a public mall. I've been in co-ed, naked, saunas in Europe, all ages, and no issues.

Don't be so afraid. No one gets to "identity" today and not tomorrow. That's sophmoric, frat boy views of the world. Frat boys get suspended or arrested for crap like this.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 15

ChrisM@Work (5/13/2016)
Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering about with makeup and chatting about dates and in walks a hairy-arsed bloke like he owns the place, leaves the cubicle door open and pees all over the seat.
Look after your minorities for sure, but not at the expense of your majorities.

As a guy using the guys bathroom, I would get just as upset about someone leaving the cubicle door open and peeinig over the seat. This has nothing to do with gender identify, this is just plain bad manners. Bad manners are not acceptable in either a girls restroom or a boys restroom.

The persen (of whatever physical gender and whatever gender identify) leaving the door open and peeing over the seat should be slapped and then aducated on manners.

But here's another picture. Imagine a transgender. Born a boy, but feeling a girl inside. After a long period of mental pains and uncertainty, decides to start the procedure to get a gender change. Do you know how that procedure works? I do. The first phase requires the child (most of the time this happens just before puberty kicks in) to only change their lifestyle - assume a femal identity, dress like a girl, behave like a girl. For several months. All before any medication or any surgery is started. So now you finally get to live like the gender you had, but you are confronted with lack of understanding from many people around you. And every time you undress, you are confronted with your wrong body.

But now also imagine your life. Sure, you go to school using a girls name, you hang with the girls, you wear make-up - and then what restroom will you use? I'd you you use the girls room. And of course carefully lock your cubicle - the last thing you want is for anyone to find out that you have a boy body; you know how cruel and brutal kids of that age are to anyone who dares to be different.

The North Carolina law (or at least the part I understood from it from European media coverage) is particularly cruel to these children. Often these kids, when possible, time their gender behaviour change with a school change, to avoid being a victim of bullies. But how does that work if, on the first day at school you introduce yourself as a girl ... and then have to go to the boys restroom? Yup - number 1 bully victim for the rest of their school carreer.

(I am sorry if I come of a bit strong. A very close friend of mine has a son who has been struggling with his gender identity for a very long time, including very seriously considering going through a gender change. And I can assure you as a front-row seat witness, that that is not a decision, or even a consideration, that a child takes lightly. Nor is it a situation that is even remotely easy for the child, or its parents. This boy ended up deciding not to go through with it - he realised that though he never felt a "real boy", he also is not a "real girl"; he is more an in-betweener; he realized that surgery would not really fix his problems. But during the process, I have met many children and adults in various stages of the procedure. So yes, I can get pretty vocal when people make statements on this issue that show a total lack of understanding of the actual issues.

And before this turns into a full flame war: that last comment was made in general and not targeted at any of the people responding in this thread. I am more thinking about a few people I have met in real life.)

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/