Quickly Determine Which Tables Need Indexes in SQL Server
A quick way to determine which tables need indexes is to use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables." Doing so shows you the tables that need indexes. Without an index, a query must scan the entire table.
Digg
del.icio.us
Newvine
furl
StumbleUpon
BlinkList
Newsvine
Magnolia
Facebook
Tailrank
Slashdot
Technorati
Google Bookmarks
Yahoo Favorites
Windows Live
Ask
