I just tested this for proof of concept;

the idea here is to loop through all records in a table via a datareader and write each binary object to disk; in...

TSQL is the wrong tool for this; TSQL's really designed for set based information, and passing it as recordsets/datatables to an application layer.

TSQL's not designed to be writing to...

not sure what you mean by that... a data source is just a data source.

maybe you mean the other...

On SQL Server the order of your joins doesn't matter, because query engine will reorganize JOIN order depending on statistics for indexes and other things.

To prove it to yourself, what...

one thing you could grab a free cityname/state/zipcode database off the web(42K rows or so) and join it to your data on city/state/zip and see what doesn't match based...

just having a login gives you read rights to some master tables and the ability to create #tmp tables; that's perfectly normal.

you do not even need to be a user...

I'm just like you...i used to have a Dell , upgraded to an HP win7 64 bit with an I5 processor & 4Gigs , and have had tons of hardware...

another obvious fix would be to simply copy all the files form 140 folders to a single folder, and use the example i gave against that one folder.

I presented an idea and example to get you part of the solution. I thought it would get you started...you really didn't provide anything concrete as far as true requirements.

it...

is your DNN instance local, on your network, or on some shared hosting server like ihostasp? I know my shared hsoting sometimes bogs down, but it's hard to diagnose a...

here's an example i like to post using BULK insert. you can do this via SSIs as well, but it's a different technique.

in my example below, i have 4 known...

note: thread is 4 months old.

ok, i've seen people knee jerk on things like that...

You could mask the CASE statement as a SELECT (or JOIN it to your other data) like this:

/*--Results

(No column name)StartParamEndParam

DailyNULL2011-04-13 14:44:10.230*/

DECLARE...

how about nslookup mail.yourserver.com to see what the DNS reverses to, or a ping mail.yourserver.com and see the address it's going to;

why do you need it's IP vs the DNS...

ok actually, I believe this shows you some of the info specific to a linked server:

SELECT *

FROM ::fn_dblog(NULL, NULL)

where [allocUnitName] IN('sys.sysxsrvs.cl','sys.syslnklgns.cl')

but without a way to tie it to a user,...