447 reputation
515
bio website
location Sydney, Australia
age
visits member for 2 years, 9 months
seen 2 days ago

2d
comment Change Data Capture not running when Mirror is Suspended
Our link to DR was broken overnight and CDC data wasn't processed again. Still can't find anything on Google. Might need to go to Microsoft.
Oct
9
awarded  Notable Question
Sep
12
accepted Cube Processing vs Database Processing
Sep
12
answered Cube Processing vs Database Processing
Sep
10
asked Cube Processing vs Database Processing
Aug
20
revised Change Data Capture not running when Mirror is Suspended
added 35 characters in body
Aug
20
comment Change Data Capture not running when Mirror is Suspended
@mrdenny - sounds plausible. We are running the mirror as async normally as we don't want the latency we get with sync and the CDC data works as expected. Like I said though, the Log Reader being disabled sounds plausible
Aug
20
comment Change Data Capture not running when Mirror is Suspended
I think so. We only have the mirror setup in production so it's not easy to test on demand, but the last 2 days we've paused the mirror and the last two days the cdc data didn't process while the mirror was paused.
Aug
20
asked Change Data Capture not running when Mirror is Suspended
Aug
6
awarded  Nice Question
Jul
19
awarded  Yearling
Jul
9
awarded  Popular Question
Jul
2
awarded  Curious
May
29
accepted Can connect to SQL Server 2012 via OSQL and SQLCMD but not via SSMS
May
28
comment Can connect to SQL Server 2012 via OSQL and SQLCMD but not via SSMS
I think I used the same connection type each time. I tried connecting to "computername\sqlinstancename" when using SSMS and sqlcmd and osql. Just double checked and named pipes is not enabled on that instance
May
27
answered Can connect to SQL Server 2012 via OSQL and SQLCMD but not via SSMS
May
27
asked Can connect to SQL Server 2012 via OSQL and SQLCMD but not via SSMS
May
10
accepted Any advantage of having a second index with included columns on a primary key?
May
8
comment Any advantage of having a second index with included columns on a primary key?
Thanks @JonSeigel. If you wanted to add that as an answer I'd accept it.
May
7
comment Any advantage of having a second index with included columns on a primary key?
@JonSeigel can you explain further? Why is it useful for scans but not seeks?