@AaronBertrand haha. no. our purchasing process is upside down and backward. they have vendor relationships and such and they prefer to go through them. i can make it happen out-of-proc but it takes more "doin'"
I'm still watching some of the intro videos and it's not even installed on my DEV box yet. There are certainly some features that I'm pretty much already in love with though.
I'm a pretty huge fan of the cumulative cost feature.
Buy the ... "clever name here" but basically it's a do-over. Costs a bit more than a straight exam but less than a full price retake. Review the high level points, maybe take a practice exam to get familiar with the process then walk in with no prep and see how you do
They also discount for multiple exams so 3 tests is cheaper than 3 singles
Abandoning the discussion, not sure what his point is. It's a silly scenario anyway which I wouldn't use but maybe once or twice in a lifetime:
My issue is that the score is so high that this looks like de facto answer to the question in the title. It took me 10 minutes to build a test app to determine that it wasn't (maybe that is my fault for not being so good at SQL Server). I wouldn't have down voted the answer if you had been clear that this answer does not actually have anything to do with transactions, but everything to do with sessions: context info is persisted between transactions in the same session. — The Mouth of a Cow10 mins ago
@AaronBertrand I just don't understand how the transactions really come into it and what problem he was having. If he wanted to disable the trigger on a transaction, any connections participating in the transaction could use the same technique, ensuring that they set that context when they wanted the trigger to be disabled and not when they didn't want it to be disabled. There is no native way to attach it to a transaction, so the "scope" is user-determined.
@CadeRoux the guy who's mouthing off is just reading the question title (which is probably inaccurate and should probably be edited) and complaining that your answer doesn't answer the question title (which does not accurately reflect the actual question). If he doesn't get it, he doesn't get it, move on. :-)
@AaronBertrand I have suggested an alternative title, which I hope will be acceptable to him. I guess when he posted the comment I thought there was some special caveat about how he was doing his transactions - but the answer would still be relevant as far as I can tell.
@swasheck Yes, apparently a few others piled on from here probably - +88 rep on a 4 year old answer...
@CadeRoux so like I said, move on. You're way ahead, nobody is going to be able to see that down-vote and it's only relevant to that person because he didn't read.
I want toad to format this text as follow
AS IS
AND flh_punto_erogazione IN (
'2607649056',
'3201639162',
'2607237274',
'8000222270',
'2602063519',
'1400106868',
'8000228653',
'8000989667',
'6108647931',
'1109261592',
'1110312178')
TO BE
AND flh_punto_erogazione IN (
'2607649056', '320163916...
@swasheck Adequately sizing a VM for a SQL Server, outside the nasty spikey resource consumption of OLAP work, is not much different to sizing a physical server. It's got to be big enough for the job in hand
I want toad to format this text as follow
AS IS
AND flh_punto_erogazione IN (
'2607649056',
'3201639162',
'2607237274',
'8000222270',
'2602063519',
'1400106868',
'8000228653',
'8000989667',
'6108647931',
'1109261592',
'1110312178')
TO BE
AND flh_punto_erogazione IN (
'2607649056', '320163916...
