All Articles - SQL Authority with Pinal Dave

Two complementary ceramic parts form one complete pouring vessel

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.

Gouache painting of a dish of paint being mixed beside a jar of pre-mixed paint with a vermilion lid

Compute Scalar Operators: Why a Computed Column Shows Two

July 11, 2020

Pinal Dave

SQL Performance

Computed Column, Execution Plan, SQL Operator, SQL Scripts

A plan that reads a computed column shows two Compute Scalar operators, and the second one looks like a mistake. This post compares three tables in the plan text: an expression in the query, a computed column and a persisted computed column. It shows what each of the Compute Scalar operators defines and whether the extra operator costs anything.

SQL Puzzle – Solution to Strange Results – IN and IS NOT NULL –

July 10, 2020

Pinal Dave

SQL Puzzle

SQL NULL, SQL Scripts, SQL Server

Earlier I had published a blog post about a puzzle SQL Puzzle – IN and IS NOT NULL – Strange Results. Today we will see a solution to strange results puzzle.