1,736 reputation
725
bio website
location Denver, CO
age 39
visits member for 3 years, 5 months
seen Sep 27 at 19:49

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.


Mar
8
comment Delete a variable number of records by a chronological order
Also, I was trying to get around deprecation with the sub select but it's a nil issue now. Thanks again.
Mar
8
accepted Delete a variable number of records by a chronological order
Mar
8
comment Delete a variable number of records by a chronological order
Apparantly I didn't get the memo about using parenthesis. Thank you SQL2005. Awesome.
Mar
8
revised Delete a variable number of records by a chronological order
deleted 9 characters in body
Mar
8
asked Delete a variable number of records by a chronological order
Mar
7
revised Change Data Capture and the __$update_mask binary
deleted 29 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 34 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 66 characters in body
Mar
7
comment Change Data Capture and the __$update_mask binary
Check out my NEW answer before you do. As cool as the CLR is... we found an even better way. Good luck.
Mar
7
accepted Change Data Capture and the __$update_mask binary
Mar
7
answered Change Data Capture and the __$update_mask binary
Mar
7
revised Change Data Capture and the __$update_mask binary
added 3 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 107 characters in body
Mar
7
revised Change Data Capture and the __$update_mask binary
added 258 characters in body
Mar
6
accepted TSQL DateTime DataType - fractional seconds vs milliseconds
Mar
6
comment TSQL DateTime DataType - fractional seconds vs milliseconds
Its turning out to be a "taking their word for it" problem on my end with the vendor proc. They are using the LSN time mapping functions related to change data capture which DO allow < instead of =< calls. So, we'll be fixing code. msdn.microsoft.com/en-us/library/bb500137.aspx
Mar
6
comment TSQL DateTime DataType - fractional seconds vs milliseconds
If the range was in our own code that would be what we would do but we are passing to other procs that only take datetime for range and are inclusive on both ends
Mar
6
asked TSQL DateTime DataType - fractional seconds vs milliseconds
Mar
6
revised Capturing datetime of change in SQL Server CDC
changed data type of approach from datetime to datetime2
Mar
5
revised Change Data Capture and the __$update_mask binary
added 24 characters in body