is the new 2008 server an express version? is it a defaul instance or a named instance?

have you been able to connect to it before?

have you eliminated any networking issues...

the error's pretty clear. the temp table you are inserting into doesn't match your select *.

either create a table explicitly for your select *, or you have to identify the...

what a great job posting everything we might need; thank you for the actual execution plan!

i see a few places where the statistics are a little off; usually an order...

also express editions don't accept allow remote connections by default; you'll need to right click on the server in SSMS, go to Properties,a nd then Connections:

is there a clustered index, maybe on customer_id? can you give us the actual CREATE TABLE definition so we don't have to guess?

the actual execution plan, saved as a .sqlplan...

post the actual execution plan you looked at and let us peer review it with you;

trying to guess at performance from pseudo code won't get much other than guesses.

what are...

i ran the provided data thru my data formatting macro so we can have sample definitions, but we are still waiting for indexes and actual execution plan, which will tell...

form some article i wrote: this is just one way to do it, there are other techniques as well, ig you search SSC, there was another recent thread on the...

on the dbserver, are there any other services going on in it is it doing Exchange as well as SQL, or web hosting?

does the server also host, say, the company's...

if you look at edmunds.com, they have a typical search fro autos/old and new; i would avoid allowinging raw text/data entry for fields if possible; much easier to use predefined...

i've always done this with the user interface/web page building a dynamic SQL;

something like this (assuming all data entry comes from drop down lists, and vb.net as far as syntax:

...

you'll need to edit or rebuild your plan, i think.

I just created a new main plan, and when i look a tthe details, depending on how you set it up...

kramaswamy (7/11/2011)

---

I'm curious, why is it that using UNION instead of OR makes for performance increases? For most situations like this, the query optimiser is usually smart enough to do...

this seems to work for me:

SELECT

SUBSTRING(text150,1,60) AS text60_1,

SUBSTRING(text150,61,60) AS text60_2,

SUBSTRING(text150,121,60) AS text60_3

FROM YourTable

SELECT

SUBSTRING(text150,1,60) AS text60_1,

SUBSTRING(text150,61,60) AS text60_2,

SUBSTRING(text150,121,60) AS text60_3

FROM (SELECT 'EG

SABRE a CIRCUIT BREAKER...

I'm pretty sure it's the OR.

with a single value, it can do a SEEK, but with the OR, it has to scan to check the values that don't match the...