Bah, that does suck. Sorry to hear that. :-/ Marlon Moyer wrote:
>Yeah, doubly so, The A/C tech didn't show up until 5:40 yesterday and >then said he needed to order a part, but the parts warehouse was >closed. This morning they told us the part may not be available until >Monday, so we may have to go through the weekend without A/C. > >On 6/30/05, Ray Champagne <[EMAIL PROTECTED]> wrote: > > >>And so Marlon's crappy week continues.... >> >>Marlon Moyer wrote: >> >> >>>I am fed up with SQL Server! We've got a claims search section on our >>>internal website and the search allows you to filter on 30 different >>>columns. Currently, I'm trying to track down a condition where a >>>query is fed 4 filter columns, so 4 (blah = blah) in the where clause. >>> Currently the query runs 10 minutes, but if you change one of the >>>fields from (reserves > 0) to (reserves = 0), it runs in under 30 >>>seconds. What a steaming pile of crap sql server is! >>> >>>Thanks >>> >>> >>> >>-- >>================================================================= >>Ray Champagne - Senior Application Developer >>CrystalVision Web Site Design and Internet Services >>603.433.9559 >>www.crystalvision.org >>================================================================= >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:162486 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
