DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

5
Shouts

Shout it

SQL SERVER – A Tricky Question and Even Trickier Answer – Index Intersection – Partition Function « SQL Server Journey with SQL Authority

published 405 days, 8 hours, 51 minutes ago posted by

pinaldave 413 days, 2 hours, 44 minutes ago

Just a day ago in evening I asked very simple question on my Facebook Page. The question was written in jiffy and in very light mood. When writing question I left few things out, and it did miss few details about setup. However, as the question was not complete it created extremely interesting conversation in the following thread. Here is the question: Write a select statement using a single table, using single table single time only without using join keywords, which generate execution plan with 2 join...