I'd like to see the execution plan of that thing :w00t:.

I would consider having a single space out of order an issue (after the deploying has been done).

I'd strongly suggest you check out the change management articles on this site....

All valid points Sergiy, but I must informed you that you've been OWNED. Big time.

Just kidding :w00t::D:hehe::cool::):D:P;).

Better solution :

SELECT ColsList FROM dbo.TableName WHERE ColName LIKE '%' + @Param + '%'

Search this site for performance tuning. You'll get at least 200 hours worth of reading. After you've done that, start tuning a few 1000 queries. Somewhere in...

Please do not cross post, we monitor all questions. Continue this discussion here :

http://www.sqlservercentral.com/Forums/Topic406528-360-1.aspx

Please do not cross post, we monitor all questions. Continue this discussion here :

http://www.sqlservercentral.com/Forums/Topic406528-360-1.aspx

Please do not cross post, we monitor all questions. Continue this discussion here :

http://www.sqlservercentral.com/Forums/Topic406528-360-1.aspx

Yup. Watch it a few more times. It'll sink in eventually. If not, then you're not ready for that at the moment and that's alright as well.

The...

This is what I mean by fully testing the configuration; test all the operations that need to be done in the system, in the real amount they will be done...

noeld (10/3/2007)

Hehe, R E A L L Y ????

Can...

One general hint for the clustered index is when you need to a range scan (Select all data between those 2 dates). One other great candidate is when you...

:w00t:!, the only that comes to mind quickly is rewrite the damn thing. HOwever I'm sure you've considered that option and ruled it out. The only other option I...

I see all the filters in the inner join (except for the is null)...

Select w.* from webs w

LEFT JOIN docs d

ON w.id = d.webid

and w.id = '12345'

AND...

What was the problem? Your solution will surely save someone's butt someday so it would really help him if you could post the solution ;).