Search this site for parameter sniffing, you'll find the info he's talking about.

Anyways can you post the rest of the code, this is where you'll get the biggest performance boost...

SET SHOWPLAN_TEXT ON

GO

Select id, name from dbo.SysObjects

GO

SET SHOWPLAN_TEXT OFF

>>>

StmtText ...

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=197371

Would've love to see the face of your partner when you pulled the wrong cord .

Or you can always rename the table to users and avoid the problem altogether.

Check the missing tables permissions. Maybe there's an hidden deny on the table.

I'm assuming that the new rebuilt server was shut down here... did you have to rebuild it again ??

I can only guess that the calculated part is done client side... but that doesn't make much sens. Maybe the set options are different on query analyser (can't go...

I'm stil holding my breadth .

Back to the subject : Who the h3ll answered google on this one?

Did they think this was another...

That's exactly what I said... only in proper english . In the case of such an index, if you use only the...

Can you catch both execution plans and post them here?

I suspect that the server has to do a cast of some sort to apply a where condition, forcing an index...

Can someone post the ddl of one of those tables?? would like to laminate it or something .

Sorry man, can't go over 200 either (not all that useless either). I just can't imagine having 1024 columns in a table.

hm ... i read something about this somwhere. It says if your first condition match with your first column in your index, it will fasten the speed to build the...

As promised I have to agree with Noeld's solution .