IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

Now viewing page 7 of 25
[Prev] 1 ... 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 ... 25 [Next]
     Indexes and primary keys - redundant? - (tablizer) - (9)
         I can't recall every having an index on the primary key - (jbrabeck)
         As I understand it - (tuberculosis) - (1)
             It's definitely the case with Oracle. -NT - (Meerkat)
         The Primary Key is an Index. - (ChrisR)
         Conceptually no, in practice yes - (JayMehaffey) - (3)
             Relational theory does not address indexes - (tablizer) - (2)
                 Indexes are just tables.... - (ChrisR) - (1)
                     Re: just tables. - (mmoffitt)
         Check the index list. - (static)
     anyone with oracle know what these are? - (boxley) - (26)
         You need em. - (folkert) - (1)
             lab box, my care and feeding only - (boxley)
         If memory serves me correct. - (ChrisR) - (8)
             ICLRPD (new thread) - (drewk)
             well I guess I know what Ill be doing the rest of the day - (boxley) - (6)
                 Live and learn. - (ChrisR) - (1)
                     no problem, I needed to knock it down any way - (boxley)
                 My rule on unknown files - (SpiceWare) - (3)
                     disk at 100% ripem out then learn something -NT - (boxley) - (2)
                         Compress elsewhere, then learn later. -NT - (ben_tilly) - (1)
                             *GRIN* -NT - (imric)
         Yes - (broomberg) - (14)
             nope only one :-) - (boxley) - (13)
                 You CANNOT use one from a different box - (broomberg) - (12)
                     rm -r oracle - (boxley) - (11)
                         The tnsnames will be wrong - (broomberg) - (10)
                             tnsnames on all boxes point to localhost - (boxley) - (9)
                                 OK -NT - (broomberg)
                                 You might find this helpful - (broomberg) - (7)
                                     thanks! bookmarked -NT - (boxley)
                                     backup and running 4hrs to figure out - (boxley) - (5)
                                         Hmm - (broomberg) - (4)
                                             yabut does your user $ORACLE_HOME - (boxley) - (3)
                                                 Yup - (broomberg) - (2)
                                                     but if oracle user uses - (boxley) - (1)
                                                         Maybe - (broomberg)
     oracle remote DB access - (boxley) - (2)
         I thought if it wasn't in tnsnames you couldn't get there, - (Meerkat) - (1)
             Supposedly you can - (admin)
     Simple SQL look-up turns out hairy - (tablizer) - (51)
         I awalys hated SQL based batch updates - (broomberg) - (12)
             Let's bring back FoxPro! - (tablizer) - (11)
                 Silly person you - (broomberg) - (10)
                     Preach! -NT - (drewk)
                     63.472% Disagree - (tablizer)
                     Real world example - (broomberg) - (7)
                         I am not sure what your point is - (tablizer) - (6)
                             It's been done already - (broomberg) - (5)
                                 Or PL/SQL, or TransactSQL, or... -NT - (admin) - (4)
                                     Nah - (broomberg) - (2)
                                         I didn't say they were the best. - (admin) - (1)
                                             I know. I do. - (broomberg)
                                     I find PL/SQL and Transact/SQL too verbose -NT - (tablizer)
         COALESCE - (drewk)
         Re: Simple SQL look-up turns out hairy - (JayMehaffey)
         Simpler SQL - (ChrisR) - (2)
             My 1999 book implies UPDATE....FROM is not standard -NT - (tablizer) - (1)
                 Probably so... - (ChrisR)
         And you're surprised because what? -NT - (pwhysall)
         Another SQL Puzzle - (tablizer) - (31)
             Re: Another SQL Puzzle - (ChrisR) - (25)
                 Hmmm. Standard? -NT - (tablizer) - (24)
                     No such thing in SQL world - dialects everywhere -NT - (tuberculosis) - (22)
                         Good point. Standard != Common_Implementation - (tablizer) - (21)
                             Lemme guess... - (ben_tilly) - (20)
                                 The best way to fix non-standard implementations.... - (ChrisR)
                                 I had a look. - (static) - (13)
                                     Fish in a barrel -NT - (ben_tilly)
                                     Please be more specific -NT - (tablizer) - (11)
                                         Horse corpse - meet Mr. Stick -NT - (broomberg) - (1)
                                             IOW, guilty until proven innocent. IranWeThey - (tablizer)
                                         Sorry, I've got real SQL work to do. -NT - (static) - (8)
                                             SQL sucks (as a relational language) - (tablizer) - (7)
                                                 Perhaps you need to get out of the design and... - (ChrisR) - (6)
                                                     Some convergence perhaps - (tablizer) - (5)
                                                         sounds like you would be happy doing MAS90 -NT - (boxley) - (2)
                                                             Wow. That's harsh. ;0) -NT - (mmoffitt) - (1)
                                                                 its straight forward, lucrative and he enjoys the language -NT - (boxley)
                                                         You are writing a language IN xBase? - (broomberg) - (1)
                                                             I am sort of pushing off parsing issues to something else -NT - (tablizer)
                                 WRONGO! - (tablizer) - (4)
                                     Re: WRONGO! - (JayMehaffey) - (3)
                                         Prefix != "procedural" - (tablizer) - (2)
                                             I wasn't talking aobut it's notation - (JayMehaffey) - (1)
                                                 Variables can be semantic "references", not necess. storage - (tablizer)
                     CASE is the ANSI/ISO-standard - (ChrisR)
             Easy if you have decode - (SpiceWare)
             Re: Another SQL Puzzle - (takicutie) - (3)
                 hmm - decode won't work afterall - (SpiceWare) - (2)
                     Nope, no negative in my case - (tablizer) - (1)
                         It has been standardized. - (ChrisR)
     Weird Access report printing update. - (acagle) - (4)
         You should helpfully update upside his head with a 2 x 4 -NT - (drewk) - (3)
             Hey, come on - he *did* help Cagey pin down the problem! :-) -NT - (CRConrad) - (2)
                 This is true. - (acagle) - (1)
                     Lemme guess: B&W PCL5e? Color PCL6? - (folkert)
     Any DBAs want to do some consulting? - (drewk) - (14)
         Sorry, I don't get it. Aren't (eg) tabledefs also just code? -NT - (CRConrad) - (11)
             Rollback is different, some actions are non-reversible - (drewk) - (10)
                 Ah. OK, I see what you mean. But... - (CRConrad) - (9)
                     Maybe you're used to different hardware than I am - (drewk) - (8)
                         couple of points - (cforde) - (4)
                             A mysqldump can be slower than a select * into ... - (static)
                             Not on MySQL any more - (drewk) - (2)
                                 Then you need to slow down. WTF is that place - Fever City?! -NT - (CRConrad) - (1)
                                     How many developers in your departement? - (drewk)
                         You should try an approach that works well for Peoplesoft - (folkert) - (2)
                             gotta write that one down, thanx -NT - (boxley)
                             Already do that - (drewk)
         email me - (broomberg) - (1)
             Still trying to find all that out - (drewk)
     How to do without subqueries - (drewk) - (18)
         SELECT DISTINCT t1.* FROM t1, t2 ...? - (FuManChu)
         I don't understand your description - (ben_tilly) - (16)
             Reply from Drew - (Meerkat) - (15)
                 Re: Reply from Drew - (SpiceWare) - (6)
                     DECODE is Oracle-specific. -NT - (ben_tilly) - (5)
                         It is, but it is easy to clone - (tuberculosis)
                         Are you sure? I checked MySQL before posting - (SpiceWare) - (3)
                             They may have added it but it is not standard - (ben_tilly)
                             Seems to be specific to MaxDB - (JayMehaffey) - (1)
                                 That's rather confusing - (SpiceWare)
                 One solution - (JayMehaffey) - (1)
                     FWIW this was the best I saw for our needs - (drewk)
                 Untested, googling for supported syntax - (ben_tilly)
                 Re: Reply from Drew - (dws) - (4)
                     You're ordering by the wrong thing - (ben_tilly) - (3)
                         Where do you see me ordering by count(*) ? -NT - (dws) - (2)
                             You weren't, clarification - (ben_tilly) - (1)
                                 Re: You weren't, clarification - (dws)
     Has anyone heard of a tool like this? - (ben_tilly) - (19)
         Im confused - (boxley) - (18)
             Explanation - (ben_tilly) - (17)
                 well that can be hand carved - (boxley) - (16)
                     That's a useless response - (ben_tilly) - (15)
                         Sounds like you are hand carving it - (broomberg) - (3)
                             I may have to... - (ben_tilly) - (2)
                                 Seems it does not meet the commercial x-over requirement - (broomberg) - (1)
                                     Point -NT - (ben_tilly)
                         spotted a book while looking for something else - (boxley) - (10)
                             I assume that our DBAs know that stuff... -NT - (ben_tilly) - (9)
                                 Don't. -NT - (CRConrad) - (8)
                                     I've seen the books on their desks... - (ben_tilly) - (7)
                                         Our new DBA starts next week - (broomberg) - (4)
                                             Any chance that he wants to move to LA? -NT - (ben_tilly) - (3)
                                                 Or Seattle? - (tuberculosis) - (2)
                                                     Bunch of vultures - (broomberg) - (1)
                                                         We can't seem to grow them fast enough - (tuberculosis)
                                         Damn, you have it good! Envy, envy. - (CRConrad) - (1)
                                             There are a lot of atypical things about this company :-) -NT - (ben_tilly)
     Clustering in PostgreSQL or MySQL? - (admin)
     Simplistic Database locking. - (static) - (19)
         AFAIK, Oracle is the only one using its model -NT - (ben_tilly) - (2)
             Postgres allows it too -NT - (broomberg) - (1)
                 Does it now? - (static)
         Re: Simplistic Database locking. - (JayMehaffey) - (6)
             The SELECT does. - (static) - (5)
                 Re: The SELECT does. - (JayMehaffey) - (4)
                     It's not an InnoDB table. - (static) - (3)
                         "Including 'THE' other..." ?!? :-( - (CRConrad) - (1)
                             Quite. - (static)
                         That would be a problem. - (JayMehaffey)
         The "Multi-Generational Architecture"... - (CRConrad) - (8)
             More commonly known as MVCC - (tuberculosis) - (7)
                 You'd be amazed - (drewk)
                 MySQL Gotchas - (cforde) - (2)
                     My favorite quote: - (folkert) - (1)
                         Somebody's channeling Peter in 'snarky' mode. -NT - (inthane-chan)
                 That postgres link is really useful. - (static) - (2)
                     mysql - (tuberculosis) - (1)
                         That is the question *I* keep asking MySELF. - (folkert)
Now viewing page 7 of 25
[Prev] 1 ... 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 ... 25 [Next]

Simple... there is a forum function for this.
314 ms