179 reputation
418
bio website stackoverflow.com
location Canada
age 25
visits member for 2 years
seen 16 hours ago

Jan
21
awarded  Popular Question
Jan
12
accepted How can I make this query sargable?
Jan
10
awarded  Notable Question
Jan
9
comment How can I make this query sargable?
Awesome, thanks. I'll give that a shot tomorrow and report back. I'm on sql server 2014, by the way - I've tagged the question as such.
Jan
9
revised How can I make this query sargable?
added version tag
Jan
8
comment How can I make this query sargable?
@AaronBertrand Is it actually possible to perform that conversion in a computed column? I'm getting 'Explicit conversion not allowed', or if I use fn_sqlvarbasetostr it complains about specifying the master database, or not being able to find the function.
Jan
8
comment How can I make this query sargable?
@AaronBertrand about 10k. I'm using openquery to limit to the most relevant rows before joining (I found it was faster than trying to join the whole table). The computed column idea is interesting, I'll take a look at that.
Jan
8
comment How can I make this query sargable?
@JNK Indeed, but I'm talking about running a function on a table with 60k rows (right now) vs one with 1000 (the second table) so I think there's still a performance improvement to be had.
Jan
8
comment How can I make this query sargable?
@AaronBertrand Unfortunately, the actual situation is more complicated (as it often is). The second table is actually on a DB2 linked server that can't store a rowversion data type (and even if it could I don't think I could get it changed).
Jan
8
asked How can I make this query sargable?
Jan
5
awarded  Notable Question
Dec
12
accepted XACT_ABORT OFF vs COMMIT in trigger
Dec
12
comment XACT_ABORT OFF vs COMMIT in trigger
I've done the test, and it worked - I just want to make sure I understand what I'm doing. I already had the try/catch in there. Thanks for your help!
Dec
12
comment XACT_ABORT OFF vs COMMIT in trigger
Okay, so, just so I understand: COMMIT TRAN ensures the data gets committed (obviously), BEGIN TRAN prevents an error from being thrown, and XACT_ABORT makes the batch succeed despite any errors?
Dec
12
comment XACT_ABORT OFF vs COMMIT in trigger
Well, I'm not getting any error message. What is the point of XACT_ABORT in this situation if I'm already doing a commit?
Dec
12
comment XACT_ABORT OFF vs COMMIT in trigger
@MartinSmith I'm already using service broker.
Dec
12
asked XACT_ABORT OFF vs COMMIT in trigger
Nov
17
comment Localization: One table or multiple tables? (MySQL)
I would store as ID | culture | message instead.
Oct
24
revised Issues with module signing and SSIS catalog internal procedures
added 97 characters in body
Oct
24
accepted Issues with module signing and SSIS catalog internal procedures