Browse by Tags

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?

Published 30 October 7 10:41 PM | SSQA.net

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results...

Filed under: sql server, performance, indexes, services, hotfix, planning, service pack, best practice, testing, plan guide

"Allow Indexing Service to index this disk for fast file searching"

Published 25 July 7 3:3 AM | SSQA.net

I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to "Find...

Filed under: sql server, indexes, microsoft, services, windows, sql express, xp, file search, 2003