INNER JOIN is used to fetch data from multiple tables in one query, it helps to save database round trips, but getting data from more than two tables http://javarevisited.blogspot.com/2012/11/how-to-join-three-tables-in-sql-query-mysql-sqls...
Attaching .mdf file to the SQL database without .ldf file is a easy task but need attention. No matter SQL server shutdown properly or not. http://sqldbfriend.blogspot.in/2013/02/need-to-attach-mdf-file-without.html
Main difference between Correlated and Noncorrelated subquery is that, Correlated subquery depends upon Outer query and can not execute by its own whi http://javarevisited.blogspot.com/2012/07/subquery-example-in-sql-correlated-vs.html
This Select command tutorial is good for every sql programmer both for advanced programmers and beginners and acts as refresher for many of us which http://javarevisited.blogspot.com/2011/10/selct-command-sql-query-example.html
Dont Delete , truncate it. If you are working in a huge table you need to be very very careful while executing any query because due to large data an http://javarevisited.blogspot.com/2011/10/how-to-use-truncate-and-delete-command.html