Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

T-SQL User-Defined Functions: Ten Questions You Were Too Shy To Ask

SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get asked on the forums. It's a shame, because the answers to them tend to clear up some ingrained misconceptions about functions that can lead to problems, particularly with locking and performance

Temp table limitations

Bean Counting

Paginating a SQL query result set

How to Paginate a query result set to keep from pulling the whole result set to the client side

GO-ING nowhere

Divide and Conquer - Performance Tuning

Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance

Count all records the tables

Count all the records from the tables that exist in a database

TABLESAMPLE output

OPENQUERY-2