This article will share collection of links in regards to various aspects in Transact-SQL language. Many of these links come very handy answering various questions in SQL Server related forums.


Select Top N Rows per Group

Performance Optimization

EXECUTE vs sp_ExecuteSQL

SQL Server Internals

↑ Return to Top

Dynamic Search

Option recompile

Dates

Calendar table

↑ Return to Top

Gaps and Islands

Concurrency

Parameter Sniffing 

↑ Return to Top

Cursors

Information about All objects 

↑ Return to Top

String Manipulations

String Split

XML

↑ Return to Top

Concatenate Rows

Common Table Expression (CTE)

CTE Performance

CTE syntactic sugar

CTE versus Temp Table

↑ Return to Top

PIVOT & UNPIVOT

↑ Return to Top

Running Total

ASP.NET

Other Topics

Design Decisions

Many tables JOIN calculation problem

Blocking problems

Structure change problem

NOT IN problem

JOIN problem 

Orphans check

Update Records in batch

UPDATE FROM

Questions and Surveys - random order


See Also


This article participated in the TechNet Guru for October competition and won the Gold prize.