1,053 reputation
627
bio website about.me/DavidForck
location Missouri
age 27
visits member for 2 years, 11 months
seen Feb 7 at 22:07

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.


Jan
21
answered SQL services wont start due to incorrect drive letter after windows restore
Jan
21
comment Setting up simple question & answer database
I don't see the need for AnswerGroupQuestions when you could just put a non-nullable FK to AnswerGroups in the Questions table since one question can only have one Answer Group.
Jan
21
asked Replication and linked server security
Dec
20
awarded  Popular Question
Nov
30
comment considerations when using triggers on a replicated (target) database
you should be able to create a publication on your dev server and then create a subscription database with a different name so that you can test on the same server. I haven't done this personally so YMMV.
Nov
16
comment Is 2.23 mbs/sec for 8k random writes slow?
It's solely a SQL Server... server. I will try and add as much info tomorrow.
Nov
14
asked Security permission to only read SSAS Cube with Excel
Nov
14
revised Is 2.23 mbs/sec for 8k random writes slow?
added 4 characters in body
Nov
14
asked Is 2.23 mbs/sec for 8k random writes slow?
Oct
10
awarded  Talkative
Sep
21
awarded  Custodian
Sep
4
accepted Convert datetime to europe default without time
Aug
27
comment How to convert execution time to a specific format?
that worked! Awesome, thank you!
Aug
27
accepted How to convert execution time to a specific format?
Aug
27
comment How to convert execution time to a specific format?
@jonseigel I tried that, but I couldn't find any information online that was useful and what I tried was completely wrong (it was coming out as the number of the week).
Aug
27
asked How to convert execution time to a specific format?
Aug
27
reviewed Reject suggested edit on Convert datetime to europe default without time
Aug
27
asked Convert datetime to europe default without time
Aug
27
answered Convert datetime to europe default without time
Jul
23
revised Import data problem in SQL Server 2008
added tagged, tryed to clean up some wording