My sympathy for your problem. but it is impossible to make any recommendations from just looking at this one query. There are many details that need to be considered before...

SQLRO (6/29/2011)

---

Yes. I did exactly that. It took 2.51 hrs to return 150K rows. I think it also depends on what I select in output list. I think selecting only...

If it were me I would create an index on col1 and the ID (covered index) on both tables and see how that works. Other than that, I think...

Cool, but other people actually have to spend more time working than posting. 😉

If you have so little faith or trust in your DBA then you should find one you can trust. Trying to implement the philosophy you are proposing is silly...

Those ISCSI SANs need to be configured carefully. Each LUN should have multiple channels configured. Also, I have seen some types of hardware not work right with some other brand...

10,000 rows... No way I'd be doing separate inserts via ODBC. I would explore alternate methods.

Push the rows over to thew remote server and then run a bulk...

How many actual rows do you need to insert?

If you are talking about hundreds... or more than perhaps there is a bulk insert equivalent for that server that will be...

mikes84 (6/23/2011)

---

Sean, method 1 was 1 minute, 32 secs. The remote server is IBM Unidata. Files in that database have been "SQLized" and are available as tables through the ODBC...

You can't use CR/LF in the command line... just semi colons.

It will make a very long string, or you can build the string in a series statements like:

set @sql =...

yes, separate the statements with semi-colon:

EXEC('INSERT INTO Table (Name) VALUES ('Mike'); INSERT INTO Table (Name) VALUES ('Bob')') AT RemoteServer

You need to define a dummy column to handle the first quote.

for this input text file:

KEYWORDS~VISIT_HIGH~VISIT_LOW~VISIT_NUMBER~SEQNO

"xw6000"~"100005250290113"~"45071774156593787"~20~1

"xw6000"~"100005250290113"~"45071774156593787"~20~3

"non%20system%20diisk"~"100005250290113"~"45071774156593787"~20~11

"non%20system%20disk"~"100005250290113"~"45071774156593787"~20~12

"hp compaq dc7600 sff"~"1000108583"~"2751861534"~1~2

Your format file should be something like thid (haven't tested it)

10.0

6

1 SQLCHAR...

I use xp_fileexist It is probably undocumented (which will freak out some purists) but it works well and is probably used by a number of underlying SQL Server processes...

when you created those two test databases did you create them the same size (size enough for the 50000 insert rows) or did you let them auto grow... and which...

SQL servers implementation is pretty good although it has no real turn-key management solution (yes, it provides some infastructure) and the exact encryption result can not be reproduced external to...