SQL-Transact SQL (T-SQL)
T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error handling, row processing, and declared variables.. See complete definition.
T-SQL
SQL-Transact SQL (T-SQL) News
-
July 09, 2015
09
Jul'15
Limited public preview opens for Azure SQL Data Warehouse
Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.
-
May 13, 2005
13
May'05
Step 3: Consider using implicit transactions
Get up to speed on server-level options to add another layer of integrity protection.
SQL-Transact SQL (T-SQL) Get Started
Bring yourself up to speed with our introductory content
-
An introduction to SQL Server 2016 dynamic data masking
An expert provides a step-by-step guide for how to use dynamic data masking in SQL Server 2016 CTP2 and Azure SQL database to protect sensitive data. Continue Reading
-
SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT
In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here. Continue Reading
-
How to create a SQL inner join and outer join: Basics to get started
When you're querying a SQL Server database and want to pull related data from more than one table, you'll need to create a join, and here's how. Continue Reading
Evaluate SQL-Transact SQL (T-SQL) Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
Microsoft SQL Server 2016: Previews show promise for next year
Microsoft SQL Server 2016 will be released next year. But in 2015, we've already had a glimpse into improved in-memory OLTP, security features, analytics and Stretch Database. Continue Reading
-
How to get started with PolyBase in SQL Server 2016
With PolyBase, when you use SQL Server 2016 as your data source, you have easy access to Hadoop and Azure Blob Storage data from whatever environment you're working in. Continue Reading
-
Comparing memory-optimized tables and disk-based tables
In all tests performed by expert Basit Farooq, memory-optimized tables outperformed disk-based tables by running faster and generating less disk I/O. Continue Reading
Manage SQL-Transact SQL (T-SQL)
Learn to apply best practices and optimize your operations.
-
How to set up the SQL Server buffer pool extension feature
SQL Server 2014 includes the buffer pool extension feature, which can speed up query performance. Ashish Mehta explains the benefits of the feature and how to enable and disable it. Continue Reading
-
Upgrade SQL Server 2014 SP1 in eight steps
Upgrade from SQL Server 2008 R2 to SQL Server 2014 SP1 using backup and restore. This eight-step plan takes you through everything from log backups to end-to-end testing. Continue Reading
-
In-memory OLTP reborn with SQL Server 2016
Microsoft's in-memory OLTP needed improvements, and they are here with SQL Server 2016. Learn about the enhancements to this query-boosting feature. Continue Reading
Problem Solve SQL-Transact SQL (T-SQL) Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
-
Troubleshoot SQL Server database performance with T-SQL
Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications. Continue Reading
-
Create a user-defined server role in SQL Server 2012 with T-SQL, SSMS
Ashish Mehta shows two ways – with T-SQL and with SSMS -- to make a user-defined server role in SQL Server 2012. Continue Reading
-
Can SQL combine tables like these? Doubtful
Can SQL combine tables where the values don't relate to one another? One expert says it's difficult unless you redesign the tables. Continue Reading