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.


Mar
7
awarded  Notable Question
Feb
21
awarded  Popular Question
Feb
19
accepted Find orphaned users
Feb
18
asked Find orphaned users
Feb
18
asked dbo.DTA_* tables in MSDB
Feb
18
accepted Replication and linked server security
Feb
18
accepted How can I set the index fill factor back to server default?
Feb
18
accepted Generate create script for all indexes
Feb
18
accepted Does SQL Server care about the location of accounts in Active Directory?
Feb
14
comment Adding indices to views
essentially, maybe you should be looking into a data warehouse. en.wikipedia.org/wiki/Data_warehouse
Feb
14
comment Adding indices to views
a tangential approach may be creating an etl process to cache the data. how often does the data change, what's the need for the data to be up to date? things along those lines are necessary to ask.
Feb
14
comment I have table with 17 Indexes if i add 1 more index for search in two columns
this question's a bit too open ended here for the se format. I did write an answer that should point you in the right direction though.
Feb
14
answered I have table with 17 Indexes if i add 1 more index for search in two columns
Feb
6
comment Does SQL Server care about the location of accounts in Active Directory?
@nic yes, that is what i mean.
Feb
6
comment SSRS appears to be ignoring Permissions set using Report Manager
One more thing, could you provide a screen shot of the permissions you're setting?
Feb
6
comment SSRS appears to be ignoring Permissions set using Report Manager
Do you have active directory where you're doing this? Also, are you naming the users as servername/username in SSRS?
Feb
6
comment Restore backup fails - not enough disk space
Agreed. The original database needs to be cleaned up before they have any hope of restoring that database on an express version (10gb limit on 2008+ right?)
Feb
6
asked Does SQL Server care about the location of accounts in Active Directory?
Feb
4
comment Cannot delete publication
that first thing that comes to my mind is it might be a permissions issue.
Feb
4
comment SSRS appears to be ignoring Permissions set using Report Manager
On the Home (root) folder, if you go to Properties - Security, do you see the local user account there? Is this where you set up the local user?