(new) Databases

SQL implementation comparison. - (static) - (1) - July 20, 2005, 01:27:08 AM EDT

Velly intelesting - (Yendor) - July 20, 2005, 11:12:26 AM EDT

Access vs. SQL Server: "Invalid argument" error. - (acagle) - (2) - July 11, 2005, 03:52:26 PM EDT

Yeah, have either of 'em argue against a non-MS DB in stead. -NT - (CRConrad) - July 11, 2005, 04:06:13 PM EDT

Used DTS for that purpose. - (ChrisR) - July 11, 2005, 04:14:20 PM EDT

Indexes and primary keys - redundant? - (tablizer) - (9) - June 22, 2005, 04:43:16 PM EDT

I can't recall every having an index on the primary key - (jbrabeck) - June 22, 2005, 04:16:09 PM EDT

As I understand it - (tuberculosis) - (1) - June 22, 2005, 06:57:51 PM EDT

It's definitely the case with Oracle. -NT - (Meerkat) - June 25, 2005, 09:30:22 AM EDT

The Primary Key is an Index. - (ChrisR) - June 22, 2005, 07:26:24 PM EDT

Conceptually no, in practice yes - (JayMehaffey) - (3) - June 22, 2005, 10:40:41 PM EDT

Relational theory does not address indexes - (tablizer) - (2) - June 22, 2005, 11:10:09 PM EDT

Indexes are just tables.... - (ChrisR) - (1) - June 22, 2005, 11:24:01 PM EDT

Re: just tables. - (mmoffitt) - June 23, 2005, 10:36:27 AM EDT

Check the index list. - (static) - June 23, 2005, 01:11:11 AM EDT

anyone with oracle know what these are? - (boxley) - (26) - June 10, 2005, 11:01:08 AM EDT

You need em. - (folkert) - (1) - June 10, 2005, 11:07:37 AM EDT

lab box, my care and feeding only - (boxley) - June 10, 2005, 11:15:18 AM EDT

If memory serves me correct. - (ChrisR) - (8) - June 10, 2005, 11:09:58 AM EDT

ICLRPD (new thread) - (drewk) - June 10, 2005, 12:27:23 PM EDT

well I guess I know what Ill be doing the rest of the day - (boxley) - (6) - June 10, 2005, 02:53:53 PM EDT

Live and learn. - (ChrisR) - (1) - June 10, 2005, 02:58:10 PM EDT

no problem, I needed to knock it down any way - (boxley) - June 10, 2005, 03:00:28 PM EDT

My rule on unknown files - (SpiceWare) - (3) - June 10, 2005, 02:59:51 PM EDT

disk at 100% ripem out then learn something -NT - (boxley) - (2) - June 10, 2005, 03:01:25 PM EDT

Compress elsewhere, then learn later. -NT - (ben_tilly) - (1) - June 10, 2005, 04:00:29 PM EDT

*GRIN* -NT - (imric) - June 10, 2005, 05:32:52 PM EDT

Yes - (broomberg) - (14) - June 10, 2005, 11:51:54 PM EDT

nope only one :-) - (boxley) - (13) - June 10, 2005, 11:56:03 PM EDT

You CANNOT use one from a different box - (broomberg) - (12) - June 11, 2005, 11:27:19 AM EDT

rm -r oracle - (boxley) - (11) - June 11, 2005, 01:12:41 PM EDT

The tnsnames will be wrong - (broomberg) - (10) - June 11, 2005, 01:38:39 PM EDT

tnsnames on all boxes point to localhost - (boxley) - (9) - June 11, 2005, 02:23:48 PM EDT

OK -NT - (broomberg) - June 11, 2005, 09:01:59 PM EDT

You might find this helpful - (broomberg) - (7) - June 11, 2005, 09:08:30 PM EDT

thanks! bookmarked -NT - (boxley) - June 11, 2005, 10:18:28 PM EDT

backup and running 4hrs to figure out - (boxley) - (5) - June 14, 2005, 10:30:21 AM EDT

Hmm - (broomberg) - (4) - June 14, 2005, 07:03:18 PM EDT

yabut does your user $ORACLE_HOME - (boxley) - (3) - June 14, 2005, 07:16:00 PM EDT

Yup - (broomberg) - (2) - June 14, 2005, 07:43:57 PM EDT

but if oracle user uses - (boxley) - (1) - June 14, 2005, 07:49:19 PM EDT

Maybe - (broomberg) - June 14, 2005, 08:12:56 PM EDT

oracle remote DB access - (boxley) - (2) - June 1, 2005, 10:37:16 AM EDT

I thought if it wasn't in tnsnames you couldn't get there, - (Meerkat) - (1) - June 2, 2005, 08:07:46 AM EDT

Supposedly you can - (admin) - June 2, 2005, 08:56:27 AM EDT

Simple SQL look-up turns out hairy - (tablizer) - (51) - May 26, 2005, 03:12:19 PM EDT

I awalys hated SQL based batch updates - (broomberg) - (12) - May 26, 2005, 03:16:23 PM EDT

Let's bring back FoxPro! - (tablizer) - (11) - May 26, 2005, 03:25:54 PM EDT

Silly person you - (broomberg) - (10) - May 26, 2005, 04:06:28 PM EDT

Preach! -NT - (drewk) - May 26, 2005, 04:33:17 PM EDT

63.472% Disagree - (tablizer) - May 27, 2005, 09:02:12 PM EDT

Real world example - (broomberg) - (7) - June 21, 2005, 07:36:14 PM EDT

I am not sure what your point is - (tablizer) - (6) - June 21, 2005, 08:02:51 PM EDT

It's been done already - (broomberg) - (5) - June 21, 2005, 08:11:42 PM EDT

Or PL/SQL, or TransactSQL, or... -NT - (admin) - (4) - June 21, 2005, 09:10:53 PM EDT

Nah - (broomberg) - (2) - June 21, 2005, 11:13:03 PM EDT

I didn't say they were the best. - (admin) - (1) - June 21, 2005, 11:16:54 PM EDT

I know. I do. - (broomberg) - June 21, 2005, 11:20:25 PM EDT

I find PL/SQL and Transact/SQL too verbose -NT - (tablizer) - June 22, 2005, 01:03:50 AM EDT

COALESCE - (drewk) - May 26, 2005, 03:30:37 PM EDT

Re: Simple SQL look-up turns out hairy - (JayMehaffey) - May 26, 2005, 03:52:18 PM EDT

Simpler SQL - (ChrisR) - (2) - May 26, 2005, 04:01:40 PM EDT

My 1999 book implies UPDATE....FROM is not standard -NT - (tablizer) - (1) - May 27, 2005, 09:06:38 PM EDT

Probably so... - (ChrisR) - May 27, 2005, 09:57:05 PM EDT

And you're surprised because what? -NT - (pwhysall) - May 26, 2005, 05:23:28 PM EDT

Another SQL Puzzle - (tablizer) - (31) - May 27, 2005, 09:15:39 PM EDT

Re: Another SQL Puzzle - (ChrisR) - (25) - May 27, 2005, 09:50:17 PM EDT

Hmmm. Standard? -NT - (tablizer) - (24) - May 31, 2005, 01:18:06 AM EDT

No such thing in SQL world - dialects everywhere -NT - (tuberculosis) - (22) - Aug. 21, 2007, 05:44:10 AM EDT

Good point. Standard != Common_Implementation - (tablizer) - (21) - June 2, 2005, 08:41:49 PM EDT

Lemme guess... - (ben_tilly) - (20) - June 2, 2005, 09:24:29 PM EDT

The best way to fix non-standard implementations.... - (ChrisR) - June 2, 2005, 10:27:30 PM EDT

I had a look. - (static) - (13) - June 2, 2005, 11:25:00 PM EDT

Fish in a barrel -NT - (ben_tilly) - June 3, 2005, 12:27:31 AM EDT

Please be more specific -NT - (tablizer) - (11) - June 20, 2005, 08:55:05 PM EDT

Horse corpse - meet Mr. Stick -NT - (broomberg) - (1) - June 20, 2005, 09:09:47 PM EDT

IOW, guilty until proven innocent. IranWeThey - (tablizer) - June 20, 2005, 09:20:14 PM EDT

Sorry, I've got real SQL work to do. -NT - (static) - (8) - June 20, 2005, 09:44:01 PM EDT

SQL sucks (as a relational language) - (tablizer) - (7) - June 21, 2005, 02:18:03 AM EDT

Perhaps you need to get out of the design and... - (ChrisR) - (6) - June 21, 2005, 10:39:45 AM EDT

Some convergence perhaps - (tablizer) - (5) - June 21, 2005, 03:06:20 PM EDT

sounds like you would be happy doing MAS90 -NT - (boxley) - (2) - June 21, 2005, 03:20:32 PM EDT

Wow. That's harsh. ;0) -NT - (mmoffitt) - (1) - June 21, 2005, 04:35:39 PM EDT

its straight forward, lucrative and he enjoys the language -NT - (boxley) - June 21, 2005, 06:03:18 PM EDT

You are writing a language IN xBase? - (broomberg) - (1) - June 21, 2005, 06:53:22 PM EDT

I am sort of pushing off parsing issues to something else -NT - (tablizer) - June 21, 2005, 08:04:39 PM EDT

WRONGO! - (tablizer) - (4) - June 20, 2005, 09:16:28 PM EDT

Re: WRONGO! - (JayMehaffey) - (3) - June 20, 2005, 10:19:39 PM EDT

Prefix != "procedural" - (tablizer) - (2) - June 21, 2005, 02:04:44 AM EDT

I wasn't talking aobut it's notation - (JayMehaffey) - (1) - June 22, 2005, 11:36:38 PM EDT

Variables can be semantic "references", not necess. storage - (tablizer) - June 23, 2005, 07:35:24 PM EDT

CASE is the ANSI/ISO-standard - (ChrisR) - May 31, 2005, 11:40:51 AM EDT

Easy if you have decode - (SpiceWare) - May 27, 2005, 09:47:22 PM EDT

Re: Another SQL Puzzle - (takicutie) - (3) - July 12, 2005, 12:07:06 AM EDT

hmm - decode won't work afterall - (SpiceWare) - (2) - July 12, 2005, 10:30:23 AM EDT

Nope, no negative in my case - (tablizer) - (1) - July 16, 2005, 01:26:43 AM EDT

It has been standardized. - (ChrisR) - July 16, 2005, 02:30:11 AM EDT

Weird Access report printing update. - (acagle) - (4) - May 16, 2005, 12:45:29 PM EDT

You should helpfully update upside his head with a 2 x 4 -NT - (drewk) - (3) - May 16, 2005, 01:28:34 PM EDT

Hey, come on - he *did* help Cagey pin down the problem! :-) -NT - (CRConrad) - (2) - May 16, 2005, 01:31:18 PM EDT

This is true. - (acagle) - (1) - May 16, 2005, 02:42:53 PM EDT

Lemme guess: B&W PCL5e? Color PCL6? - (folkert) - May 16, 2005, 04:12:39 PM EDT

Any DBAs want to do some consulting? - (drewk) - (14) - May 13, 2005, 08:39:35 AM EDT

Sorry, I don't get it. Aren't (eg) tabledefs also just code? -NT - (CRConrad) - (11) - May 13, 2005, 02:18:01 PM EDT

Rollback is different, some actions are non-reversible - (drewk) - (10) - May 13, 2005, 03:02:14 PM EDT

Ah. OK, I see what you mean. But... - (CRConrad) - (9) - May 13, 2005, 03:16:48 PM EDT

Maybe you're used to different hardware than I am - (drewk) - (8) - May 13, 2005, 03:53:18 PM EDT

couple of points - (cforde) - (4) - May 14, 2005, 02:34:34 AM EDT

A mysqldump can be slower than a select * into ... - (static) - May 15, 2005, 11:21:55 PM EDT

Not on MySQL any more - (drewk) - (2) - May 16, 2005, 11:58:16 AM EDT

Then you need to slow down. WTF is that place - Fever City?! -NT - (CRConrad) - (1) - May 16, 2005, 01:29:44 PM EDT

How many developers in your departement? - (drewk) - May 16, 2005, 02:07:00 PM EDT

You should try an approach that works well for Peoplesoft - (folkert) - (2) - May 14, 2005, 10:13:26 AM EDT

gotta write that one down, thanx -NT - (boxley) - May 14, 2005, 10:25:24 AM EDT

Already do that - (drewk) - May 15, 2005, 05:57:37 PM EDT

email me - (broomberg) - (1) - May 13, 2005, 08:55:58 PM EDT

Still trying to find all that out - (drewk) - May 15, 2005, 05:59:34 PM EDT

How to do without subqueries - (drewk) - (18) - April 21, 2005, 12:02:47 AM EDT

SELECT DISTINCT t1.* FROM t1, t2 ...? - (FuManChu) - April 21, 2005, 01:26:10 AM EDT

I don't understand your description - (ben_tilly) - (16) - April 21, 2005, 02:21:36 AM EDT

Reply from Drew - (Meerkat) - (15) - April 21, 2005, 09:34:14 AM EDT

Re: Reply from Drew - (SpiceWare) - (6) - April 21, 2005, 09:59:22 AM EDT

DECODE is Oracle-specific. -NT - (ben_tilly) - (5) - April 21, 2005, 08:37:47 PM EDT

It is, but it is easy to clone - (tuberculosis) - April 22, 2005, 09:29:35 AM EDT

Are you sure? I checked MySQL before posting - (SpiceWare) - (3) - April 22, 2005, 09:54:09 AM EDT

They may have added it but it is not standard - (ben_tilly) - April 22, 2005, 11:16:56 AM EDT

Seems to be specific to MaxDB - (JayMehaffey) - (1) - April 22, 2005, 11:35:10 AM EDT

That's rather confusing - (SpiceWare) - April 22, 2005, 12:14:55 PM EDT

One solution - (JayMehaffey) - (1) - April 21, 2005, 10:25:00 AM EDT

FWIW this was the best I saw for our needs - (drewk) - April 21, 2005, 08:49:39 PM EDT

Untested, googling for supported syntax - (ben_tilly) - April 21, 2005, 10:32:29 AM EDT

Re: Reply from Drew - (dws) - (4) - April 21, 2005, 08:17:36 PM EDT

You're ordering by the wrong thing - (ben_tilly) - (3) - April 21, 2005, 08:36:52 PM EDT

Where do you see me ordering by count(*) ? -NT - (dws) - (2) - April 22, 2005, 12:38:23 PM EDT

You weren't, clarification - (ben_tilly) - (1) - April 22, 2005, 02:08:36 PM EDT

Re: You weren't, clarification - (dws) - April 22, 2005, 04:32:31 PM EDT

Has anyone heard of a tool like this? - (ben_tilly) - (19) - April 20, 2005, 09:47:23 PM EDT

Im confused - (boxley) - (18) - April 20, 2005, 10:38:47 PM EDT

Explanation - (ben_tilly) - (17) - April 21, 2005, 12:48:48 AM EDT

well that can be hand carved - (boxley) - (16) - April 21, 2005, 09:57:27 AM EDT

That's a useless response - (ben_tilly) - (15) - April 21, 2005, 10:47:46 AM EDT

Sounds like you are hand carving it - (broomberg) - (3) - April 21, 2005, 11:19:28 AM EDT

I may have to... - (ben_tilly) - (2) - April 21, 2005, 02:11:40 PM EDT

Seems it does not meet the commercial x-over requirement - (broomberg) - (1) - April 21, 2005, 03:36:04 PM EDT

Point -NT - (ben_tilly) - April 21, 2005, 04:26:01 PM EDT

spotted a book while looking for something else - (boxley) - (10) - April 21, 2005, 02:54:04 PM EDT

I assume that our DBAs know that stuff... -NT - (ben_tilly) - (9) - April 21, 2005, 04:25:10 PM EDT

Don't. -NT - (CRConrad) - (8) - April 21, 2005, 04:43:42 PM EDT

I've seen the books on their desks... - (ben_tilly) - (7) - April 21, 2005, 04:53:16 PM EDT

Our new DBA starts next week - (broomberg) - (4) - April 21, 2005, 04:58:05 PM EDT

Any chance that he wants to move to LA? -NT - (ben_tilly) - (3) - April 21, 2005, 05:26:24 PM EDT

Or Seattle? - (tuberculosis) - (2) - April 21, 2005, 06:06:03 PM EDT

Bunch of vultures - (broomberg) - (1) - April 21, 2005, 06:47:18 PM EDT

We can't seem to grow them fast enough - (tuberculosis) - April 21, 2005, 07:26:35 PM EDT

Damn, you have it good! Envy, envy. - (CRConrad) - (1) - April 21, 2005, 04:59:07 PM EDT

There are a lot of atypical things about this company :-) -NT - (ben_tilly) - April 21, 2005, 05:25:29 PM EDT

Welcome to IWETHEY!