Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
5 19
Impact
~36k people reached

  • 0 posts edited
  • 4 helpful flags
  • 94 votes cast
Mar
31
accepted How can I change the data source of a linked report?
Mar
28
awarded  Notable Question
Mar
24
awarded  Popular Question
Mar
2
comment SQL error: Unknown column in 'where clause'
This doesn't have much to do with your question, but please read this: stackoverflow.com/q/60174/1324019
Feb
6
comment Why does the SQL Server 2012 SA account always show up with creation date of 4/8/2003?
I can't see how that could possibly cause any problems...
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?