Reputation
206
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 9 21
Impact
~49k people reached

  • 0 posts edited
  • 4 helpful flags
  • 98 votes cast
Aug
17
awarded  Famous Question
Aug
6
awarded  Famous Question
Aug
3
awarded  Caucus
Aug
3
awarded  Constituent
Jul
27
awarded  Yearling
Jun
19
awarded  Popular Question
Jun
15
awarded  Notable Question
Jun
15
awarded  Notable Question
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.