Viewing 15 posts - 55,396 through 55,410 (of 59,078 total)
Yep... gotta agree... That's pretty much the reason for NOT storing dates as VARCHAR...
August 12, 2007 at 4:11 pm
I think you'll find that WHERE IN has the exact same execution plan and performance as good and proper joins. I don't like them just because the code comes out...
August 12, 2007 at 10:01 am
| And I always thought EXCEPT is better than NOT IN or NOT EXISTS or LEFT OUTER JOIN |
August 12, 2007 at 9:53 am
Heh... yeah, I know... thanks for the reminder to post the results (it's true, I forget a lot)... you're lazy and I'm forgetful... we make a hell of a team...
August 12, 2007 at 9:43 am
Try sub-ing this into the code... orginal line says
[Parent] c ON b.facilityID = c.facilityID and b.firstname<>c.firstname
... try changing to ...
[Parent] c ON b.facilityID = c.facilityID and b.firstname< c.firstname
August 12, 2007 at 9:28 am
LMAO!!! Thanks guys... you were right and I corrected the entry. ![]()
August 12, 2007 at 9:23 am
Heh... gettin' lazy in your old age, Remi
All times in milliseconds to return 999015 rows in the grid mode of Query Analyzer...
5941...
August 11, 2007 at 11:54 pm
They tried to kill FoxPro... look what happened there...
And, why does everyone think that Web Apps are a panacea?
August 11, 2007 at 9:13 pm
Actually, NOT IN and NOT EXISTS create identical execution plans and both are a touch more effecient than an outer join with null detection... as always, here's the proof...
August 11, 2007 at 9:08 pm
Jim,
What is the work assignment that says you must use IN? The reason I ask is that it's a strange assignment and, as others have mentioned, is generally a bad...
August 11, 2007 at 8:48 pm
Heh... but it IS documented in the SQL Specifications...
| Columns per base table | 1,024 | 1,024 |
Why would BCP support more than that?
August 11, 2007 at 8:39 pm
Must be...
EXEC (@Cmd)
August 11, 2007 at 8:33 pm
I noticed that the growth rate is set to 10%. At the current size, that means that then next growth will be approximately 16 gig... that will take quite a...
August 11, 2007 at 8:33 am
I believe what you're looking for is a kind of "histogram". The other solutions are great but if there are any unexpected characters, the cross-tabs will miss them and, if...
August 10, 2007 at 7:40 pm
Have had similar problems in the past and have found it quicker to re-export the desired rows and re-import them using the parsing of Bulk Insert or BCP.
August 10, 2007 at 6:36 pm
Viewing 15 posts - 55,396 through 55,410 (of 59,078 total)