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

Permitted no of bytes per row

Creating a Date Range from Multiple Rows Based on a Single Date

When you've got only a single effective date on a record and you need to artificially create the effective end date based on a following row in T-SQL, the techniques discussed in this article will help you decide what is best.