SQL Server Education (by the geeks, for the geeks)
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 MoreWhen 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 MoreString 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 MoreRecently 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 MoreResumable 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 MoreThose 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 MoreI 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 MoreLast 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 MoreThis 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 MoreSQL 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