Good books

Good book, if you have tiem to read

http://business.rediff.com/special/2009/oct/30/five-great-business-books-to-read.htm

open SQL transaction in particular session

select @@TRANCOUNT

Find Remove Delete duplicate rows in sql

select MyId,COUNT(1) from #MyTable
group by MyId
having COUNT(1) > 1

--Select duplicate records
with CTE
AS
(SELECT MyId, RANK() OVER (PARTITION BY MyId ORDER BY num) rnk
FROM(SELECT *, ROW_NUMBER() OVER(ORDER BY MyId) num
FROM #MyTable
) X
)
Select * from CTE
WHERE rnk > 1

--Delete Duplicate records
with CTE
AS
(SELECT MyId, RANK() OVER (PARTITION BY MyId ORDER BY num) rnk
FROM(SELECT *, ROW_NUMBER() OVER(ORDER BY MyId) num
FROM #MyTable
) X
)
delete from CTE
WHERE rnk > 1

good article to study in abrod

http://getahead.rediff.com/report/2009/oct/06/career-study-us-makes-more-sense-today.htm

World's top 10 mobile - 2009

http://business.rediff.com/slide-show/2009/oct/01/slide-show-1-tech-top-10-mobile-phones.htm