New posts in Sql Server 2008 R2

Find Sessions Connected by IP

Is it possible to do this math in a view?

How Many Times Does a CTE run

Why is this explicit cast causing problems only with a Linked Server?

Recommended memory configuration for many SQL Server instances per server

SQL query failing because of commented part of T-SQL query

What's the best way to archive all but current year and partition the table at the same time

Transactional replication latency issue

Unexplained log ship slow down

How to check for Non-Ascii Characters