Viewing 15 posts - 15,676 through 15,690 (of 18,923 total)
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...
July 6, 2005 at 7:00 am
SET SHOWPLAN_TEXT ON
GO
Select id, name from dbo.SysObjects
GO
SET SHOWPLAN_TEXT OFF
>>>
StmtText ...
July 6, 2005 at 6:57 am
Please do not cross-post, we monitor all boards.
Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=197371
July 6, 2005 at 6:56 am
Would've love to see the face of your partner when you pulled the wrong cord
.
July 6, 2005 at 6:41 am
Or you can always rename the table to users and avoid the problem altogether.
July 6, 2005 at 6:39 am
Check the missing tables permissions. Maybe there's an hidden deny on the table.
July 6, 2005 at 6:29 am
I'm assuming that the new rebuilt server was shut down here... did you have to rebuild it again
??
July 6, 2005 at 6:25 am
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...
July 6, 2005 at 6:17 am
I'm stil holding my breadth
.
Back to the subject : Who the h3ll answered google on this one?
Did they think this was another...
July 6, 2005 at 6:11 am
That's exactly what I said... only in proper english
. In the case of such an index, if you use only the...
July 5, 2005 at 9:52 pm
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...
July 5, 2005 at 9:50 pm
Can someone post the ddl of one of those tables?? would like to laminate it or something
.
July 5, 2005 at 9:47 pm
Sorry man, can't go over 200 either (not all that useless either). I just can't imagine having 1024 columns in a table.
July 5, 2005 at 8:47 pm
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...
July 5, 2005 at 8:45 pm
As promised I have to agree with Noeld's solution
.
July 5, 2005 at 8:40 pm
Viewing 15 posts - 15,676 through 15,690 (of 18,923 total)