212 reputation
214
bio website SeanKilleen.com
location District of Columbia Metro area
age 28
visits member for 3 years, 1 month
seen Dec 16 at 14:55

Dec
7
comment SQL Server 2008R2 XML Column Index strategy for large tables?
This is an awesomely thorough answer. Thank you!
Dec
7
accepted SQL Server 2008R2 XML Column Index strategy for large tables?
Dec
1
awarded  Yearling
Dec
1
asked SQL Server 2008R2 XML Column Index strategy for large tables?
Jul
2
awarded  Curious
May
15
awarded  Notable Question
Apr
23
awarded  Commentator
Apr
23
comment Table with multiple lookups
@MarkWilkinson in this case it's a name, address, and phone number, and all generally for businesses.
Apr
22
awarded  Tumbleweed
Apr
15
asked Table with multiple lookups
Mar
27
comment Do SQL Server Views update their data types automatically based on what tables feed them?
Great answer in several ways: made it understandable, gave an executable example, and provided two other tips I hadn't heard of before. Thank you! I'll be putting all of those (including testing with test tables, etc.) to use in the future.
Mar
27
accepted Do SQL Server Views update their data types automatically based on what tables feed them?
Mar
27
asked Do SQL Server Views update their data types automatically based on what tables feed them?
Oct
24
awarded  Popular Question
Jul
5
awarded  Popular Question
Apr
2
awarded  Popular Question
Nov
16
revised Should I use SQL or NoSQL for this specific design (surveys)?
Added an additional point to adjust to a comment I'd asked.
Nov
16
comment Should I use SQL or NoSQL for this specific design (surveys)?
Thank you, I appreciate the thorough response! Was wondering if you maybe could update it to add your thoughts on an additional concern: with a NoSQL solution (particularly RavenDB), to an extent my objects become my schema and can adjust as necessary. I have to build that in SQL server first (unless I go with Entity Framework). Thoughts on this aspect?
Nov
16
asked Should I use SQL or NoSQL for this specific design (surveys)?
Sep
27
comment Query missing one date; only happened today
Also, If you'd be willing to comment, I'm interested in the speed implications of my answer, because I think it is more readable, though includes a separate union statement. I'm thinking the speed difference should be negligible given the scope.