1,088 reputation
835
bio website about.me/DavidForck
location Missouri
age 27
visits member for 3 years, 6 months
seen 5 hours ago

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.


Jan
2
asked Job Schedule view
Dec
28
comment SQL Server job failure
have you looked to see if anything else is running at the same time as the failure?
Dec
16
comment Same queries, different servers, different exec plans, stats are up to date
Well i've broken the remote quries out to dump into a temp table, and it's working better than it was. This was working before though, and I still want to know why it's not working now.
Dec
15
revised Same queries, different servers, different exec plans, stats are up to date
added 66 characters in body
Dec
15
comment Same queries, different servers, different exec plans, stats are up to date
@gbn yes they are the same @@version
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?