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.

Some links in this article may be outdated and no longer working :( If you find such link, please update the article with correct reference or remove it.

T-SQL Resources for Beginners and not so...

Select Top N Rows per Group

Performance Optimization

EXECUTE vs sp_ExecuteSQL

SQL Server Internals

↑ Return to Top

Dynamic Search

Option recompile


Calendar table

↑ Return to Top

Gaps and Islands


Parameter Sniffing 

↑ Return to Top


Information about All objects 

↑ Return to Top

String Manipulations

String Split


↑ Return to Top

Concatenate Rows

Common Table Expression (CTE)

CTE Performance

CTE syntactic sugar

CTE versus Temp Table

↑ Return to Top


↑ Return to Top

Running Total


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


MSSQL install on Linux

Questions and Surveys - random order

See Also

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