Tips using SQL Profiler :: Performance Workout

As a known problem, performance always fails when you don't think before start coding.

In an earlier suport I got a report that fails by timeout. Like I presume the SQL Queries was not optimeze and a lot of "SELECT *" was found.

To understand better where the problem is I used my preferred tool when I work with SQL Server. The SQL Profiler.

I got a good links to start work with it :

- Step-By-Step: An introduction to SQL Server Profiler
http://articles.techrepublic.com.com/5100-6329_11-5054787.html

And remember, always design before code!

See ya!