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 3 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Maheshkumar S Tiwari edited Revision 54. Comment: minor edit

  • Naomi  N edited Revision 35. Comment: Running total

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

  • Naomi  N edited Revision 19. Comment: Formatting

  • Naomi  N edited Revision 14. Comment: Formatting

  • Naomi  N edited Revision 13. Comment: Formatting

Page 1 of 1 (6 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Hi Naomi,

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

    ,if it is worth adding

  • 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

  • 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

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

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

  • Thanks Naomi !! really useful article !!!

  • Naomi  N edited Revision 35. Comment: Running total

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

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

  • Naomi  N edited Revision 19. Comment: Formatting

  • Naomi  N edited Revision 14. Comment: Formatting

  • Naomi  N edited Revision 13. Comment: Formatting

Page 1 of 1 (12 items)