Reputation
1,926
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 12 29
Impact
~137k people reached

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
Mar
5
revised Change Data Capture and the __$update_mask binary
added 93 characters in body
Mar
5
revised Change Data Capture and the __$update_mask binary
added 1 characters in body
Mar
5
revised Change Data Capture and the __$update_mask binary
added 229 characters in body
Mar
5
revised Change Data Capture and the __$update_mask binary
added 134 characters in body