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.


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
Mar
27
comment Storing date as integer (numeric), what are the advantages
I'd like to see the case where you filter a query by joining to a date table with the dates stored as numeric and filtering those numeric dates would beat using "where [date] between @startdate and @enddate"
Mar
27
answered Storing date as integer (numeric), what are the advantages
Mar
27
comment Storing date as integer (numeric), what are the advantages
If you're running SQL Server 2008 or higher, you can actually just use the data type Date. It's a bit smaller and doesn't force you to include time, but almost all of SQL's datetime functions still work for it.
Mar
23
asked What is the signifigance of a fillfactor of 20?
Mar
23
comment Behavior of data in indexes based on fill factor
OK, so I was wrong with how the behavior worked. Thank you for such a detailed answer!