RThomas

1,488 reputation

317

bio	website
	location	Denver, CO
	age	37
visits	member for	2 years, 1 month
	seen	yesterday
stats	profile views	180

Developing, modeling, administering, tuning, troubleshooting, extracting, transforming, and loading databases full time since 1996.

First professional assignment with databases began building CAClipper xBase applications back when a database with 2 million plus records was considered huge. Moved to FoxPro and Borland Visual Delphi in the mid 90's and then SQL Server in '98.

Have also worked with Sybase, MySQL, Oracle, Access, Multivalue Informix, Filemaker, 4D and the Microsoft BI stack.

	1,488 reputation	bio	website		visits	member for	2 years, 1 month
317 badges		location	Denver, CO		seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

27 Answers

votes activity newest

10	Retrieving row count without using Count function
8	Does SQL manage foreign key constraints in terms of Insertion?
7	How to reduce the log file size without shrinking it in SQL server
6	Will transactional replication push a CREATE INDEX immediately? Or do I need a snapshot?
6	In MS SQL how do I find out what tables have not been queried or updated in a long time?

1,488 Reputation

+5	Change data capture - how to know who made the change?
+20	In MS SQL how do I find out what tables have not been queried or updated in a long time?
+20	Retrieving row count without using Count function
+5	Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN

18 Questions

votes activity newest

10	Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
7	Capturing datetime of change in SQL Server CDC
6	SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
5	Using integrated security over VPN
4	What would cause an orphaned ##MS_PolicyEventProcessingLogin##?

48 Tags

28 sql-server × 8	10 count
26 sql-server-2005 × 6	10 select
26 sql × 4	7 query × 2
16 sql-server-2008 × 22	7 performance
11 maintenance × 2	7 database-administration