1,073 reputation
732
bio website about.me/DavidForck
location Missouri
age 27
visits member for 3 years, 4 months
seen Sep 4 at 17:52

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.


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
Jul
23
suggested suggested edit on Import data problem in SQL Server 2008
Jul
23
revised BUILTIN\Administrators accidently removed
some cleanup
Jul
23
suggested suggested edit on BUILTIN\Administrators accidently removed
Jul
3
comment Generate create script for all indexes
@jnk true, do you know of a powershell script for this? I've never done anything with powershell before.
Jul
3
comment Generate create script for all indexes
@caderoux as long as I can run it in SSMS i'm happy.
Jul
3
asked Generate create script for all indexes
Jul
3
answered SQL server indexing foreign keys, covering indexes included columns
Jul
3
answered How to create a summary report that contains other reports?
Jun
18
comment Is there a way to use a SQL Server 2000 database in SSIS 2012?
@billinkc added info
Jun
18
revised Is there a way to use a SQL Server 2000 database in SSIS 2012?
added 63 characters in body
Jun
13
asked Is there a way to use a SQL Server 2000 database in SSIS 2012?
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jun
7
comment Why is the page life expectancy 0 (zero) on SQL Server 2005
weird, double checked your code on my prod server and it seems to work fine.