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.
Current Date Time in Python and SQL
After installing and getting started with Python, the very first exercise I did was to print the current date time in Python. Let us learn about it today.