Feb 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
Business Days

SQL SERVER – Find Business Days Between Dates

July 5, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

I often receive a very common question during my Comprehensive Database Performance Health Check about how to find Find Business Days Between Dates.

Read More
cultures FORMAT

SQL SERVER – Display Dates in Different cultures FORMAT

May 31, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.

Read More
date null

SQL SERVER – CONVERT Empty String To Null DateTime

May 6, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL NULL, SQL Scripts, SQL Server, SQL String

Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.

Read More
AT TIME ZONE

SQL SERVER – Convert Date Time AT TIME ZONE

February 22, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

My client last week about Comprehensive Database Performance Health Check. The question was how to Convert Date Time AT TIME ZONE.

Read More
list all dates

SQL SERVER – List All Dates Between Start and End Date

January 13, 2021
Pinal Dave
SQL Tips and Tricks
CTE, SQL DateTime, SQL Scripts, SQL Server

We will see a very simple script where we will take advantage of the Common Table Expression and list all dates between two dates (Start and End Date).

Read More
Convert Formatted

SQL SERVER – Convert Formatted Integer Values into Date

December 9, 2020
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

One of my clients of  Comprehensive Database Performance Health Check asked me a question about how to Convert Formatted Integer Values into Date.

Read More
insert timestamp

SQL SERVER – Capturing INSERT Timestamp in Table

November 23, 2020
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL DateTime, SQL Scripts, SQL Server

The other day while working on a topic of  Comprehensive Database Performance Health Check recently asked if I know any trick for capturing insert timestamp.

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

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

Go to mobile version