T-SQL Useful Links

T-SQL Useful Links

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


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


Questions and Surveys - random order

See Also

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

Sort by: Published Date | Most Recent | Most Useful
  • Great article! We sometimes call these "Survival Guides". But the person who led us in "branding" them that way is gone now, so we can call them whatever we want. =^)

  • Thanks Naomi !! really useful article !!!