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
statistics time

SET STATISTICS TIME ON – SQL in Sixty Seconds 139

October 27, 2020
Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Statistics

Do you know how long your query took to execution? Well, let us learn that today in SQL in Sixty Seconds. We will discuss SET STATISTICS TIME ON.

Read More
day name

SQL SERVER – Finding Day Name from Date

July 27, 2020
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

In today’s blog post we will a very simple script where we will find day name from any valid date. There are multiple ways you can do it.

Read More
Combine Time Date

How to Combine Time and Date in SQL SERVER? – Interview Question of the Week #285

July 12, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL DateTime, SQL Function, SQL Scripts, SQL Server

Question: How to Combine Time and Date in SQL SERVER?

Answer: A very simple and popular question. Let us learn together.

Read More
devaroundthesun

SQL SERVER – Resources for DevAroundTheSun Session

May 13, 2020
Pinal Dave
SQLAuthority News
Presentation, SQL DateTime

Dev Around The Sun is a technology event with tech talks and human skills talks. In this blog post, we will see important resources for DevAroundTheSun.

Read More

SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period

March 7, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Server DBCC

Recently I got a very unique situation where I had to Remove All Query Cached Plans Not Used In Certain Period. Let us learn about that today. 

Read More
print statement

SQL SERVER – PRINT Statement and Format of Date Datatype

August 23, 2019
Pinal Dave
SQL Tips and Tricks
File format, SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL String

we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about PRINT Statement and DataType.

Read More
DATETIMEFROMPARTS

SQL SERVER – Building Date and Time with DATETIMEFROMPARTS()

August 17, 2019
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server, SQL String

Today we will have very simple learning about Building Date and Time with DATETIMEFROMPARTS(). We will build the DateTime using a function.

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

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

Go to mobile version