Optoutprescreen.com

http://en.wikipedia.org/wiki/Optoutprescreen.com

Dell Inspiron 1525 lock with 9

Press Fn + Power key & see the below chart

--Here is the chart
http://support.dell.com/support/topics/global.aspx/support/dsn/en/document?c=us&cs=19&dl=false&l=en&s=dhs&docid=DBECF64CFEDA449398CB9E859D4944A5&doclang=en

asyncronyes method invocation

http://www.codeproject.com/KB/cs/abstractsvsinterfaces.aspx

http://www.codeproject.com/KB/cs/AsyncMethodInvocation.aspx

best time to buy car

http://blogs.consumerreports.org/cars/2007/08/car-buying.html

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