DForck42

953 reputation

624

bio	website	about.me/DavidForck
	location	Missouri
	age	26
visits	member for	2 years
	seen	8 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.

	953 reputation	bio	website	about.me/DavidForck	visits	member for	2 years
624 badges		location	Missouri		seen	8 hours ago

summary answers questions tags badges favorites bounties reputation activity

27 Questions

votes activity newest

8	Behavior of data in indexes based on fill factor
8	Snapshot Replication Retention
7	Tracking stored procedure usage
5	What could cause the wrong ID to be inserted?
5	Does SQL Server care about the location of accounts in Active Directory?

953 Reputation

+15	Tracking stored procedure usage
+5	Find orphaned users
+10	Why are periodic restarts required to keep my instance performing well?
+5	What could cause the wrong ID to be inserted?

26 Answers

votes activity newest

7	Is this a standard way to design a database?
5	Recommendations on creating user-objects on system database
4	Why are periodic restarts required to keep my instance performing well?
4	Should dbo schema be avoided?
4	Identical(?) SQL Server 2005 machines; query takes 2sec on one, 15min on the other

42 Tags

37 sql-server × 45	7 uniqueidentifier
19 sql-server-2008 × 29	5 sql × 4
14 sql-server-2005 × 10	5 sql-server-2008-r2 × 3
10 database-design × 2	5 event-notification
7 performance × 3	5 service-broker