It has been awhile since I asked any puzzle on SQLAuthority.com, Let us see a very simple puzzle today which involves execution plan as well.
SQL SERVER – SSMS 17.7 Observation – Two Miscellaneous Category in Database Property Options
First of all this observation is only applicable if you are using SSMS 17.7 build. It was very interesting to me that I was able to find two Miscellaneous categories in Database Property Option for SQL Server. Please note the version of SQL Server which I have connected to SSMS 17.7 is also SQL Server 2017. If you try following on any other SSMS version you may not get the same results.
SQL SERVER – Puzzle – How Does YEAR Function Work?
There are many different datetime related functions such as DAY, MONTH, YEAR, DATEDIFF, etc available in SQL Server. For example, YEAR function can be used to extract year value from a date.
SQL SERVER – Puzzle – SQL Server Stored Procedure and Unexpected Results
The matter of the fact when I discovered this puzzle related to the stored procedure and unexpected results, I was very much surprised as well.
SQL SERVER – Puzzle – How Does Table Qualifier Work in INSERT Statement?
Today’s puzzle is very interesting and I am confident that you will find that very interesting. Today’s puzzle is about Table Qualifier. I have not talked about this subject on my blog for a while, and I feel confident that you will like it very much.
SQL SERVER – Puzzle – Get the First Name From Full Name Without CHARINDEX
Recently I have been engaged with a customer where they were having a performance issue. They have engaged me via my offering Comprehensive Database Performance Health Check. While doing that, they asked me to write a better way to write a query. While I have given some suggestions and asked them to check, this looks like a nice puzzle to ask. So here we go to see the puzzle – Get the First Name From Full Name Without CHARINDEX.
SQL SERVER – Puzzle – Strange Behavior With Extra Comma in Create Table Statement
Today’s puzzle is very interesting and my favorite puzzle to ask right at the beginning of the presentation. This puzzle helps to break the ice between audience while people are still settling in the audience. Let us see my favorite puzzle of Strange Behavior With Extra Comma in Create Table Statement.