March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
Date Variable

Performance Troubles – Function on Date Variable – SQL in Sixty Seconds #192

January 18, 2022
Pinal Dave
SQL Video
SQL DateTime, SQL Function, SQL in Sixty Seconds, SQL Performance

However, I have a really good reason to use that. Today we are going to discuss Performance Troubles – Function on Date Variable.

Read More
Optimize DATE

Optimize DATE in WHERE Clause – SQL in Sixty Seconds #189

December 29, 2021
Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Performance

During Comprehensive Database Performance Health Check, I often get questions about how to Optimize DATE in the WHERE Clause.

Read More

Get Current Time Zone – SQL in Sixty Seconds #187

November 23, 2021
Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Scripts, SQL Server

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.

Read More
timezone

SQL SERVER – List All Available TimeZone

October 29, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

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.

Read More
Unix TimeStamp

SQL SERVER – Converting Unix TimeStamp to DateTime

October 20, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

There is a very easy method to convert Unix TimeStamp to DateTime. Let us learn that in today’s blog post. 

Read More
Date from Traces

SQL SERVER – Identify Table Creation Date from Traces

October 11, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Extended Events, SQL Scripts, SQL Server, SQL Trace

I often discuss this during Comprehensive Database Performance Health Check. Let us learn about how to Identify Table Creation Date from Traces.

Read More
current date time

Current Date Time in Python and SQL

September 23, 2021
Pinal Dave
SQL Tips and Tricks
Python, SQL DateTime

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.

Read More
1 2 3 4 … 19 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version