Viewing 15 posts - 41,806 through 41,820 (of 49,571 total)
Jean-François Bergeron (1/12/2009)
From what I read in the plan, the only predicate it uses is the first Part : Like 'A/P%', how about the 's' that is after?
There should be...
January 12, 2009 at 1:00 pm
Ariadne (1/12/2009)
Gila: This is an OLTP system if that helps any. Found out the server have AMD 2-socket 4-core 2210 mhz processors resulting in 8 CPUs total.
If it's OLTP then...
January 12, 2009 at 12:52 pm
Try it and see.
If you have a table with an index on a string column, you run a query of that form and check the execution plan, you'll see exactly...
January 12, 2009 at 9:35 am
Jackal (1/12/2009)
Thanks for the response, the SQL logs show the error occuring at 6.01pm
Can you post the full message that was in the log?
Anything in the windows event logs?
January 12, 2009 at 9:26 am
Jean-François Bergeron (1/12/2009)
How does a like react?
If there's a wildcard, it's treated the same way as a between.
LIKE 'A%' becomes >= Scalar Operator('9þ') AND < Scalar Operator('B')
How does a greater...
January 12, 2009 at 9:23 am
With that row count, the noncluster's probably only 2 levels deep. As the table gets larger, you'll probably be able to see a small IO count difference between the two...
January 12, 2009 at 9:12 am
I'm debating what to replace my stolen 17" with. Despite the weight, I'm probably going to get another 17" laptop. I don't travel all that much and when I do,...
January 12, 2009 at 9:08 am
mhaskins (1/12/2009)
January 12, 2009 at 9:04 am
Jeff Moden (1/9/2009)
January 12, 2009 at 9:01 am
SQL has no concept of timeouts (other that lock timeouts). A timeout is a client application setting that controls how long the client app is willing to wait the server...
January 12, 2009 at 8:54 am
Data volumes
Memory
Disk speeds and usage
CPU speed
database activity
other server activity
Different indexes or statistics
January 12, 2009 at 8:45 am
I don't think you'll be able to do it in one step. SQL 2008 won't allow a database that's in compatibility mode 7, which is what a SQL 7 database...
January 12, 2009 at 8:44 am
winston Smith (1/12/2009)
what pushes the optimizer toward one index over the other if both are providing equal results?
Probably it thinks that the index that has the include columns will have...
January 12, 2009 at 8:39 am
Unlikely. It's not the 32 bit/64 bit. It's that you're trying to mirror between two different versions of SQL.
You can try and set it up, but I doubt it...
January 12, 2009 at 8:34 am
Viewing 15 posts - 41,806 through 41,820 (of 49,571 total)