402 reputation
414
bio website
location Sydney, Australia
age
visits member for 2 years, 6 months
seen Jul 28 at 1:44

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)
May
2
asked Change version number of maintenance plan package
May
1
awarded  Notable Question
Jan
21
asked How to make SSAS Commit Write take less time
Jan
15
awarded  Tumbleweed
Jan
13
accepted How to create a server alias in SQL Server 2012