1,088 reputation
835
bio website about.me/DavidForck
location Missouri
age 27
visits member for 3 years, 7 months
seen Dec 22 at 18:22

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.


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.
Jun
6
comment why do SSRS reports run longer for a particular user
Have you tried having the same user execute the report from a different machine using their same credentials?
Jun
6
answered SQL Server log shrinking Issue
Jun
6
comment Recursive CTE performance
Some sample data would be dandy
May
14
awarded  Taxonomist
May
11
awarded  Yearling
May
7
comment Is Index causing timeouts?
What is happening when the timeouts happen?
May
7
comment Setting up users and admins with schema privileges
definatley can't do this. the application calls the stored procedures by schema.procname. by moving the procs to different schemas we completley break the app, and we're getting ready to do a final push to production. hence why i'm trying to clear up security.
May
7
accepted Can you rename or name Reporting Services jobs?
May
7
accepted What is the signifigance of a fillfactor of 20?
May
7
accepted Job Schedule view
May
7
accepted Can you rename replication jobs?
May
7
accepted Tracking stored procedure usage
May
7
asked Setting up users and admins with schema privileges
May
1
asked Can you rename or name Reporting Services jobs?
May
1
asked Can you rename replication jobs?
Apr
25
comment Help with this query
no explination of your code?