Explore statistics histogram using SQL Server 2017
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 …
Read MoreAuthor: Sandip Pani
SQL SERVER 2017 – IDENTITY_CACHE
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. …
Read MoreSQL Server 2017 New String Function – CONCAT_WS
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 …
Read MoreCompare Query plan using SSMS
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 …
Read MoreResumable Online Index Rebuild- SQL Server 2017
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 …
Read MoreDatabase Scoped Configurations and Trace flag 4199
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 …
Read MoreCAST function doesn’t change execution plan for Datetime type column
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 …
Read MoreSp_Recompile – does it work the way you expect?
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 …
Read MoreDBCC CloneDatabase
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 …
Read MoreNew Function String_Split in SQL Server 2016
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 …
Read More