Viewing 15 posts - 46,066 through 46,080 (of 59,062 total)
foxjazz (1/6/2009)
don't you guys have jobs?
Oh hell yes! I'm a professional pork chop launcher! 😛
January 6, 2009 at 6:06 pm
Oh yeah... meant to ask. Barry, do you remember what you did a search on? I did one on the error message itself and got just about everything...
January 6, 2009 at 4:15 pm
Heh... we're running Lotus Notes so not sure any of the servers are running Exchange. I'll take a look, though.
It would really be cool if Barry's suggestion were all...
January 6, 2009 at 4:14 pm
Properly cut pork chops only have 3 sides... well, until they hit... 🙂
January 6, 2009 at 4:07 pm
Heh... it's the only way he could get the eyeholes on the helmet right. 😛
January 6, 2009 at 4:03 pm
I agree... there's nothing in the data presented that identifies which row in the first table goes with which row in the second table other than physical order listed... and...
January 6, 2009 at 3:57 pm
Crud... I was just reaching for the bucket o' fresh pork chops... 😛
January 6, 2009 at 3:51 pm
Matt Whitfield (1/6/2009)
Jeff Moden (1/5/2009)
January 6, 2009 at 6:35 am
Grant Fritchey (1/5/2009)
RBarryYoung (1/5/2009)
Actually, I heard from someone at PASS that WITH RECOMPILE does not work reliably for this problem in SQL2005, but "is fixed" in SQL 2008.
WITH RECOMPILE was...
January 6, 2009 at 6:20 am
sqlblue (1/5/2009)
January 6, 2009 at 6:15 am
First, I'd give Peso's code a whirl.
Second, if you really must do the Null conversion to 0, use ISNULL instead of COALESCE... ISNULL is actually quite a bit faster the...
January 6, 2009 at 6:05 am
RBarryYoung (1/5/2009)
Jeff Moden (1/1/2009)
Day "0" is 01/01/1900... and it was a Monday... Guess what happens if you add 4 days to any Monday? You get a Friday... every time.
Sorry...
January 6, 2009 at 5:54 am
pavankumarh2 (1/5/2009)
I am moving to work on Production support as DBA ,plz any tell me any body what are the common responsibilities of...
January 6, 2009 at 5:48 am
My very strong recommendation would be that both queries are wrong simply because of the use of BETWEEN. In the first query, you miss out on a whole second...
January 6, 2009 at 5:45 am
My general rule of thumb is to never use table variables unless the system forces me to. That means the ONLY place I use them is in UDF's.
The reason...
January 6, 2009 at 5:34 am
Viewing 15 posts - 46,066 through 46,080 (of 59,062 total)