Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
8
Newest
 Curious
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 9 votes cast
Nov
13
awarded  Curious
Nov
12
comment Correct way to stop SQL Server (through automation)
Thanks @firasathahmed. So if only stopping/starting services; not changing passwords; there's no issue to simply using standard windows service stop/start mechanisms.
Nov
12
accepted Correct way to stop SQL Server (through automation)
Nov
12
awarded  Custodian
Nov
12
reviewed Approve Correct way to stop SQL Server (through automation)
Nov
12
revised Correct way to stop SQL Server (through automation)
added 24 characters in body
Nov
12
asked Correct way to stop SQL Server (through automation)
Oct
10
accepted Performance of checking for data in related tables
Sep
22
asked Blocking SPID has Zero Disk IO and Zero CPU Time
Sep
11
comment Restore from SQL Server 2008 R2 to SQL Server 2014 fails
Only solution is to purchase SQL (developer edition's included with MSDN), or to decrease the size of the database you're recovering (i.e. by deleting stuff you don't care about and shrinking it before taking a backup; but deleting stuff may not be a viable option).
Sep
11
comment Restore from SQL Server 2008 R2 to SQL Server 2014 fails
Per the error message, SQL Express has a size limit of 10GB, so you can't put a 40GB database there. google.co.uk/webhp?q=sql%20express%20size%20limit%202014
Aug
4
awarded  Popular Question
Mar
3
awarded  Scholar
Mar
3
accepted Length of LOB data (%1) to be replicated exceeds configured maximum %2
Jul
23
comment Performance of checking for data in related tables
Thanks @stacylaray. Is there a good way to figure out how many scans are likely to be performed aside from running queries and looking at query-plans / stats? e.g. some kind of Big O notation? I ask as I expected #4 to have more scans since all of the subqueries look like they'd be performed once for each of the results; which in the above case is pretty much the opposite of what happened. Also it would be interesting to see how this scaled with data & distribution.
Jul
22
comment Performance of checking for data in related tables
NB: also asked here: stackoverflow.com/questions/24897268/… as this spans the boundary of DBA & Programmer domains.
Jul
22
revised Performance of checking for data in related tables
edited title
Jul
22
asked Performance of checking for data in related tables
Jul
4
asked SSMS causing Event ID 4674: SeTakeOwnershipPrivilege
Apr
6
comment Why do we need to rebuild and reorganize Indexes in SQL Server
As a side question, any idea why SQL doesn't reorganise indexes in the background during low demand periods (i.e. to avoid requiring scheduled tasks or manually requesting this action)?