meta user
network profile
| bio | website | about.me/DavidForck |
|---|---|---|
| location | Missouri | |
| age | 26 | |
| visits | member for | 2 years, 1 month |
| seen | 16 hours ago | |
| stats | profile views | 43 |
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.
|
Jul 3 |
comment |
Generate create script for all indexes @jnk true, do you know of a powershell script for this? I've never done anything with powershell before. |
|
Jul 3 |
comment |
Generate create script for all indexes @caderoux as long as I can run it in SSMS i'm happy. |
|
Jul 3 |
asked | Generate create script for all indexes |
|
Jul 3 |
answered | SQL server indexing foreign keys, covering indexes included columns |
|
Jul 3 |
answered | How to create a summary report that contains other reports? |
|
Jun 18 |
comment |
Is there a way to use a SQL Server 2000 database in SSIS 2012? @billinkc added info |
|
Jun 18 |
revised |
Is there a way to use a SQL Server 2000 database in SSIS 2012? added 63 characters in body |
|
Jun 13 |
asked | Is there a way to use a SQL Server 2000 database in SSIS 2012? |
|
Jun 8 |
awarded | Constituent |
|
Jun 8 |
awarded | Caucus |
|
Jun 7 |
comment |
Why is the page life expectancy 0 (zero) on SQL Server 2005 weird, double checked your code on my prod server and it seems to work fine. |
|
Jun 6 |
comment |
why do SSRS reports run longer for a particular user Have you tried having the same user execute the report from a different machine using their same credentials? |
|
Jun 6 |
answered | SQL Server log shrinking Issue |
|
Jun 6 |
comment |
Recursive CTE performance Some sample data would be dandy |
|
May 14 |
awarded | Taxonomist |
|
May 11 |
awarded | Yearling |
|
May 7 |
comment |
Is Index causing timeouts? What is happening when the timeouts happen? |
|
May 7 |
comment |
Setting up users and admins with schema privileges definatley can't do this. the application calls the stored procedures by schema.procname. by moving the procs to different schemas we completley break the app, and we're getting ready to do a final push to production. hence why i'm trying to clear up security. |
|
May 7 |
accepted | Can you rename or name Reporting Services jobs? |
|
May 7 |
accepted | What is the signifigance of a fillfactor of 20? |
