1,241 reputation
1941
bio website about.me/DavidForck
location Missouri
age 27
visits member for 3 years, 10 months
seen Mar 6 at 20:58

I'm a database developer for a CRO that does pharmaceutical and chemical studies. My duties include: designing and building databases, troubleshooting database performance issues, building SSRS reports, installing and configuring SQL Server (2005 and 2008), configuring SQL Server security, configuring SSRS security, and some other stuff.

I also build on-line surveys in PHP using a MSSQL Server 2005 backend for an Economic Development Consulting company.


Feb
26
awarded  Popular Question
Feb
12
comment Sum(Case When) Question
yup, without running the code myself that seems to be the issue.
Feb
12
awarded  Nice Question
Feb
12
awarded  Nice Question
Feb
9
answered Best practice - Update Primary Keys
Feb
6
comment Why would a default constraint be missing an index?
@DanGuzman that seems to have done it.
Feb
6
comment 1 hour query, is there another way to do this?
@koljanep i didn't expect it to work right out of the box, was more trying to provide a general layout for you to use. As far as i can tell, without the actual database to play with, this should work.
Feb
6
comment Medical History - Is this DB properly design?
What happens when a patient changes doctors?
Feb
6
revised 1 hour query, is there another way to do this?
added 313 characters in body
Feb
6
answered 1 hour query, is there another way to do this?
Feb
6
comment Updating one table from another table where non-primary-key field is similar string
@CarenRose yeah it sucks when you get so far and then realize that you're missing vital data. but it's always best to do it this way so that you can 100% ensure data quality.
Feb
3
comment Why would a default constraint be missing an index?
@a_horse_with_no_name added
Feb
3
revised Why would a default constraint be missing an index?
added code
Feb
3
asked Why would a default constraint be missing an index?
Feb
3
comment Data containing list of all the domain names. MongoDB or MySQL?
This sounds rather simple for a database solution. What are your expectations for inserting, updating, and deleting the data? What technology/ies will you be using to access this data?
Feb
3
answered Multiple instances of same foreign key in a single table
Feb
3
answered SQL Maintenance Rebuild Fails
Feb
2
awarded  Tumbleweed
Feb
2
awarded  Notable Question
Jan
29
awarded  Famous Question