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
Rebuild All Indexes for a Single Table – SQL in Sixty Seconds #086
Recently, while working with a client we ended up on a very interesting situation with a client where we had to Rebuild All Indexes for a Single Table.
SQL SERVER – Capturing Execution Plan for Canceled Query
I also discover new aspects of SQL Server. One of DBA recently asked is there any way to capture the execution plan for the canceled query.
How to Check Database Performance Facets in SQL Server? – Interview Question of the Week #270
Question: How to Check Database Performance Facets in SQL Server?
It is very simple to find out the facets of SQL Server Just follow the diagrams listed.
SQL SERVER Management Studio – Rebuild All Indexes on Table
We are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where we will learn how to rebuild all indexes.
SQL SERVER – Displaying Smiley in SSMS – Emoji
Recently I had an interesting conversation with my client about Emoji in SQL Server. It is possible to create your database with any emoji.
SQL SERVER – Stream Aggregate and Hash Aggregate
Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.