Getting the Options

Question

Getting the Options

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
December 2, 2019 at 12:00 am

#3696033

Comments posted to this topic are about the item Getting the Options

Viewing 7 posts - 1 through 6 (of 6 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72496 More actions · Answer 1

Nice, easy question to start the week on, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

BTylerWhite SSCommitted Points: 1569 More actions · Answer 2

Thanks for the question, Steve! This was fresh on my mind after having recently read jonfrisbee's article on the subject.

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

Now, all those in the room that have actually used this function in production, please raise your hand! 😀

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

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

I've used it to troubleshoot, wondering if two connections had different settings. Getting a raw number and comparing them worked for me. I haven't really used this to decode settings in production.

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

Steve Jones - SSC Editor wrote:

I've used it to troubleshoot, wondering if two connections had different settings. Getting a raw number and comparing them worked for me. I haven't really used this to decode settings in production.

Thanks, Steve. Haven't had to do such a comparison yet but thanks for the idea. That would certainly make for a quick and easy check.

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

DesNorton SSC-Insane Points: 24276 More actions · Answer 6

Jeff Moden wrote:

Now, all those in the room that have actually used this function in production, please raise your hand! 😀

We have a lot of legacy code that was written loooong before XACT-ABORT. Most of the newer code uses XACT_ABORT, but sometimes wrapping an older proc causes unexpected results with the error handling and transaction control. So I have had to check whether XACT_ABORT is on, turn it off, wrap the old proc, set XACT_ABORT on again.

How to post data/code on a forum to get the best help.