Forum Replies Created
Viewing 15 posts - 55,396 through 55,410 (of 59,078 total)
-
RE: Date convert
Yep... gotta agree... That's pretty much the reason for NOT storing dates as VARCHAR...
-
RE: sql question using IN
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...
-
RE: sql question using IN
And I always thought EXCEPT is better than NOT IN or NOT EXISTS or LEFT OUTER JOIN -
RE: sql question using IN
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...
-
RE: Can''''t retrieve the records I want
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
-
RE: Date convert
LMAO!!! Thanks guys... you were right and I corrected the entry.
-
RE: sql question using IN
Heh... gettin' lazy in your old age, Remi
All times in milliseconds to return 999015 rows in the grid mode of Query Analyzer...5941...
-
RE: Die Access, Die
They tried to kill FoxPro... look what happened there...
And, why does everyone think that Web Apps are a panacea? 
-
RE: sql question using IN
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
-
RE: sql question using IN
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...
-
RE: BCP problem - will not work only on one stored procedure
Heh... but it IS documented in the SQL Specifications...
Columns per base table 1,024 1,024 Why would BCP support more than that?
-
RE: Find TempDB Actual space occupied or used
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...
-
RE: Doing a count on characters within a string
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...
-
RE: Importing and Parsing CSV file into SQL server 2005
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.
Viewing 15 posts - 55,396 through 55,410 (of 59,078 total)