IWETHEY v. 0.3.0
|
TODO
1,095 registered users | 0
active users
| 0 LpH |
Statistics
Login
|
Create New User
Welcome to IWETHEY!
IWETHEY Home
/
IWETHEY Board
/
Databases Forum
/
Those dang outer joins
Post #60,201
by
wharris2
10/30/02 11:10:57 AM
Reply
Those dang outer joins
The rules for outer joins are pretty well defined but often far from intuitive. I've seen SQL using outer joins produce seemingly weird but (after meditating on them for a while) completely logical results.
SQL Server Database loses half of its records and indexes
- (
orion
)
- (27)
- Oct. 18, 2002, 06:58:17 PM EDT
SQL Database loses half of its records and indexes
- (
gdaustin
)
- (14)
- Oct. 18, 2002, 10:09:13 PM EDT
Recipe for doom
- (
tablizer
)
- (13)
- Oct. 25, 2002, 11:19:48 PM EDT
Re: Recipe for doom
- (
jlalexander
)
- (12)
- Oct. 26, 2002, 03:38:31 PM EDT
I'd disagree as well, but not so strongly.
- (
mmoffitt
)
- (11)
- Oct. 26, 2002, 06:18:53 PM EDT
DBA's fault?
- (
tablizer
)
- (10)
- Oct. 28, 2002, 02:22:42 AM EST
Have an example handy?
- (
ChrisR
)
- (8)
- Oct. 28, 2002, 09:37:21 AM EST
Actually there was a bug in Sql 7.0.
- (
mmoffitt
)
- (7)
- Oct. 29, 2002, 06:58:07 PM EST
Seen lots of SQL generate "incorrect" results...
- (
gdaustin
)
- (6)
- Oct. 30, 2002, 11:06:21 AM EST
Those dang outer joins
- (
wharris2
)
- Oct. 30, 2002, 11:10:57 AM EST
Why does it care about line-ends in the first place?!?
-NT
- (
CRConrad
)
- (3)
- Oct. 30, 2002, 11:15:37 AM EST
Re: Why does it care about line-ends in the first place?!?
- (
gdaustin
)
- (2)
- Oct. 30, 2002, 11:51:17 AM EST
We do the same thing here.
- (
admin
)
- (1)
- Oct. 30, 2002, 11:52:45 AM EST
We've done that, too.
- (
static
)
- Oct. 31, 2002, 06:30:42 AM EST
Speaking of incorrect results...
- (
Meerkat
)
- Nov. 2, 2002, 12:35:34 AM EST
Possibly
- (
wharris2
)
- Oct. 28, 2002, 01:15:04 PM EST
What kind of replication are you doing?
- (
mmoffitt
)
- (11)
- Oct. 21, 2002, 10:26:27 PM EDT
Expect no response from Norm...
-NT
- (
folkert
)
- (3)
- Oct. 21, 2002, 10:48:50 PM EDT
Why's that? Is he no longer active here?
-NT
- (
mmoffitt
)
- (2)
- Oct. 22, 2002, 12:51:47 PM EDT
Claimed so on the mailing list- but, "Promises, promises..."
-NT
- (
CRConrad
)
- (1)
- Oct. 22, 2002, 01:03:05 PM EDT
Get over it
- (
orion
)
- Nov. 4, 2002, 04:23:36 AM EST
Update on Replication
- (
orion
)
- (6)
- Nov. 4, 2002, 04:29:26 AM EST
Try MSMQ.
- (
mmoffitt
)
- Nov. 4, 2002, 02:40:38 PM EST
how will you resolve last write issues on the same record?
- (
boxley
)
- (3)
- Nov. 4, 2002, 08:06:19 PM EST
I've told him how to do it already.
-NT
- (
CRConrad
)
- (2)
- Nov. 5, 2002, 02:29:23 AM EST
Thanks, but I lost that job.
- (
orion
)
- (1)
- Nov. 24, 2002, 04:30:46 AM EST
Yeah, sure - that must be why I did it. (new thread)
- (
CRConrad
)
- Nov. 24, 2002, 07:30:37 AM EST
Since you're down to synchronization, not replication now -
- (
Arkadiy
)
- Nov. 6, 2002, 08:37:22 PM EST
i
we
they
.org
Fall not in love therefore; it will stick to your face.
80 ms