Click here to Skip to main content
15,433,964 members

The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
General"This is a rare event" PinPopular
Marc Clifton7-May-22 8:33
mvaMarc Clifton7-May-22 8:33 
GeneralRe: "This is a rare event" Pin
Slacker00710-May-22 10:04
professionalSlacker00710-May-22 10:04 
GeneralRe: "This is a rare event" Pin
jsc4211-May-22 0:17
professionaljsc4211-May-22 0:17 
GeneralRe: "This is a rare event" Pin
MarkTJohnson11-May-22 3:23
professionalMarkTJohnson11-May-22 3:23 
GeneralRe: "This is a rare event" Pin
PIEBALDconsult14-May-22 14:20
professionalPIEBALDconsult14-May-22 14:20 
GeneralRe: "This is a rare event" Pin
PIEBALDconsult14-May-22 14:24
professionalPIEBALDconsult14-May-22 14:24 
GeneralRe: "This is a rare event" Pin
Marc Clifton15-May-22 7:04
mvaMarc Clifton15-May-22 7:04 
GeneralRe: "This is a rare event" Pin
Jörgen Andersson17-May-22 23:52
professionalJörgen Andersson17-May-22 23:52 
For inner joins the optimizer will disregard any order of the joins, or any parentheses for that matter.
If you want to force a specific order there's a hint for that: OPTION (FORCE ORDER)

For outer joins this is not the case, they will happen in the relative order specified.
Wrong is evil and must be defeated. - Jeff Ello

GeneralRe: "This is a rare event" Pin
Craig Robbins27-Jun-22 14:01
MemberCraig Robbins27-Jun-22 14:01 
GeneralRe: "This is a rare event" Pin
PIEBALDconsult27-Jun-22 14:41
professionalPIEBALDconsult27-Jun-22 14:41 
GeneralRe: "This is a rare event" Pin
Duncan Edwards Jones16-May-22 7:05
professionalDuncan Edwards Jones16-May-22 7:05 
GeneralRe: "This is a rare event" Pin
pkfox30-Jun-22 22:36
professionalpkfox30-Jun-22 22:36 
GeneralRe: "This is a rare event" Pin
Member 150787164-Jul-22 17:10
MemberMember 150787164-Jul-22 17:10 
GeneralRe: "This is a rare event" Pin
Ron Anders21-Jul-22 5:56
MemberRon Anders21-Jul-22 5:56 
GeneralTell me what's wrong with the following Pin
Gary R. Wheeler4-May-22 5:35
MemberGary R. Wheeler4-May-22 5:35 
GeneralRe: Tell me what's wrong with the following Pin
Greg Utas4-May-22 6:42
mveGreg Utas4-May-22 6:42 
GeneralRe: Tell me what's wrong with the following Pin
Gary R. Wheeler4-May-22 6:53
MemberGary R. Wheeler4-May-22 6:53 
GeneralRe: Tell me what's wrong with the following Pin
Greg Utas4-May-22 7:00
mveGreg Utas4-May-22 7:00 
GeneralRe: Tell me what's wrong with the following Pin
Gary R. Wheeler4-May-22 12:30
MemberGary R. Wheeler4-May-22 12:30 
GeneralRe: Tell me what's wrong with the following Pin
Mircea Neacsu4-May-22 9:09
mvaMircea Neacsu4-May-22 9:09 
GeneralRe: Tell me what's wrong with the following Pin
Greg Utas4-May-22 10:09
mveGreg Utas4-May-22 10:09 
GeneralRe: Tell me what's wrong with the following Pin
Randor 4-May-22 10:44
professional Randor 4-May-22 10:44 
GeneralRe: Tell me what's wrong with the following Pin
Greg Utas4-May-22 11:38
mveGreg Utas4-May-22 11:38 
GeneralRe: Tell me what's wrong with the following Pin
Randor 4-May-22 11:49
professional Randor 4-May-22 11:49 
GeneralRe: Tell me what's wrong with the following Pin
Gary R. Wheeler4-May-22 12:33
MemberGary R. Wheeler4-May-22 12:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.