156 reputation
5
bio website tallent.us
location Beaumont, TX
age 39
visits member for 3 years, 2 months
seen 20 mins ago
ASP.NET (VB.NET, C#, SQL Server) developer.

17m
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
Jun
18
answered How do I translate this query from MS Access into SQL Server
Jun
18
answered T-SQL Calculate average value for Duration Field
Dec
5
awarded  Teacher
Nov
16
awarded  Supporter
Nov
16
awarded  Student
Nov
16
asked How can I efficiently represent inheritance down a tree?
Nov
16
awarded  Autobiographer
Aug
29
answered Can I restore a database to a point of time without backup?