Let us learn How to Convert Month Number to Month Name. WE will see three methods in this blog post.
Performance Troubles – Function on Date Variable – SQL in Sixty Seconds #192
However, I have a really good reason to use that. Today we are going to discuss Performance Troubles – Function on Date Variable.
Optimize DATE in WHERE Clause – SQL in Sixty Seconds #189
During Comprehensive Database Performance Health Check, I often get questions about how to Optimize DATE in the WHERE Clause.
Get Current Time Zone – SQL in Sixty Seconds #187
Lots of people often ask me how to get the current time zone in SQL Server when I am working on Comprehensive Database Performance Health Check.
SQL SERVER – List All Available TimeZone
Let me ask you a quick question – how many timezone SQL Server supports? The answer is for SQL Server 2019 it is 141. Yes, it is true.
SQL SERVER – Converting Unix TimeStamp to DateTime
There is a very easy method to convert Unix TimeStamp to DateTime. Let us learn that in today’s blog post.Â
SQL SERVER – Identify Table Creation Date from Traces
I often discuss this during Comprehensive Database Performance Health Check. Let us learn about how to Identify Table Creation Date from Traces.