T-SQL Useful Links

T-SQL Useful Links

This article will share collection of links in regards to various aspects in Transact-SQL language I acquired over the years and saved in links.txt file. 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 Performance

CTE syntactic sugar

CTE versus Temp Table 

↑ Return to Top

PIVOT


UNPIVOT

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 participates in the TechNet Guru for September competition.

Leave a Comment
  • Please add 4 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Comments
  • Naomi  N edited Revision 13. Comment: Formatting

  • Naomi  N edited Revision 14. Comment: Formatting

  • Naomi  N edited Revision 19. Comment: Formatting

  • Maheshkumar S Tiwari edited Revision 54. Comment: minor edit

  • Naomi  N edited Revision 30. Comment: Added return to top

  • Naomi  N edited Revision 35. Comment: Running total

Page 1 of 1 (6 items)
Wikis - Comment List
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Naomi  N edited Revision 13. Comment: Formatting

  • Naomi  N edited Revision 14. Comment: Formatting

  • Naomi  N edited Revision 19. Comment: Formatting

  • Maheshkumar S Tiwari edited Revision 53. Comment: minor edit

  • Maheshkumar S Tiwari edited Revision 54. Comment: minor edit

  • Naomi  N edited Revision 30. Comment: Added return to top

  • Naomi  N edited Revision 35. Comment: Running total

  • Thanks Naomi !! really useful article !!!

  • Naomi, do you want us to add some more links here? This topic can fill a book as the internet is full with helpful blogs :-)

    i added under the "bulk insert" topic my new article which i just post some min ago: "Using Bulk Insert to import inconsistent data format (using pure T-SQL)"

    i hope this is OK

  • Yes, good links should be added. I have another article that lists only TechNet T-SQL related articles

    social.technet.microsoft.com/.../17785.sql-server-query-language-transact-sql.aspx

  • Hi Naomi,

    Please include this under XML - www.allaboutmssql.com/.../blog-page_24.html

    ,if it is worth adding

  • 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. =^)

Page 1 of 1 (12 items)