How to disable desktop search in explorer (still works in outlook), and default to companion search.
Open RegEdit (hit Start > Run then type ‘regedit’). Go to the following node:
HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS
Then double-click on ‘ShowStartSearchBand’ and set the value to ‘0′. Close that and you’re done, the next time you click ‘Search’ in explorer, the old, reliable search companion will appear. This applies to operating systems before Windows Vista
http://lee.org/blog/2009/04/25/how-to-disable-windows-search-when-searching-windows-explorer/
http://www.johnsadventures.com/archives/2006/11/how_to_default_to_search_companion_with_windows_de/
Friday, January 22, 2010
Wednesday, January 20, 2010
SQL Server the memory hog
So on my development machine, where I'm keeping everything local. SQL Server 2005 often uses up too much memory,(the other contender is VS) and it starts paging, and everything ends up in a crawl...
the quick and easy fix:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'max server memory', 4096;--Set this to some reasonable amount, like 1GB
GO
RECONFIGURE;
GO
It roughly caps the memory usage of SQL server.
The details:
http://msdn.microsoft.com/en-us/library/ms178067.aspx
http://msdn.microsoft.com/en-us/library/ms180797.aspx
the quick and easy fix:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'max server memory', 4096;--Set this to some reasonable amount, like 1GB
GO
RECONFIGURE;
GO
It roughly caps the memory usage of SQL server.
The details:
http://msdn.microsoft.com/en-us/library/ms178067.aspx
http://msdn.microsoft.com/en-us/library/ms180797.aspx
Subscribe to:
Posts (Atom)