190 reputation
114
bio website SeanKilleen.com
location District of Columbia Metro area
age 27
visits member for 2 years, 10 months
seen May 22 at 19:11

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.
Sep
27
comment Query missing one date; only happened today
Hi Justin, per my previous answer I also noted that taking the query into account, I decided that there was no way my user could have been running the query as she claimed she was, because it (as you correctly state) would have never returned the current date. Thank you for answering!
Sep
26
awarded  Teacher
Sep
26
answered Query missing one date; only happened today
Sep
26
asked Query missing one date; only happened today