Pretty sure sp_OACreate is limited to an NVarchar(4000) max parameter;

I had written something in SQL 2000 which harvested web pages, and had to grab slices of the results from my...

well, the part i was trying to talk about was the screenshot below; see the difference for the "good enough plan found" vs the other that did not find a...

i had to use winmerge to be sure, the two files you posted are identical; could you have copied the same plan as two different names?

Cadavre I love how you add the million row test harnesses to your examples...

I may start adding that to some of my posts as well in the future.

Thanks buddy!

mikes84 (11/4/2011)[hrLowell,

So are you saying that this type of comparison, row over row (as in the EXCEPT clause and my second example):

Table 1 fields

-------------

Table 2 fields

is usually better than this...

in 2008 and above, i think the expectation is to start switching over to CLR;

here's the CLR equivilent of xp_GetFileDetails:

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.IO

Namespace Enterprise.SqlServer.Server

...

i think you want to look at the EXCEPT operator;

if all the columns are the same, it might look like this:

--find what doesn't match from Table2

SELECT PK,ColumnList FROM Table1

EXCEPT

SELECT PK,ColumnList...

A couple of Grant Fitychey's presentations he did on execution plans might be relevant;

as i remember it, the key to look for is the property "Reason For Early Termination of...

chandraa.bollineni (11/4/2011)

---

Hi,

Thanks for your reply.

I already checked in this way and it's already fixed those settings like both failed and successful logins.But i am not able to see what are...

would they be asking you to use a DMV like sys.dm_exec_sessionsto get the column host_process_id?

I think that would require querying all four instances, right?

for example, ran Windows Task Manager and...

Jack this was a double post;

In another thread we tracked down the issue:

http://www.sqlservercentral.com/Forums/FindPost1200033.aspx

sure but you'll have to make sure you always wrap it in brackets when refering to it:

WHERE [Fixed/Float/Step (Interest Rate Type)] = 42

to avoid that, you want to go witht...

you'll want to script the table out from the source, including indexes, and create it on the destination database.

then you can use the import/export wizard,and change the step that says...

sturner (11/3/2011)

---

I'm not aware of any file size limitation for importing data into SQL server.

Things you can do to make the import operation as efficient as possible:

1) put the database...

glad you got it fixed!

sometimes the "obvious fix" for an issue is, well, not really that obvious.