345 reputation
18
bio website
location
age
visits member for 2 years, 1 month
seen Aug 15 at 18:33

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, ''))?
Sep
11
comment Is there a way to test whether DELETE will fail due to constraints?
@JackDouglas I have read The Heap comments that you reference and understand the point. The community comments were reasonable except for the part where I was called a clown for pointing out his aggression. I don't understand how I am the one who was seen as aggressive. I posted a legitimate answer to the question as it was posed at the time. It did not ask for production quality - sometimes you just need quick and easy. So on my answer I get pointed questions. The appearance was that he was denigrating my answer so that his would be picked. Should we take this thread elsewhere?