I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.
SQL SERVER Management Studio and SQLCMD Mode
Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today.Â
SQL SERVER – Turning OFF or ON Query Store for All the Database
There were two scripts that were very much asked and they are how to Turning OFF or ON Query Store for All the Database? Let us learn today.
SSMS – Bug – Execution Time-Out
While the new SSMS has fixed many bugs, there is one configuration setting about execution Time-out either does not seem to work.
SQL SERVER – SSMS – SET ROWCOUNT – Real-World Story
Let us today talk about SSMS Query Execution configuration for SQL Server where SET ROWCOUNT settings gave us an interesting challenge with query tuning.
SQL SERVER – sp_helpdb – Accidental Discovery
Recently while working with a client, I used a system stored procedure sp_helpdb and they were surprised that even something like this exists.Â
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using SQL Scripts
Whenever I end up on a situation where we have lots of blocking issues with my client, I depend on the script of the Blocking Tree.