SSMS Archives - SQL Authority with Pinal Dave

SQL SERVER Management Studio – Rebuild All Indexes on Table

March 6, 2020

We are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where we will learn how to rebuild all indexes.

February 28, 2020

Recently I had an interesting conversation with my client about Emoji in SQL Server. It is possible to create your database with any emoji.

February 17, 2020

Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.

February 14, 2020

I would share my experience with SQL Server Management Studio (SSMS) install error – Setup is blocked due to another install currently running.

February 12, 2020

Recently during the Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.

February 7, 2020

During the recent consulting engagement of SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.

January 27, 2020

Just instead of US Dollar Sign ($), they wanted to display it with Indian Rupee Sign (₹). Let us learn today how we can Display Rupee Symbol in SSMS.