The new 3D Joins in SQL Server 2014

Question

The new 3D Joins in SQL Server 2014

Eirikur Eiriksson

SSC Guru

Points: 182910
More actions
April 1, 2014 at 3:34 pm

#396517

Has anyone tried out the new 3D joins in 2014?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398880 More actions · Answer 1

Not sure what you're referring to.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

Can you provide detail or technical link for 3D joins in 2014?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

I believe this is a late April Fools topic...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Eirikur Eiriksson SSC Guru Points: 182910 More actions · Answer 4

Koen Verbeeck (4/2/2014)
I believe this is a late April Fools topic...

Correct 😛 found everything about it on BOL under AFD....

mickyT SSChampion Points: 10360 More actions · Answer 5

I looked at the topic and thought wahoo they've do some enhancements to spatial ... but of course the spatial stuff hasn't changed in 2014:( Made me look though:-)

Gazareth One Orange Chip Points: 27737 More actions · Answer 6

Ah, was looking forward to using

RIGHT ANGLE JOIN

PERPENDICULAR JOIN

🙂

Jeremy Brown SSCarpal Tunnel Points: 4223 More actions · Answer 7

Gazareth (4/9/2014)
Ah, was looking forward to using
RIGHT ANGLE JOIN
PERPENDICULAR JOIN
🙂

I think I've seen that tried before... 🙂

Eric M Russell SSC Guru Points: 125560 More actions · Answer 8

Eirikur Eiriksson (4/1/2014)
Has anyone tried out the new 3D joins in 2014?

I can confirm that 3 dimensional joins work quite well; it's the 12 or 20 dimensional joins that are a pain. 😉

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Eirikur Eiriksson SSC Guru Points: 182910 More actions · Answer 9

Eric M Russell (5/2/2014)
Eirikur Eiriksson (4/1/2014)
Has anyone tried out the new 3D joins in 2014?
I can confirm that 3 dimensional joins work quite well; it's the 12 or 20 dimensional joins that are a pain. 😉

Now it's more my jaw joints giving me problems 😀