It's difficult which ever way you do it,  but the showplan text is the easiest method to post a plan. I normally start with graphical plans as it's easy to...

I generally don't like to see spools but it's a matter of scale - did you find it because the query runs poorly, in which case you need to make...

Always go full 64bit if you have that option. I've seen postings that suggest running 32bit SQL on 64bit o/s has a few performance issues ( why you'd want to...

I might suggest a T SQL Training course.

Welcome to query tuning - you've answered your own question - using a temp table is better so do it that way < grin >

( please don't use select * ...

I'd love to know where the amazing advice about only having a clustered index on an identity comes from !!! God help us!!

I would hope that each table has a...

with due respect I think you're missing the point. To use an indexed view to tune a query you don't then add the view in the query - the idea...

I've been here and the solution may take some time. You can check the procedure cache to see your plan being reused ( or not ) the different SET options...

absolutely!

Given an ideal situation I prefer to have all my mdf and ldf files on the same ( seperate ) drive arrays, including the system databases, makes things tidy. Tempdb is...

You can't use order by statements in a view ( not sure if this is part of ANSI standards but I think so ), a bug within sql 2000 allowed...

Sorry, there's no magic pill, I've been doing this around 14 years now, performance and optimisation is so much a case of "it depends"  sadly most of us learn by...

when views contain joins and the view becomes part of a join then sometimes things don't work out quite as you might expect. for a simple view there's no difference.

cool! It's fun extracting all this stuff isn't it????  In profiler you need to choose events, performance, show plan statistics and in the data make sure you include the binary...

I suspect you may have a serious misunderstanding of some SQL basics. Be aware that linked server queries can exhibit some very unfriendly habits - you're better off executing remote...