Changing roles

Question

Post reply

Changing roles

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
August 17, 2015 at 8:45 pm

#74435

Comments posted to this topic are about the item Changing roles
August 18, 2015 at 11:21 pm

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

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

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 1

The correct answer is "It Depends" on which version of SQL Server you're using. 😉

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

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 2

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉

When not explicitly mentioned, the last version that is publicly available.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287024 More actions · Answer 4

Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that is publicly available.

That's the exact thought process I went through. Then it became pretty simple.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

ldorian81 SSCommitted Points: 1694 More actions · Answer 5

Good question 🙂

Regards
ld

Stoke-on-Trent
United Kingdom

If at first you don't succeed, go to the pub and drink away your current thought plan.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

Thanks for the question. It's not something I've used.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that is publicly available.

Well, since that is a CTP, things could change any day. 😉

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

Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that is publicly available.

Heh... yeah... I know that but let's just suppose that they make another change in the future where the correct answer for the current "latest version" is no longer the correct answer for the question. I think that all these questions should have the version of SQL appropriate for the question be listed in the question.

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

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

Jeff Moden (8/18/2015)
Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that is publicly available.
Heh... yeah... I know that but let's just suppose that they make another change in the future where the correct answer for the current "latest version" is no longer the correct answer for the question. I think that all these questions should have the version of SQL appropriate for the question be listed in the question.

You can always tie the question to the publicly available version by date - after all, it is a question of the day. That also implies that the version should always be specified for previews.

This point may eventually become confusing if MSFT extends the "software as a service" model to SQLS and you will deal with - perish the thought - a continuously updated SQL Server 365.

Thanks to Steve for the question and to everyone for the discussion!

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 10

Revenant (8/18/2015)
Jeff Moden (8/18/2015)
Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that is publicly available.
Heh... yeah... I know that but let's just suppose that they make another change in the future where the correct answer for the current "latest version" is no longer the correct answer for the question. I think that all these questions should have the version of SQL appropriate for the question be listed in the question.
You can always tie the question to the publicly available version by date - after all, it is a question of the day. That also implies that the version should always be specified for previews.
This point may eventually become confusing if MSFT extends the "software as a service" model to SQLS and you will deal with - perish the thought - a continuously updated SQL Server 365.
Thanks to Steve for the question and to everyone for the discussion!

It would be a whole lot easier if people would just put the version number on their questions. "Version: 2014 EE". How hard is that?

Shifting gears a bit, just imagine if SQL Server were continuously updated. Instead of the occasion significant and well publicized bombs like 2014 SP1, there would be daily knife cuts to the very fabric of your business. Imagine trying to troubleshoot such a thing. No thank you!

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

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 11

Easy question as the possibilty to add/remove members to database roles was introduced in SQL Server 2012. So the question about the version is useless as ( if I am not going wrong ) I usually am replying with my knowlegdes concerning the supported versions ( 2012/2014 ).

2016 is only in CTP state and when the question is related to this version , I am considering only the last available level of the CTP.