1,161 reputation
1837
bio website about.me/DavidForck
location Missouri
age 27
visits member for 3 years, 8 months
seen yesterday

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.


1d
comment MySQL Count where all conditions evaluate to 1
@user57391 I don't knwo what you want me to see
Jan
26
comment MySQL Count where all conditions evaluate to 1
how much data is this running on? Also, are there any indexes on the table?
Jan
26
comment how to check whether Oracle database is accessed or not?
This is a rather empty answer. Could you add more to it to make it more helpful?
Jan
15
comment Database structure for hierarchical quiz?
this doesn't help you writing the code, but tools such as Survey Gizmo and Survey Monkey can do this for you, if that's an option.
Jan
15
comment Save multiple SQL jobs in single files
Are you needing a single file for each server's jobs, or a single file for ALL of the jobs on all of your servers? Also, what do you intend to do with this?
Jan
13
comment High CPU in SQL Server supporting SharePoint databases while running FAST search crawl
@DaniSQL i recommend putting your last comment as the answer to your question and accepting it.
Jan
9
comment Difference in number format (comman and dot) on SSMS and SSIS
i have a feeling it my do with the language settings of either SSIS or whatever you're opening the flat file with, but beyond that I'm not sure.
Jan
9
comment Difference in number format (comman and dot) on SSMS and SSIS
What do you get when you actually export the data to the flat file? Dot or comma?
Jan
9
comment Difference in number format (comman and dot) on SSMS and SSIS
How are you trying to display this in SSIS? Do you mean reporting services?
Feb
7
comment Is there a way to use a SQL Server 2000 database in SSIS 2012?
@Zane Ehh, we've finally gotten rid of it. Now to update all the things.
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 i didn't include it, but there were messages in the app log that explicitly stated "backup of database x failed".
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 scheduled sql server maintenance plan.
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 yes, all databases. yes, it works at toher times, but seems to always fail on sundays.
Apr
29
comment What could cause the wrong ID to be inserted?
Interesting. I am going to look into this.
Apr
26
comment What could cause the wrong ID to be inserted?
yes, the first one sets the id to 0, so when the next record is inserted sql server takes the current id, adds 1, and gets 1. the next one the first id i would get is 2.
Apr
24
comment What could cause the wrong ID to be inserted?
@jnk we are not inserting data into identity columns anywhere in the application.
Apr
16
comment Prevent users from using power pivot excel connections to a database
Also, @kin, power pivot shows up with the application name "Microsoft Office 2010". I set it up to block anythign with "Office" and it seems to work. Testing it out with my boss now.
Apr
16
comment Prevent users from using power pivot excel connections to a database
well it was my boss that was inquiring about this, he fould the permission hole. I don't want users connecting to my oltp databases unless it's through an application.
Apr
12
comment What could cause the wrong ID to be inserted?
@AaronBertrand very rarely, mainly when we need to clear out the data in a database after testing has been done. Once a database hits production we don't clear the data.
Apr
12
comment What could cause the wrong ID to be inserted?
I edited my question to include that my table already had data in it when i deleted the data.