Geeks With Blogs

News
DevJef's Mumbo-Jumbo «There's a bit of SQL in all of us» November 2011 Entries
Permanent Move...

Because of several reasons, I decided to move my blogs to another host. So, from now on my blogs can be found on my new blog: http://DevJef.wordpress.com/.


Hope to see you there, or you're always free to contact me via Twitter, mail or my blog!


Posted On Friday, November 4, 2011 10:13 PM

Join vs Sub Query
If you work with SQL Server you will eventually encounter a JOIN statement. This JOIN statement can be stated as an ordinary JOIN, or as a sub select. In most cases I try to use JOINS (even though it’s just for readability), but in some cases it’s quicker to do it in a sub select (for example with production code, in which you don’t want to change the output but filter output). Curious about the performance differences between the two, I tried to create a test. I created 2 tables with country information: ......

Posted On Tuesday, November 1, 2011 2:26 PM

Copyright © DevJef | Powered by: GeeksWithBlogs.net | Join free