Below a bunch of my favorite sites.
SQL Server Central
The biggest resource and community on SQL Server I know.
Many useful articles of the SQL experts Brent Ozar, Kendra Little and Jeremiah Peschka
Especially famous for its SQL Server maintenance solution.
All you ever wanted to know about DBCC CHECK DB
I love the SQL compare products.