Viewing 15 posts - 5,236 through 5,250 (of 6,678 total)
Steve Jones - Editor (4/27/2009)
Most of the systems I've run were rebooted less than once a quarter, some once a year without issues.
We end up restarted our servers on an...
April 27, 2009 at 3:05 pm
Instead of modifying all of the code to use a different linked server - modify the linked server to point to the new instance.
You can't do this through the GUI...
April 27, 2009 at 2:59 pm
I don't know of any way to disable the message - but, if it is that annoying then they could always script out the table definition and make the modifications...
April 27, 2009 at 2:53 pm
I believe you had to have SSIS installed on pre-SP2 SQL Server 2005 installs. Might have been SP1 that changed this - but, I don't recall.
Definitely post SP2 2005...
April 27, 2009 at 2:27 pm
I would look at WMI settings on the server and the laptop. SSMS uses WMI to connect to the server and to perform service start/stop etc...
I have seen issues...
April 27, 2009 at 2:13 pm
Okay, there are a couple of issues with your plan - but I'll get to that later. The Maintenance Plan cleanup task has several options that need to be...
April 27, 2009 at 12:51 pm
Rudy, have you seen any differences if there are more CPU's available? I have not seen a large difference between using 3 threads and 7 threads with 8 CPU's...
April 27, 2009 at 11:52 am
William,
Yes - if you have other applications running on the server - you need to size the page file according to the requirements for those applications. I have never...
April 27, 2009 at 11:09 am
liuwilli (4/27/2009)
April 27, 2009 at 10:36 am
How is the task setup? What is the value you put for the file extension? Are the backups in separate folders for each database? If so, did...
April 27, 2009 at 10:08 am
Why would you switch from simple recovery model to full recovery model to rebuild indexes? You should already be in full recovery model and performing transaction log backups on...
April 27, 2009 at 10:06 am
Because tempdb is recreated during a restart - you could delete the current tempdb files and let SQL Server recreate them during startup.
April 27, 2009 at 9:48 am
SQL Server and Agent - and any other SQL Server related services are just that - services. There is no reason to log into the server to get them...
April 27, 2009 at 9:32 am
SQL Server 2005 x64 Standard will show memory pressure issues. I am not sure where the cutoff is for it, but I have seen some installations with 8GB of...
April 25, 2009 at 9:07 am
Viewing 15 posts - 5,236 through 5,250 (of 6,678 total)