Skip to content
February 7, 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

Author: Sandip Pani

SQL Server

Explore statistics histogram using SQL Server 2017

October 7, 2017November 7, 2017 - by Sandip Pani - Leave a Comment

Prior to SQL Server 2016 SP1 CU2, we need to use DBCC SHOW_STATISTICS WITH HISTOGRAM to read Statistics histogram of a specific statistics. Since it is a DBCC command in order …

Explore statistics histogram using SQL Server 2017 Read More
SQL Server

SQL SERVER 2017 – IDENTITY_CACHE

September 25, 2017November 7, 2017 - by Sandip Pani - Leave a Comment

When we define a table with Identity column, SQL Server might cache the identity values to improve performance. Due to server restart or database failure some assigned values may be lost.  …

SQL SERVER 2017 – IDENTITY_CACHE Read More
SQL Server

SQL Server 2017 New String Function – CONCAT_WS

September 16, 2017November 6, 2017 - by Sandip Pani - Leave a Comment

String manipulation is one of the common requirement for every project. There are many String functions already available in SQL Server but in SQL Server 2017 has some more string functions …

SQL Server 2017 New String Function – CONCAT_WS Read More
SQL Server

Compare Query plan using SSMS

May 6, 2017 - by Sandip Pani - 1 Comment

Recently Microsoft released SSMS 17.0. This release of SSMS supports SQL Server 2017 for both running on Windows and Linux. In this release Microsoft has added new features as well as …

Compare Query plan using SSMS Read More
SQL Server

Resumable Online Index Rebuild- SQL Server 2017

April 27, 2017May 3, 2017 - by Sandip Pani - 2 Comments.

Resumable online index rebuild is one of the very useful feature of SQL Server 2017 for DBA’s. Now it is possible to pause an Index Rebuild. It allows to resume an …

Resumable Online Index Rebuild- SQL Server 2017 Read More
SQL Server

Database Scoped Configurations and Trace flag 4199

April 16, 2017April 16, 2017 - by Sandip Pani - Leave a Comment

Those who are working on query performance whether you are a DBA or Developer I am sure you guys must have used trace flag 4199.  TF 4199 enables all query optimizer …

Database Scoped Configurations and Trace flag 4199 Read More
SQL Server

CAST function doesn’t change execution plan for Datetime type column

March 28, 2017March 31, 2017 - by Sandip Pani - 2 Comments.

I have been reviewing code from last couple of years. I found some myths are followed very strictly by developers. Yesterday while reviewing, I found developers are hesitating to use TRY_CAST …

CAST function doesn’t change execution plan for Datetime type column Read More
SQL Server

Sp_Recompile – does it work the way you expect?

March 22, 2017March 30, 2017 - by Sandip Pani - Leave a Comment

Last week I was working on an assignment where I need to recompile all stored procedure where ever it is refereeing to a certain table. There are many options to recompile …

Sp_Recompile – does it work the way you expect? Read More
SQL Server

DBCC CloneDatabase

March 15, 2017March 31, 2017 - by Sandip Pani - Leave a Comment

This blog was due from a long time.  With the release of SQL Server 2014 Service pack 2, a new DBCC command included that is DBCC CloneDatabase. My primary job role …

DBCC CloneDatabase Read More
SQL Server

New Function String_Split in SQL Server 2016

March 8, 2017April 1, 2017 - by Sandip Pani - Leave a Comment

SQL Server 2016 has many features which makes developer life bit easy to do various task. Earlier to split a string developer use to write a user defined function using temp …

New Function String_Split in SQL Server 2016 Read More

Posts navigation

1 2 … 4 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.