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.
SQL Terms vs MongoDB Terms
This blog post is a bit of a different post than the normal blog posts which I write as the topic of this blog post is SQL Terms vs MongoDB Terms.
SQL SERVER – Multiple Miscellaneous Option – Bugs Fixed by SSMS Team
Today we will talk about Multiple Miscellaneous Option – Bugs Fixed by SSMS Team. I would like to say this is indeed the Impact of SQLAuthority.
SQL SERVER – Scrollbar in the Middle – Bugs Fixed by SSMS Team
I realized that one of the things for which I used to make fun of SSMS is no longer available – Scrollbar in the Middle – Bugs Fixed by SSMS Team
SQL SERVER – Product Key for Developer Edition, Enterprise Evaluation Edition and Express Edition
In this blog, I would share my findings and Product Key for Developer Edition, Enterprise Evaluation Edition, and Express Edition.