Any Good Book Recommendations?

I know basic SQL and have passed two Oracle Exams, SQL and PL/SQL Programming. Ironically, my first (and only job unfortunately) was in MS SQL Server 2000. I want to know of a good overall SQL Book that is beyond beginner level. Something that answers questions like "How do you get rid of duplicate records in a table?", etc and other practical, real world issues. Is there such a text? It can be Oracle or MS or whatever as long as the theory is sound. Thanks.

ddaveWhile not a book, here are some good SQL sites:

Introduction to Structured Query Language
http://w3.one.net/~jhoffman/sqltut.htm
"Comprehensive SQL tutorial."

SQL Intrepreter & Tutorial With Live Practice Database
http://www.sqlcourse.com

SQL Tutorial
http://www.w3schools.com/sql/

aboutSQL by John Ashenfelter
http://www.oreillynet.com/pub/ct/19
"Provides information on SQL keywords, functions, tricks, and hacks"

SQLTeam.com
http://www.sqlteam.com
Site is mostly about SQL Server and includes forums.|||paul, the jim hoffman tutorial used to be the only decent sql tutorial on the web

but jim hoffman disappeared, and so did his site, a couple years ago

you can still get it at archive.org (http://web.archive.org/), where the latest version is November 2001, 4.76 (http://web.archive.org/web/20011116021648/http://w3.one.net/~jhoffman/sqltut.htm)

ddave, you may find some more tutorials on my SQL Links (http://r937.com/sqllinks.cfm) page

Any debugger in MSSQL 2005?

In SQL Server 2005, is there any debugging tools for T-SQL programming works similar to that in Visual Studio .NET?You have to use visual Studio to debug TSQL in SQL 2005. There is nothing in management studio.