meta user
network profile
| bio | website | about.me/DavidForck |
|---|---|---|
| location | Missouri | |
| age | 26 | |
| visits | member for | 2 years |
| seen | 11 hours ago | |
| stats | profile views | 40 |
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 12 |
asked | What could cause the wrong ID to be inserted? |
|
Mar 13 |
comment |
Why is this user “Admin” created in all databases? I was going to say that it was probably in the Model database. Good job figuring it out. |
|
Mar 13 |
comment |
What alternatives exist when a table requires too many foreign keys? I have to agree with Aaron Bertrand, if your design requires you to max out the foreign keys sql server supports, it may be time to consider a redesign. |
|
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?) |
