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.

OPENQUERY-1

One size does not fill all

Allowing your application to generate your SQL can be a really bad decision.

Stairway to T-SQL: Beyond The Basics Level 3: Building a Correlated Subquery

This stairway level will expand on the subquery topic by discussing a type of subquery known as a correlated subquery, and explores what a correlated subquery is and how it is different from a normal subquery.

Order By Column