sql server data mining: Hi Everyone,

I'm new to the SQL Server world. I am looking for a tool similar to SQL
navigator in Oracle, that will optimize Sql queries for me.
Any suggestions?

- SM

I personally look at

1. Profiler to discover - Duration, Read, Writes, CPU, Statement
2. Estimated Execution Plan - Show me whether a Table Scan/Index Scan etc
is being done
3. Perfmon - things like Cache hits/recompiles
4. Various SET statements
5. As a last resort - The Index Tuning wizard, although this is no
substitute for knowing your data and how it is used.

My £0.02

I am not sure that all the groups you posted to are relevant for this
Question.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]