Reputation
1,861
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
11 26
Newest
 Yearling
Impact
~119k people reached

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
Mar
5
revised Change Data Capture and the __$update_mask binary
deleted 237 characters in body
Mar
5
answered Change Data Capture and the __$update_mask binary
Mar
5
asked Change Data Capture and the __$update_mask binary
Feb
18
revised Quick way to validate two tables against each other
added 636 characters in body
Feb
18
revised Quick way to validate two tables against each other
edited body