SQL Server Useful Links

- Bacsic Concepts of Join

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
- Search the text on SP

SELECT * FROM sysobjects t1 LEFT JOIN Syscomments t2 ON t1.ID = t2.ID WHERE t2.text like '%SEARCH_TEXT_VALUE%'

- View Stored Procedure

Sp_Helptext SP_Name

- Search Table Names based on Column Name

SELECT OBJECT_NAME(OBJECT_ID) TableName FROM sys.columns WHERE name = 'COLUMN_NAME'

- Coding standards of SQL Server
http://blog.sqlauthority.com/category/sql-coding-standards/ - Implement the Policy Structure in SQL Server
http://blog.sqlauthority.com/2008/06/13/sql-server-2008-introduction-to-policy-management-enforcing-rules-on-sql-server/
- Search Last modified SP's Date

SELECT name,create_date,modify_date FROM sys.procedures ORDER BY modify_date DESC

- Understanding of SQL Server NOLOCK 

http://www.mssqltips.com/sqlservertip/2470/understanding-the-sql-server-nolock-hint
- Joins Performance

http://www.sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/ http://blog.sqlauthority.com/2008/04/22/sql-server-better-performance-left-join-or-not-in/ http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/ http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/ http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/ http://stackoverflow.com/questions/2501024/left-outer-join-with-a-where-clause