Dynamic T-SQL and Benefits of its Usage
In our projects, we have to cope with different tasks. To solve some of them, we use dynamic T-SQL....
New Query Hints Including USE HINT in SQL Server 2016 SP
This article is an introduction to the query hint overview that appeared in SQL Server 2016 SP1. There are many different thoughts on using...
SQL Server 2016: New T-SQL Features
In this article, I would like to describe several new T-SQL features available in SQL Server 2016: DROP IF EXISTS, SESSION_CONTEXT, MAXDOP,...
How to Pass Parameters in Dynamic T-SQL Query
Developers are often faced with the need to build a dynamic query, however, there are a number of...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
