Log in | Register

Transact-SQL Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Transact-SQL Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Server 2016 – sys.dm_exec_input_buffer

Hi Friends,

DBCC INPUTBUFFER() is the TSQL command that we generally use to find out the submitted statement to the SQL Server Instance. Sometimes I use this command to troubleshoot the blocking scenario. If I know the session id of blocking and blocked session, then I can easily find out the TSQL statement/command passing that […]

T-SQL to create the File Group and Files

Hi Friends,

Below is the simple T-SQL to create File Group and Files for a database and adding multiple files under that file group. Here you can specify values as per your requirement like:

1- Database Name under which you wants to add file group.
2- Name of the file group.
3- Number of files, you wants to […]

Changes in In-Memory OLTP in SQL Server 2016

In SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced to work with memory-optimized tables rather than working with disk based tables to improve the performance.

But in SQL Server 2016 CTP2 release some enhancement are made to In-Memory OLTP features which are described below:

Features
SQL […]

Introduction To Dynamic Data Masking In SQL Server 2016

In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking.  Using Dynamic data masking we can provide the security to our restrictive data by masking the data from viewing to non-authorized users.

For example, we have credit card information in our table but we don’t want non-privileged […]

FOR JSON Clause Mode With ROOT Option In SQL Server 2016

Hi friends, we will continue with FOR JSON clause in this blog and today we will learn formatting of query using FOR JSON clause mode with ROOT option in SQL Server 2016.

As per BOL we need to specify ROOT option in query, when we want to add a single, top level element to the […]

FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016

Hi folks,

Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016. As we seen in previous blogs that when we used FOR JSON clause with AUTO and PATH mode NULL values were not included in the output.

To include the NULL values in JSON output we need […]

FOR JSON Clause With PATH Mode In SQL Server 2016

In previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we will learn formatting of query output using FOR JSON clause with PATH mode in SQL Server 2016.

Syntax for FOR JSON clause with PATH option is like this:

FOR JSON PATH

FOR JSON PATH clause is used […]

FOR JSON Clause With AUTO mode In SQL Server 2016

Hi friends, in release of SQL Server 2016 CTP2 one of the feature that introduced is JSON clause.

So first question that comes in everyone’s mind is What is JSON?

JSON stands for JavaScript Object Notation. JSON is a lightweight format which is used for storing and interchange the data. JSON uses standard javascript function to […]

sp_addextendedproperty – Day 2 – SQL Server System Stored Procedure

Hi friends, today in SQL server system stored procedure series we will look into stored procedure sp_addextendedproperty.

Sp_addextendedproperty stored procedure is used to create metadata about our database objects. Using this stored procedure we can put information about Sql server objects like name of developer who created the object, to track the version of objects […]

sp_who – Day 1 – SQL Server System Stored Procedure

Hi Folks, I am starting a new series system stored procedures in SQL Server. In this series you will learn about many useful stored procedures which we use in our day-to-day work and also explore and learn new system stored procedure in SQL Server 2014.

So, in my first blog post we will start with […]

Newsletter_Footer