Do you have dates outside of that range??

January 1, 1900, through June 6, 2079

This is the script I used to do my first tests. I have another in progress where I have only 1 duplicate row in the 1M insert (Select ID...

I'm not sure I get your problem. Can you post sample data??

This is what I have, but you obviously would have thaught of that option, so I guess I'm...

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...