Articles by Drew Rhoades (Tip/Trick: 1)

Tip/Trick: 1

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 0.00

Database Development

SQL Server

Best Practices to tune up T-SQL and SP [Tip/Trick]

2 Mar 2012 Updated: 2 Mar 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00

Licence: CPOL Views: 16,041 Bookmarked: 1 Downloaded: 0

I can't imagine that a correlated subquery is your best answer here:SELECT name FROM teacher WHERE EXISTS (SELECT 1 FROM student WHERE teacher.teacher_id = student.teacher_id)Instead, how about an INNER JOIN?SELECT DISTINCT teacher.nameFROM teacher INNER JOIN student ...

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Drew Rhoades

Technical Lead PDI

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.