Re: [GENERAL] good sql tutorial

2007-10-04 Thread Ken . Colson
Scott Marlowe wrote: > On 10/4/07, Geoffrey <[EMAIL PROTECTED]> wrote: >> Anyone have a recommendation for a good sql tutorial? Looking for a >> book, but online would be useful as well. > > I'd recommend The Art of SQL and Joel Celko's books. None are online > that I know of, but they're afford

Re: [GENERAL] Data Warehousing

2007-09-04 Thread Ken . Colson
>I am on a Linux platform but I'm going to need some pointers regarding >the cron job. Are you suggesting that I parse the dump file? I assume I >would need to switch to using inserts and then parse the dump looking >for where I need to start from? Something that you may want to consider is dbl

[GENERAL] show connection limit?

2007-08-29 Thread Ken . Colson
I have set the connection limit of a user with the ALTER ROLE command in 8.1. Is there a way to see what the connection limit is set to for various users? Thanks, Ken