345 reputation
28
bio website
location
age
visits member for 2 years, 3 months
seen Nov 20 at 20:34

Oct
3
awarded  Notable Question
Jul
2
awarded  Curious
Mar
24
comment Multicolumn statistics on large table yielding poor estimations
Did you have any luck with this? I see below that you had some interaction away from the thread.
Dec
31
asked Make View Supersede Table in Same Database?
Nov
8
awarded  Popular Question
Aug
26
accepted Optimize Query of Count Less Than
Aug
26
comment Optimize Query of Count Less Than
Wow, I never thought to do it this way. For the query in question, I think we'll stick with the original to keep with consistent code methodology. But very cool. We'll keep this in mind for optimization.
Aug
23
asked Optimize Query of Count Less Than
Aug
10
awarded  Yearling
Jul
8
accepted ALLOW_SNAPSHOT_ISOLATION Duration
Jul
3
asked ALLOW_SNAPSHOT_ISOLATION Duration
May
17
accepted Execution plan results for sp_executesql suggests adding missing index for already existing index
Oct
27
comment Execution plan results for sp_executesql suggests adding missing index for already existing index
Yes, it's identical.
Oct
27
asked Execution plan results for sp_executesql suggests adding missing index for already existing index
Oct
17
asked List of changes required to upgrade scripts after starting to use replication in SQL Server
Oct
11
accepted To use or not use ISNULL(NULLIF(Field1, ''))?
Oct
9
comment To use or not use ISNULL(NULLIF(Field1, ''))?
@AaronBertrand Unfortunately I don't know the design decisions behind this field. My guess is that performance gains were intended in not allowing NULLs. However, IIRC, the field would need to be fixed width in order for the performance gain to apply, so the varchar wouldn't gain much.
Oct
9
comment To use or not use ISNULL(NULLIF(Field1, ''))?
@AaronBertrand It's varchar, which defaults to being rtrimmed. Unfortunately I don't know the design decisions behind this field.
Oct
8
comment To use or not use ISNULL(NULLIF(Field1, ''))?
Good point about the latter not replacing NULL with default. Fortunately the case I had in mind references a non-nullable column.
Oct
8
asked To use or not use ISNULL(NULLIF(Field1, ''))?