1,073 reputation
731
bio website about.me/DavidForck
location Missouri
age 27
visits member for 3 years, 3 months
seen Aug 7 at 14:50

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
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 suggested 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 suggested 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).
Apr
3
asked How can I set the index fill factor back to server default?
Mar
28
comment SQL Server 2012 backward compatibility for backups with 2008
Similar question on SO: stackoverflow.com/q/1744808/95710
Mar
28
comment SQL Server 2012 backward compatibility for backups with 2008
Yup, I've had this exact same problem before. Ended up scripting out the entire database and then scripting out all of the data. Red Gate's SQL Compare and Data Compare came to the rescue that day.
Mar
28
comment Does the order of columns has a significant effect on INSERT?
I mainly keep it in the same order for consistency. Copy/paste FTW!
Mar
27
answered Recommendations on creating user-objects on system database