202 reputation
17
bio website tallent.us
location Beaumont, TX
age 39
visits member for 3 years, 4 months
seen Feb 23 at 14:49
ASP.NET (VB.NET, C#, SQL Server) developer.

Jan
30
comment How to select the largest value of the same column in multiple tables?
Whoops, I missed that detail. Alas.
Jan
29
awarded  Yearling
Jan
29
awarded  Critic
Jan
29
answered How to select the largest value of the same column in multiple tables?
Jan
29
answered Alternative to RDBMS: Modeling Exam/Testing data
Jan
29
accepted How can I efficiently represent inheritance down a tree?
Jan
29
accepted Should I used varchar(max) or varchar(4000) SPARSE?
Jan
29
comment Can I optimize a left join for a single match?
Great idea. I wasn't aware that an index could be marked unique based on filter criteria. @ypercube, can you rewrite your comment as an answer so I can accept it?
Jan
28
asked Can I optimize a left join for a single match?
Jan
28
asked Should I used varchar(max) or varchar(4000) SPARSE?
Jan
26
answered Normalising shared entities and applying constraints
Jan
26
awarded  Scholar
Jan
26
accepted Can I use SPARSE somehow on a non-nullable bit column with mostly false values?
Jan
26
comment Can I use SPARSE somehow on a non-nullable bit column with mostly false values?
Thanks Aaron. It is redundant, but the alternative requires a correlated subquery that is easily an order of magnitude slower (even with a covering index). Table partitioning would be a great solution, but I only have the Standard license. I'm looking forward to getting into the office tomorrow and running some tests with a filtered index.
Jan
25
comment Can I use SPARSE somehow on a non-nullable bit column with mostly false values?
@AaronBertrand, that sounds like a great solution and also may help solve an unrelated problem I'm having because my Standard Edition license doesn't support partitioned tables. Can you rewrite your comment as an answer so I can accept it?
Jan
25
asked Can I use SPARSE somehow on a non-nullable bit column with mostly false values?
Jun
19
revised T-SQL Calculate average value for Duration Field
added 714 characters in body
Jun
18
awarded  Editor
Jun
18
comment T-SQL Calculate average value for Duration Field
Andriy, after testing, I agree, DATEDIFF() is much faster at converting the nvarchar than intrinsic string functions and integer casts. Answer updated.
Jun
18
revised T-SQL Calculate average value for Duration Field
deleted 91 characters in body