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

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.


Apr
17
answered Why do people recommend not using the name “Id” for an identity column?
Apr
13
asked Tracking stored procedure usage
Apr
13
answered Manage select results in sql
Apr
12
comment Prevent Data Sources from being deployed outside designated folder
Yup, use Reporting Service's built in security management.
Apr
12
comment Manage select results in sql
What do you mean by manipulate? What are you doing after the initial select?
Apr
5
awarded  Organizer
Apr
5
revised What is the easiest way to use a SQL Server backup to retrieve just a few rows?
spelling, grammer, tags
Apr
5
suggested approved edit on What is the easiest way to use a SQL Server backup to retrieve just a few rows?
Apr
5
comment Beginner design of biological sampling database
i'm still for not having a visits table....
Apr
5
answered CTE Running in Infinite Loop
Apr
5
comment Beginner design of biological sampling database
@penyuan you would just filter on the dates and compare the results for the first date to the second date.
Apr
5
comment Beginner design of biological sampling database
@ypercube why would you add the location ID to the measurements table? That's a redundent data point since you can join the measurement table to the tree table, which is joined to the location table?
Apr
5
comment Survey database design: first version. Are there errors?
this question on so may help: stackoverflow.com/questions/4965317/…
Apr
5
answered Beginner design of biological sampling database
Apr
4
revised Distribution database compatibility level
removed "thanks"
Apr
4
suggested approved edit on Distribution database compatibility level
Apr
4
revised Why are periodic restarts required to keep my instance performing well?
added 577 characters in body
Apr
4
answered Why are periodic restarts required to keep my instance performing well?
Apr
3
comment How can I set the index fill factor back to server default?
Also, went into designer, removed the pk, saved, then readded the pk, same thing.
Apr
3
comment How can I set the index fill factor back to server default?
Weird. I right-clicked - script- drop and recreated the index, removed the fillfactor line and executed, and it's now specifying 95 for the fillfactor (same as the server).