Skip to main content
Database Administrators
RThomas's user avatar
RThomas's user avatar
RThomas's user avatar
RThomas
  • Member for 13 years, 4 months
  • Last seen more than 1 year ago
  • Denver, CO
Profile Activity
Stats
3,406
reputation
425k
reached
29
answers
23
questions
Communities
View all
About

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.

Badges
View all badges
6
gold badges
29
silver badges
48
bronze badges
Top tags
View all tags
44
Score
7
Posts
13
Posts %
41
Score
23
Posts
44
Posts %
34
Score
18
Posts
35
Posts %
25
Score
2
Posts
4
Posts %
15
Score
6
Posts
12
Posts %
11
Score
5
Posts
10
Posts %
Top posts
View all questions and answers
question
43
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
Jan 28, 2013
answer
17
Retrieving row count without using Count function
Jul 14, 2011
question
15
Quick way to validate two tables against each other
Feb 7, 2013
answer
15
What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?
May 10, 2011
answer
13
Change Data Capture and the __$update_mask binary
Mar 7, 2013
answer
12
SQL Server: index creation date
May 13, 2011
answer
11
Does SQL manage foreign key constraints in terms of insertion?
Oct 17, 2012
question
11
Change data capture - how to know who made the change?
Feb 4, 2013
question
11
Change Data Capture and the __$update_mask binary
Mar 5, 2013
answer
10
Will transactional replication push a CREATE INDEX immediately? Or do I need a snapshot?
Sep 8, 2011
Top network posts
View all network posts
75
T SQL merge example needed to help comprehension
70
SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE
45
SQL: Unique constraint when column is a certain value
44
Work appropriate Stack Exchange ads on Stack Overflow
32
SQL Server variable scope in a stored procedure