SSMS can open a Rebuild All dialog for table indexes. An e-commerce customer discovered this shortcut during my health check.
Smiley in SSMS: Show Emoji in Results and Database Names
To show a smiley in SSMS, type the emoji inside an N-prefixed string and run the query. This post explains how SQL Server stores each emoji as two characters, why two different emoji can compare as equal, and how to find them in a column. It also shows what happens when an emoji is part of a database name.
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.
SQL SERVER – SSMS Install Error 0x80070652 – Setup is Blocked Due to Another Install Currently running. Please Let the Other Install Complete and then Restart the Computer if Necessary
SSMS install error 0x80070652 says setup is blocked due to another install currently running. Here is what fixed it for me.
Display Rupee Symbol in SSMS and T-SQL With FORMAT
To display rupee symbol and Indian digit grouping in SSMS, format the number with an Indian culture, or use the Unicode character 8377. This post compares en-IN, hi-IN, gu-IN and kn-IN, shows the nvarchar rule that keeps the symbol from turning into a question mark, and formats dates for the same cultures.
What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
SQL SERVER – Resolve WAIT_ON_SYNC_STATISTICS_REFRESH Wait Type
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.