Developers & DBAs who spend a lot of their time writing TSQL queries.
TSQL was voted best programming language in 2013, let’s explore why!
In this session we will look at what make SQL such a fascinating language. We will do this by working through a few real life development problems and common design challenges based on real questions asked on Ask.SQLServerCentral.com.
What in particular will we look at? Well… Tally tables, CURSORS, hidden CURSORS, CTEs, Recursive CTE, Manual Pivot, TSQL Pivot, CROSS JOIN, CROSS APPLY, CORRELATED QUERIES, STUFF(), RANK(),GO, DENSE_RANK(),LAG(), LEAD(), ROW_NUMBER(), XML PATH, MOD %, STRING_AGG(), DBCC DROPCLEANBUFFERS, DBCC FREEPROCCACHE, STATISTICS IO & TIME. (A bit of TSQL)
Why I Want to Present This Session:
You do not often get to see a session where someone talks exclusively about TSQL and more importantly why TSQL is great. This session is designed to improve the way you tackle problems in TSQL. I would like to share these tips to make you a better TSQL developer.