Friday, January 22, 2010

Disable Desktop Search in Explorer

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/

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