PROBLEMS with your advises so far:

1 - However if I use all these methods then I will have to face RECREATING INDEXES on a new table. There are several non-clustered...

Leading space was just my finger tapping the keyboard too intensely..

typo..

so from everything I heard/read, would that be fair to conclude that option 2 is the way to go in the majority of cases?

2) where databasename ='myDBname'

and applicationname NOT...

Sorry I missed the % in LIKEs. Of course I meant wildcards..

As far as the clause with FUNCTION being NOT SARGeable - what do you mean? why not?

THANKS !!!

Would you say DMV data and Exec Plans would be enough to show the management

AFTER I apply certain optimization to a dozen of stored procedures in production server?

I mean to...

Thanks.

As far as what you said about the execution plans, <You can get the execution plan for each single statement too> --> but won't this exec plan for...

Yes. I/o, Memory, CPU intensive SPs. Identified by Profiler trace top 50 most often executed SPs with longest duration, and I started to optimize them, which included not only TSQL...

Thank you Jeff.

Great article on base-lining that you have referred to. http://www.sqlservercentral.com/articles/baselines/94656/ [/url]

1) So ideally base-lining would be an ongoing (daily) process with a job...

thank you for your feedback/insight.

So when we say that Covered Index is created for one particular SQL statement it is a relative term, right? We really mean that it...

Without looking at details/specifics,

you can try to get a 'blind' performance gain by using @Table table type variable instead of

#temporary table. You can gain performance improvement to...

If you are interested to see which ones of the most often executed SQL Statements /SPs take the longest time,

I believe it is a good idea to use Profiler Trace...

I would say Profiler is still the best, as it gives you a lot of flexibility in analyzing the collected trace data (doing such analysis via T-SQL on the trace...

Yes, found a nice solution. CTRL+ALT+D keyboard shortcut combination displays the report data window at any time. Great shortcut to remember.

Vlad

Yes, found a nice solution. CTRL+ALT+D keyboard shortcut combination displays the report data window at any time. Great shortcut to remember.

Vlad

Yes, found a nice solution. CTRL+ALT+D keyboard shortcut combination displays the report data window at any time. Great shortcut to remember.

Vlad