Charindex, small functionality but usefull

CHARINDEX (Transact-SQL)

Searches expression2 for expression1 and returns its starting position if found. The search starts at start_location.
Few good scripts with charindex
select CHARINDEX(‘a’, ‘india’)
–result will be 5
select CHARINDEX( ‘,1,’ ,’,1,2,3,’)
– result would be 3
DECLARE @selectedID VARCHAR(10)
SET @selectedID = ‘1,2′
–SET @selectedID = ‘1,5′
Some times we have to pass comma seprated value to sp and have [...]

basics of SQL Server Transaction Isolation Levels

I read one good article about sql server – transaction isolation level..
You might like it
Articl Summary: This post discusses the basics of SQL Server Transaction Isolation Levels.
http://www.sqlserverandxml.com/2008/08/introduction-to-sql-server-transaction.html