Large data isnt necessarily bad or slow. Keep the table narrow, use the smallest data types that will work and always normalize. Beyond that, decent indexes are all you need....

I would expect the overhead of calling them to be minimal compared to the work they would be doing. Still, every round trip hurts (bandwidth) and it starts to add...

ADO is definitely the way to go, use the stream object rather than the old getchunk method.

Andy

Been a while since I looked at that part of it - as I recall you need to have the login defined on the target and pass the userid/pwd as...

I see nothing wrong with temp tables when used wisely. Certainly Steve's idea of a permanent table and a spid can often achieve the same thing. Another option would be...

It just runs on whatever schedule the back up is - I havent gone the extra mile to reset it immediately upon a service restart. Probably should have, but have...

For now, aliasing is the only way to resolve it. I'd say this is the one case where aliasing makes sense, regardless of MS docs.

Andy

If you store the user that makes the modification in the table, then you could use a filter. One simple option might be to use a trigger on the table...

I dont think there is any reason you cant use DMO in your app - should qualify for redistribution. Still, you can copy a role pretty easily in TSQL. Basically...

Usually when a proc returns worse results than a dynamic query it means that the compiled plan is bad - either because the statistics are out of date or the...

Seems to be a pretty good method to me. Works every time. Could you do it using TSQL - sure. To me the methods are equal, it's like arguing that...

I use SQL-Compare from Red-Gate to generate a script that will apply the differences. Easy, software is fairly inexpensive. I've got a review posted.

Andy

I'll have to show my ignorance here, having not yet gotten around to Oracle for a spin - you "cant" DTS data and/or structures from SQL to Oracle? Why not?...

Im not aware of a way to do it directly. You can do it by writing the data or parameters to either a table or a file that the next...

SQL will release memory as long as it's not configured as fixed. But that should be on the server, not the client. If you're not releasing memory on the client...