Puzzle – Datatime to DateTime2 Conversation in SQL Server 2017

Earlier last week, I was presenting various questions about SQL Server 2017 at PASS in Seattle. However, during one of the session, I was fortunate to meet SQL Server Expert Christopher Savage. He shared a very interesting puzzle with me. I have been trying to solve the puzzle for a while, but I have no answer for it. Let us see the puzzle about DateTime2 Conversion in SQL Server 2017. 

Read More

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.

Read More

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.

Read More
Menu