1,063 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.


Dec
15
comment Same queries, different servers, different exec plans, stats are up to date
@RolandoMySQLDBA yes
Dec
15
comment Same queries, different servers, different exec plans, stats are up to date
@MarkStorey-Smith the xml plans are too large to post here
Dec
15
comment Same queries, different servers, different exec plans, stats are up to date
i added the sql code
Dec
15
revised Same queries, different servers, different exec plans, stats are up to date
added 2463 characters in body
Dec
15
asked Same queries, different servers, different exec plans, stats are up to date
Dec
7
answered Should dbo schema be avoided?
Dec
1
comment Failing SQL Job
@gbn, true, didn't think about that
Dec
1
answered Failing SQL Job
Nov
16
accepted What units is this metric in?
Nov
16
accepted Export data into word documents
Oct
21
comment Possible to detach a database from SQL Server while retaining file permissions?
if you find definitave proof that it's not possible, post it as an answer and then accept it.
Oct
19
awarded  Quorum
Oct
13
awarded  Self-Learner
Oct
12
answered What units is this metric in?
Oct
12
comment Possible to detach a database from SQL Server while retaining file permissions?
That is weird. What are you doing with the files after you detach a database?
Oct
12
asked What units is this metric in?
Oct
6
comment Identical(?) SQL Server 2005 machines; query takes 2sec on one, 15min on the other
i'm curious if there would be a performance difference if you went with this: select dbo.a.x, dbo.a.y from dbo.a left outer join dbo.b on dbo.a.x=dbo.b.x where dbo.b.x is null and z<=0
Oct
6
answered Identical(?) SQL Server 2005 machines; query takes 2sec on one, 15min on the other
Oct
5
revised Snapshot Replication Retention
updated retention interval
Oct
5
revised Snapshot Replication Retention
added 126 characters in body