T-SQL Learning Guide
Transact-SQL (T-SQL) is no stranger to the SQL Server developer or DBA, but that's no excuse not to become more familiar. Improve your T-SQL skills with these T-SQL overviews, best practices and stored procedures.
Transact-SQL (T-SQL) is Microsoft's enhanced version of the Structured Query Language (SQL) that includes transaction control, exception handling, error handling, row processing and more. SQL Server applications must be using T-SQL statements to communicate with the server, but how your T-SQL is written and run can ultimately impact your server performance. This learning guide offers you an introduction to all things T-SQL, from basic...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
definitions to handy stored procedures to best and worst practices.
If you have T-SQL questions not addressed in this learning guide, visit Ask the SQL Server Expert to pose a question to development guru Greg Low. If you have your own handy stored procedures and T-SQL tricks, e-mail us and we'll post them on SearchSQLServer.com for all your peers to see.
T-SQL 101
Handy T-SQL stored procedures
- Top five T-SQL stored procedures
- Fast Guide: Undocumented stored procedures
- Fast Guide: Stored procedures
- Stored procedure: Generate code for ad-hoc data operations
- Stored procedure: Easily filter for SQL Server connections
- Stored procedure: Determine last database backup
- Function to determine which service pack is installed
- A surrogate key architecture to perform powerful database operations
T-SQL best and worst practices
- T-SQL batch processing rules for SQL Server
- How to restore SQL Server using T-SQL
- Exception handling best practices in SQL Server 2005
- How to optimize triggers in SQL Server 2000
- Pitfalls of using T-SQL cursors
- T-SQL performance problems and solutions
- Vulnerable stored procedures
- Working with Oracle stored procedures, applications and data
T-SQL in SQL Server 2005
- What's new with T-SQL in SQL Server 2005
- Writing stored procedures without knowing T-SQL
- Backward compatibility issues when upgrading to SQL Server 2005
- Upgrading stored procedures in SQL Server 2005
- Tuning stored procedures: Structured exception handling in SQL Server 2005
- SQL Server 2005 DMVs: Exposing the state of your server
T-SQL debugging
T-SQL querying
- Find and fix resource-intensive SQL Server queries
- Query Analyzer: 10 tricks for simple querying
- Run a T-SQL query to loop through all databases
- Resolving a query error
- Tracking query execution with SQL Server 2005 Profiler
More on T-SQL
Learn T-SQL formatting tricks for SQL Server 2012
Read about T-SQL functions in SQL Server 2012
Find the joy of data values with SQL Server 2012
Dig deeper on SQL-Transact SQL (T-SQL)
Pro+
Features
Enjoy the benefits of Pro+ membership, learn more and join.
0 comments
Oldest Newest