doesn't the slow plan say it is copying 3.8 million rows @ 115 gig via a table spooll from the linked server?

as mentioned, without specifics, wer can only guess;

a different process smay have different ANSI settings, like ANSI NULLS, etc, which can affect the query(whatever it does).

it could be the...

Booksonline and google are great resources, but if you need an example, here's both an out...

you mean godaddy...

when i googled "godaddy SMTP host "Too many messages for this session". ", i found a couple of posts that might help;

one of them says godaddy has a limit...

found this over at stack overflow, which says there's a bit of configuring to do, but you can use 32 bit drivers with 64 bit SQL:

http://stackoverflow.com/questions/1134827/how-do-i-use-a-32-bit-odbc-driver-on-64-bit-server-2008-when-the-installer-doesn

10 down vote accepted

It turns...

you might remember there are a few other very similar posts which state that after an in place upgrade, rebuilding of statistics is an absolute requirement.

sqlfriends (5/1/2012)

---

We have a stored proc runs in less than a second on the database using SQL Management studio. But when running through the reporting services using the same...

maybe things have changed, but i had to uninstall office 32 bit completely, and then install the AccessDatabaseEngine_x64.exe so that i could connect via a linked server.

No big deal for...

SQL has a maximum of 4096 columns in a select statement.

a Single, normal(non-wide ) table can have up to 1024 columns in it...but wide tables can have 30K columns.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

an html...

two issues i see:

two different WHERE statements have a function on a datetime column...

WHERE DATEADD(day, 15, time) > GETDATE()

--and later:

AND CONVERT(DATE, recorddate) = '2012-04-25'

this requires SQL to do a...

also did you look at this long, detailed article here on SSC:

A Google Like Full Text Search[/url]

when the article came out, and i played with it, i learned a LOT.

no it's closed to us for manipulation.

you can manipulate the results with a find and replace, but you cannot change that gui script to to prompt you for an alias...

thanks for the info!

i was guessing that permissions were going to be the cause, but now i'm not sure.

when i goggled "reported a change in schema version between compile...

pawana.paul (4/30/2012)

---

Yes. Only trying to see what objects are on one instance and not the other. That is what is my requirement. Please let me know if you have better...