Browse by Tags

All Tags » index (RSS)

Update - Rewritten for SQL 2000 - SMS 2003 - Getting information about advertisements when package or ad has been deleted by jnelson

Apparently there are enough people that still have SQL 2000 that I get hounded with questions whenever I post something that only works on SQL 2005, which...

SMS 2003 - Getting information about advertisements when package or ad has been deleted by jnelson

THE PROBLEM There are canned reports that come with SMS that let you see advertisements and the machines that were targeted and the package that was sent...

SQL Performance - Indexes and the LIKE clause by jnelson

INDEXES AND THE LIKE CLAUSE Often times, people will make the generalization that when you have LIKE in your WHERE clause it won't use indexes. The...

SQL Performance Tips - Avoid putting indexed columns inside functions in your WHERE clause by jnelson

THE PROBLEM When designing a query, it is incredibly important for performance reasons that you keep in mind what columns are indexed. The SQL engine will...

SMS Performance Tip - Reorganize the Add_Remove_Programs_DATA tables for speed by jnelson

DISCLAIMER! OK, BIG disclaimer here. This procedure is neither endorsed, nor supported by Microsoft and for small to middle size SMS deployments might...
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems