SQL Server – ROW_NUMBER versus TOP N
Hello Friends, This blog post is the result of question asked by some professionals working on databases. While writing T-SQL code they generally use TOP N in the code to get the …
Read MoreTag: SQL Server
SQL Server Index Hint
SQL Server query optimizer decides which index to use, when a query is requested. SQL Server optimizer is a cost based optimizer so it picks the index which has low cost …
Read MoreBackup and Restore Sequence in SQL Server
Hello Geeks, The time is flying by as I rejoice in the aftermath of the SQLServerGeeks Annual Summit 2015. It has been a wonderful event and once in a life time …
Read MoreChanges 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 …
Read MoreSQL Server Integration Services – An Alternate to Slowly Changing Dimensions
Hi Friends, The blog post will teach you to achieve the same effect as slowly changing Dimension (SCD) transformation without using the SCD transformation of SSIS. The steps will guide you …
Read MoreIntroduction To Query Store In SQL Server 2016 – Part 1
Hi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL Server 2016 CTP 2.0. This is a very useful feature for …
Read MoreIntroduction 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 …
Read MoreFOR 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 …
Read MoreFOR 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 …
Read MoreFOR 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 …
Read More