Re: most common kinds of cross-database queries

2007-08-01 Thread Amos Shapira
On 02/08/07, Darren Duncan <[EMAIL PROTECTED]> wrote: > > What do you think would be the most common scenarios of a cross-database > query? Speaking only theoretically for now but one "use case" I can vaguely imagine would be something we are working on right now: We have a large SQL Server data

Re: A note on "Programming the Perl DBI (Tim Bunce)"

2007-07-25 Thread Amos Shapira
On 25/07/07, Bob <[EMAIL PROTECTED]> wrote: Hello, I got the following error, and no way to understand what it means. The error: << Can't locate object method "pg_oid_status" via package "DBI::db" >> This is triggered by my command << $bag{$dbh->pg_oid_status} = 1; >> where I use the oid as

Re: Efficient scanning of SQL Server 2005 tables?

2007-07-17 Thread Amos Shapira
On 18/07/07, Ron Savage <[EMAIL PROTECTED]> wrote: Amos Shapira wrote: Hi Amos > Our local SQL Server/Windows/C++ guru told me that the standard way we scan > tables causes the server to practically copy the entire result set into a > temporary table on the server before fe

Efficient scanning of SQL Server 2005 tables?

2007-07-17 Thread Amos Shapira
Hello, Our local SQL Server/Windows/C++ guru told me that the standard way we scan tables causes the server to practically copy the entire result set into a temporary table on the server before feeding it to the client. He found a way to avoid this in C++ by some clever direct ODBC hacks on Wind