Skip to content
February 6, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: SQL Server

SQL Server

SQL Server – ROW_NUMBER versus TOP N

May 7, 2017May 9, 2017 - by Prince Rastogi - 1 Comment

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 …

SQL Server – ROW_NUMBER versus TOP N Read More
SQL Server

SQL Server Index Hint

July 2, 2016October 25, 2016 - by Sandip Pani - Leave a Comment

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 …

SQL Server Index Hint Read More
SQL Server

Backup and Restore Sequence in SQL Server

October 22, 2015July 3, 2020 - by Manohar Punna - Leave a Comment

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 …

Backup and Restore Sequence in SQL Server Read More
SQL Server

Changes in In-Memory OLTP in SQL Server 2016

July 23, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

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 …

Changes in In-Memory OLTP in SQL Server 2016 Read More
SQL Server

SQL Server Integration Services – An Alternate to Slowly Changing Dimensions

July 19, 2015July 20, 2015 - by Mridul Chandhok - 3 Comments.

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 …

SQL Server Integration Services – An Alternate to Slowly Changing Dimensions Read More
SQL Server

Introduction To Query Store In SQL Server 2016 – Part 1

July 16, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

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 …

Introduction To Query Store In SQL Server 2016 – Part 1 Read More
SQL Server

Introduction To Dynamic Data Masking In SQL Server 2016

July 9, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

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 …

Introduction To Dynamic Data Masking In SQL Server 2016 Read More
SQL Server

FOR JSON Clause Mode With ROOT Option In SQL Server 2016

July 6, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

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 …

FOR JSON Clause Mode With ROOT Option In SQL Server 2016 Read More
SQL Server

FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016

July 3, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

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 …

FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016 Read More
SQL Server

FOR JSON Clause With PATH Mode In SQL Server 2016

July 2, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

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 …

FOR JSON Clause With PATH Mode In SQL Server 2016 Read More

Posts navigation

1 2 … 28 Next

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.