422 reputation
415
bio website
location Sydney, Australia
age
visits member for 2 years, 7 months
seen Aug 22 at 1:58

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?
May
7
comment Any advantage of having a second index with included columns on a primary key?
SQL will always use the smallest index that satisfies a query. If Index 1 and Index 2 both satisfy the query but index one is smaller then it will use that. This doesn't necessarily mean we should have both?
May
7
revised SQL Server Reporting Service dynamically change connection string
added 21 characters in body
May
7
asked SQL Server Reporting Service dynamically change connection string
May
7
asked Any advantage of having a second index with included columns on a primary key?
May
5
comment Change version number of maintenance plan package
Still interested in an answer, but we're going to recreate the maintenance plans in SSMS 2012 (and not use 2014 for it again)