SQL Server 2017 has a wonderful feature which fixes a very old issue which DBA and developers have been struggling for a while. It would be impossible to find DBA or Developer who has not faced an issue when their identity column value has jumped or incremented by 1000. It is a very common issue and today we will see the solution of this issue with the help of IDENTITY_CACHE introduced in the latest version of SQL Server.
SQL SERVER – Performance Observation of TRIM Function
Earlier I wrote a blog post about how to remove leading and trailing spaces with TRIM function. SQL SERVER – 2017 – How to Remove Leading and Trailing Spaces with TRIM Function? After writing this blog post lots of people asked me its impact on SQL Server.
SQL SERVER – Compatibility Level 80 and Table Hint Behavior
It has been a while since I worked with SQL Server 2000. However, as an independent consultant, SQL Server never stops to surprise us. Recently, during one Comprehensive Database Performance Health Check, I found a very interesting situation which is about compatibility level 80. If you are not familiar with compatibility level, it sets database behaviors to be compatible with the specified version of SQL Server.
SQL SERVER – When to Turn On Optimize for Ad Hoc Workloads?
Today, I have very interesting scenario to share with all of you. This is a true story which I encountered in my recent Comprehensive Database Performance Health Check. It is about a very popular SQL Server setting Optimize for Ad Hoc Workloads.
SQL Authority News – SQL Server 2017 and Automatic Tuning
Earlier today in Ignite conference, Microsoft announced general availability of SQL Server 2017 on Oct 2. This is fantastic news. Lots of people are waiting for the latest version of SQL Server for a while. The matter of fact, many of my customers are using an earlier version of SQL Server are waiting to upgrade as soon as SQL Server 2017 is available to download. In this blog post I will talk about the feature I have been eagerly waiting to try out – Automatic Tuning.
SQL SERVER – Wait Stats Collection Scripts for 2016 and Later Versions
Yesterday I posted a blog about a new DMV, which is introduced in SQL Server 2016. You can read the blog post here: Get Wait Stats Related to Specific Session ID With sys.dm_exec_session_wait_stats. After reading the blog post, I have received quite a few emails about SQL Server Wait Stats Collection Scripts. One of the question was is my earlier script still valid to collect the SQL Wait Stats for SQL Server 2016 and Later Versions.
SQL SERVER – Get Wait Stats Related to Specific Session ID With sys.dm_exec_session_wait_stats
First thing first, this feature of getting wait stats related to Specific Session ID with sys.dm_exec_session_wait_stats will only work with SQL Server 2016 or later version of SQL Server. If you attempt to run this on earlier versions of SQL Server, you will for sure get an error.