Viewing 15 posts - 1 through 15 (of 138 total)
Most likely the path is not accessible to the service account running the SQL server agent ... it is not just the SQL login to the database you need to...
James Horsley
Workflow Consulting Limited
December 1, 2015 at 5:14 am
Crucial have a compatibility tool that will list modules with guaranteed compatibility - from that it looks like the T420s only supports 8GB total as 2x4GB
DDR3 PC3-12800, DDR3 PC3-10600, DDR3...
James Horsley
Workflow Consulting Limited
March 27, 2014 at 11:24 am
Sid Childers (2/14/2014)
What do you (and others) think is a minimum amount of RAM to make hosting a VM or two viable?
IMHO, at least 8gb RAM. 16gb is optimal,...
James Horsley
Workflow Consulting Limited
February 17, 2014 at 6:45 am
I still haven't gotten to the point where I don't install anything in the base layer operating system, but I hope to get there at some point.
I mainly don't install...
James Horsley
Workflow Consulting Limited
February 14, 2014 at 8:25 am
I have been using VM's for years now - MS ActionPack is a good alternative to full MSDN for this. I do a lot of Visual Studio development and have...
James Horsley
Workflow Consulting Limited
February 14, 2014 at 5:17 am
You might see something in the event logs (esp Application & Security logs) on the SQL server that hints at why it failed ... as for restart of firewall did...
James Horsley
Workflow Consulting Limited
January 2, 2014 at 1:19 pm
Are you able to connect using ISQL or equivalent from the same client machine? As for protocol make sure TCP/IP is enabled in the SQL Server configuration manager, server...
James Horsley
Workflow Consulting Limited
January 2, 2014 at 1:06 pm
Big change is probably the OS Win 2003 -> Win 2012 (change of SQL Server may have compatibility issues but they are more likely to show after connect because...
James Horsley
Workflow Consulting Limited
January 2, 2014 at 10:06 am
YSLGuru (4/27/2012)
SO how best to get rid of the SQL fragmentation?
Reindex all the clustered indexes on all tables. But make sure your db is big enough to allow this because...
James Horsley
Workflow Consulting Limited
April 27, 2012 at 10:38 am
Does the fragmentation on the drive that your database’s data file is hosted on go with the database as it is backed up and restored elsewhere?
Rather simplisticly:
Assuming you are doing...
James Horsley
Workflow Consulting Limited
April 26, 2012 at 2:50 pm
kennethigiri (4/24/2012)
jswong05 (4/23/2012)
Just to clarify there are differnt operating systems:http://www.whylinuxisbetter.net/items/defragment/index.php?lang=
I am wondering what you are doing on SSC. Have you found a way to run SQL Server on Linux perhaps?
Actually...
James Horsley
Workflow Consulting Limited
April 24, 2012 at 8:19 am
Does Sysinternals require much free disk space?
At the end of the day to fully defrag a file is going to need quite a lot of free space whatever tool you...
James Horsley
Workflow Consulting Limited
April 22, 2012 at 5:58 am
Once again I have to recommend SysInternals free contig command line tool - if your SQL files are in or below e.g. E:\SQL_DATA you can use command
contig -a -s E:\SQL_DATA
to...
James Horsley
Workflow Consulting Limited
April 21, 2012 at 9:50 am
You might want to consider using SysInternals (no part of Microsoft) contig to defrag. This is a free command line tool but allows you to specify a single file to...
James Horsley
Workflow Consulting Limited
April 21, 2012 at 9:35 am
Maybe this will help
http://blog.mattmags.com/2007/06/30/accessing-32-bit-dlls-from-64-bit-code/#more-355
James Horsley
Workflow Consulting Limited
July 20, 2011 at 10:28 am
Viewing 15 posts - 1 through 15 (of 138 total)