Viewing 14 posts - 1 through 14 (of 14 total)
Thankfully I was able to convince my boss to send me this...
February 22, 2017 at 3:35 am
Thanks for the suggestion. I'm going to spend a bit more time on this today and try to get a better idea of how long it will take.
December 21, 2016 at 2:52 am
It's probably worth changing the SQL Agent account temporarily to see if it will run under a different account; I would suggest changing it to the virtual account installed alongside...
June 23, 2016 at 4:57 am
Is this for a new installation? If so, have you changed the service account after completing the installation, or did you specify the one you are using during the installation?...
June 23, 2016 at 2:13 am
Microsoft have just recently announced that SQL 2014 and SQL 2016 when it is released will allow use of the developer edition of SQL Server completely free.
Developer edition is functionally...
April 8, 2016 at 5:29 am
Did you actually try to make the changes to the sa account?
Although it may let you access the dialogue to make the changes, when you try to apply them it...
August 20, 2015 at 6:48 am
Have you looked at the Windows event viewer? Usually if there is an error like this there will be something there which may provide more info as to why the...
August 20, 2015 at 6:15 am
August 1, 2015 at 3:12 am
Thank you, I appreciate the responses, although they don't really address my question.
I'm not expecting to see the page file being used, as I don't believe there is...
July 31, 2015 at 9:06 pm
This is incorrect. SQL 2012 Enterprise edition was not offered with CAL licensing. You can check this using the Licensing reference guide at: http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf
If you have...
July 31, 2015 at 8:31 am
Have a look at the permissions to the directory where the SQLAgent.exe is stored.
Default is: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn
I've had similar problems where there have been issues around that.
July 31, 2015 at 8:21 am
It looks as though the server supports NUMA, but I haven't configured anything around that. I don't really have any experience of NUMA actually, and it wasn't something that...
July 31, 2015 at 8:12 am
I have had a look over the stats for some of the indexes, though at the moment it's not hugely relevant to why I was doing this. The database in...
July 2, 2014 at 4:41 pm
Thanks. I managed to resolve the issue by importing my csv list into a table, then filtering sys.indexes to remove system indexes and any indexes included in my table, then...
July 1, 2014 at 9:16 am