Viewing 15 posts - 1 through 15 (of 137 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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
April 26, 2012 at 2:50 pm
kennethigiri (4/24/2012)
jswong05 (4/23/2012)
http://www.whylinuxisbetter.net/items/defragment/index.php?lang=%5B/quote%5D
I am wondering what you are doing on SSC. Have you found a way to run SQL Server on...
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...
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...
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...
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
July 20, 2011 at 10:28 am
Viewing 15 posts - 1 through 15 (of 137 total)