(new) Databases

Left Outer Join question - (ChrisR) - (20) - June 7, 2006, 10:26:29 PM EDT

One approach - (ben_tilly) - (6) - June 8, 2006, 01:13:51 PM EDT

Some variation on MIN... - (ChrisR) - (3) - June 8, 2006, 11:10:15 AM EDT

It probably will not optimize - (ben_tilly) - (2) - June 8, 2006, 01:27:27 PM EDT

Yep, took forever to run. - (ChrisR) - (1) - June 8, 2006, 02:00:51 PM EDT

Nothing non-standard about that - (drewk) - June 8, 2006, 02:40:14 PM EDT

Pre indentation - (ChrisR) - (1) - June 8, 2006, 02:02:57 PM EDT

Bug, indentation can be lost during edits (new thread) - (ben_tilly) - June 8, 2006, 02:18:49 PM EDT

Does SQL Server support "DISTINCT ON"? - (drewk) - (12) - June 8, 2006, 08:55:49 AM EDT

That is really what I need! - (ChrisR) - June 8, 2006, 10:56:50 AM EDT

The more readable version is invalid (at least in Oracle) - (ben_tilly) - (10) - June 8, 2006, 01:12:25 PM EDT

Hmm, both Postgres and MySQL support the same non-standard? - (drewk) - (9) - June 8, 2006, 01:49:01 PM EDT

Can you please help me find mine? - (folkert) - June 8, 2006, 02:04:49 PM EDT

That is a MySQL shortcut - (ben_tilly) - (7) - June 8, 2006, 02:14:38 PM EDT

Not surprising - (drewk) - (2) - June 8, 2006, 02:42:46 PM EDT

Or you didn't double-check enough - (ben_tilly) - (1) - June 8, 2006, 02:50:14 PM EDT

Also possible - (drewk) - June 8, 2006, 04:17:32 PM EDT

I've encountered that problem. - (static) - (3) - June 8, 2006, 08:48:27 PM EDT

Justifiable arrogance in many cases - (ben_tilly) - (2) - June 8, 2006, 09:18:47 PM EDT

Oh I have little doubt about that. - (static) - (1) - June 8, 2006, 09:35:59 PM EDT

Oracle is picky but... - (ben_tilly) - June 8, 2006, 10:03:53 PM EDT

deleting user-created tables via stored proc - (lincoln) - (14) - May 30, 2006, 02:52:42 PM EDT

Shouldn't be too hard - (ChrisR) - (13) - May 30, 2006, 03:12:37 PM EDT

I tried this a little while ago - (lincoln) - (12) - May 30, 2006, 03:50:57 PM EDT

BTW, it is a dangerous script... - (ChrisR) - (11) - May 30, 2006, 11:59:10 PM EDT

The test was successful - (lincoln) - (10) - May 31, 2006, 10:46:57 AM EDT

Boy did that ever prove me wrong - (lincoln) - (9) - June 1, 2006, 09:58:25 AM EDT

Should be in the Job Task history... - (ChrisR) - June 1, 2006, 10:20:26 AM EDT

here's the latest update - (lincoln) - (7) - June 1, 2006, 12:38:22 PM EDT

Assuming you're on SS2k - (ChrisR) - (6) - June 1, 2006, 02:59:00 PM EDT

We're running SQL Server 2000 - (lincoln) - (5) - June 1, 2006, 04:49:34 PM EDT

Sent an email. - (ChrisR) - (4) - June 1, 2006, 05:06:34 PM EDT

got your email - (lincoln) - (3) - June 1, 2006, 09:59:10 PM EDT

It can rather hard to peek inside a stored proc... - (ChrisR) - (2) - June 2, 2006, 12:11:51 PM EDT

End result - (lincoln) - (1) - June 8, 2006, 09:30:31 AM EDT

Rings a bell - (broomberg) - June 8, 2006, 10:15:41 AM EDT

And here I always thought this was impossible! - (ben_tilly) - (2) - May 11, 2006, 09:20:40 PM EDT

Interesting - (JayMehaffey) - May 12, 2006, 10:05:56 PM EDT

Yup - for walking trees - (broomberg) - May 12, 2006, 10:37:32 PM EDT

Oracle: getting a wierd error when doing an export - (boxley) - (3) - April 25, 2006, 03:01:23 AM EDT

Nothing odd about that - (broomberg) - (2) - April 25, 2006, 06:55:33 PM EDT

What he said. - (Meerkat) - April 25, 2006, 08:03:45 PM EDT

thanks, time to let the dba's do what their paid for -NT - (boxley) - April 26, 2006, 10:16:46 AM EDT

how does one create a unique spool file name in oracle? - (boxley) - (1) - April 13, 2006, 07:20:46 PM EDT

oh oh oh I forget. - (broomberg) - April 13, 2006, 10:17:41 PM EDT

Question for CRC or anybody who remembers Paradox - (jbrabeck) - (12) - April 11, 2006, 06:52:56 PM EDT

It's a paradox... - (Yendor) - April 11, 2006, 06:54:11 PM EDT

Random guess - (broomberg) - (8) - April 11, 2006, 07:03:30 PM EDT

Could be - (altmann) - (7) - April 11, 2006, 07:12:59 PM EDT

Give the man a cigar - (jbrabeck) - (6) - April 11, 2006, 08:56:11 PM EDT

I prefer Drew Estates Acid -NT - (broomberg) - (5) - April 11, 2006, 09:33:19 PM EDT

I thought it was Drew Estates Acid Earthiness - (imqwerky) - (4) - April 11, 2006, 10:27:23 PM EDT

Yup. - (broomberg) - (3) - April 12, 2006, 08:06:01 AM EDT

You say that every year. -NT - (folkert) - (2) - April 12, 2006, 09:38:19 AM EDT

No I don't - (broomberg) - (1) - April 12, 2006, 09:49:55 AM EDT

Golly Gee, nobody can take a joke. -NT - (folkert) - April 12, 2006, 11:28:24 AM EDT

I used Paradox at version 3 - (admin) - (1) - April 11, 2006, 07:05:27 PM EDT

And I've used it since DOS v2 and from Win v1.0 -NT - (jbrabeck) - April 11, 2006, 08:57:17 PM EDT

subtracting dates inside rdbms as opposed to outside - (boxley) - (18) - April 10, 2006, 02:16:44 PM EDT

Indexes key to efficiency - (ChrisR) - (17) - April 10, 2006, 02:25:30 PM EDT

that runs faster by eyeball :-) thx! -NT - (boxley) - April 10, 2006, 02:34:34 PM EDT

Lotta people make that mistake. - (static) - April 11, 2006, 08:27:59 AM EDT

Indexes are only better if you're accessing under 7%... - (ben_tilly) - (14) - April 11, 2006, 11:40:07 AM EDT

It's 5% now. - (admin) - (11) - April 11, 2006, 11:42:37 AM EDT

Source? - (ben_tilly) - (10) - April 11, 2006, 12:13:34 PM EDT

My SQL tuning class instructor. :-D -NT - (admin) - (9) - April 11, 2006, 12:40:55 PM EDT

Is it coincidence that we both took that class recently? -NT - (ben_tilly) - (8) - April 11, 2006, 12:52:43 PM EDT

Dunno. - (admin) - (7) - April 11, 2006, 03:17:39 PM EDT

There was a cost-based optimizer in Oracle 8 as well - (ben_tilly) - (6) - April 11, 2006, 05:07:40 PM EDT

I'd appreciate a list if you can take the time. - (admin) - (5) - April 11, 2006, 05:35:10 PM EDT

Hmm... - (ben_tilly) - (4) - April 11, 2006, 07:04:48 PM EDT

Thanks. -NT - (admin) - April 11, 2006, 11:06:58 PM EDT

OK, here's a real bug, just encountered - (ben_tilly) - (2) - May 4, 2006, 10:10:54 PM EDT

I'll have to give that one a whirl. -NT - (admin) - (1) - May 5, 2006, 08:18:31 AM EDT

It can probably be simplified further... - (ben_tilly) - May 5, 2006, 11:01:32 AM EDT

I heard 8% the other day for MySQL/InnoDB - (dws) - (1) - April 15, 2006, 01:37:39 AM EDT

Percentage differences that close are really just a SWAG. - (broomberg) - April 15, 2006, 11:00:22 AM EDT

Dumb question - does SQL Server have a BCP out command? - (Simon_Jester) - (1) - April 5, 2006, 07:08:12 PM EDT

Yes. - (ChrisR) - April 10, 2006, 02:31:47 PM EDT

Comparing two tables in SQL Server - (lincoln) - (4) - April 5, 2006, 02:12:40 PM EDT

If you don't have any DB tools - (drewk) - April 5, 2006, 02:18:11 PM EDT

Write a query? - (ChrisR) - April 5, 2006, 03:02:34 PM EDT

Re: Comparing two tables in SQL Server - (JayMehaffey) - April 5, 2006, 03:24:31 PM EDT

Dumb question - does SQL Server have a BCP out command? (new thread) - (Simon_Jester) - April 5, 2006, 07:06:48 PM EDT

SQL Server's Query Analyzer not refreshing SPs - (lincoln) - (14) - Feb. 16, 2006, 10:24:44 AM EST

How are you retrieving the stored proc in Query Analyzer? - (ChrisR) - (2) - Feb. 16, 2006, 11:12:46 AM EST

from the Object Browser panel on the left side - (lincoln) - (1) - Feb. 16, 2006, 04:29:29 PM EST

just glossing over it... - (ChrisR) - Feb. 16, 2006, 05:35:57 PM EST

Getting at the source - (ChrisR) - (4) - Feb. 17, 2006, 09:54:26 AM EST

the source shows the latest changes - (lincoln) - (1) - Feb. 21, 2006, 10:04:19 AM EST

Occam's Razor and whatnot - (ChrisR) - Feb. 21, 2006, 11:27:39 AM EST

Izzat better than sp_helptext? -NT - (mmoffitt) - (1) - Feb. 21, 2006, 10:08:37 AM EST

Same difference - (ChrisR) - Feb. 21, 2006, 10:50:35 AM EST

Problem no longer appearing - (lincoln) - (5) - March 3, 2006, 02:39:44 PM EST

Its the magic of Microsoft -NT - (JayMehaffey) - (4) - March 4, 2006, 12:24:42 PM EST

s/magic/black-spaghetti-code-magic/ -NT - (folkert) - (3) - March 4, 2006, 06:22:46 PM EST

Also known as "non-deterministic" behavior. -NT - (a6l6e6x) - (2) - March 4, 2006, 11:09:15 PM EST

I was joking. You sound serious! - (folkert) - (1) - March 5, 2006, 01:11:56 AM EST

It's a "hot button" for me. :) -NT - (a6l6e6x) - March 5, 2006, 12:09:09 PM EST

Welcome to IWETHEY!