All Articles - SQL Authority with Pinal Dave

SQL SERVER – Capturing INSERT Timestamp in Table

November 23, 2020

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.

5 SQL in Sixty Seconds Video on SSMS Efficiency

November 20, 2020

Pinal Dave

SQL Video

SQL in Sixty Seconds, SQL Server Management Studio, SSMS

I make my living by Comprehensive Database Performance Health Check and one of the constant struggles which I see of my client is to use SSMS Efficiency.

SQL SERVER – Configurable KeyBoard Query Shortcuts for SSMS

November 19, 2020

Pinal Dave

SQL

SQL Server Management Studio, SQL Shortcut, SSMS

Today we will learn something very simple but fun stuff for SQL Server Management Studio (SSMS) which is about Configurable KeyBoard Query Shortcuts.

SQL SERVER – Logical Processing Order of the SELECT Statement

November 18, 2020

Pinal Dave

SQL

Logical Processing Order, SQL Operator, SQL Performance, SQL Scripts, SQL Server

Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.

SQL SERVER – Disable Statistics Update for a Single Table

November 17, 2020

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL Server Configuration, SQL Statistics

Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?

PostgreSQL Learning Path at Pluralsight

November 16, 2020

Pinal Dave

SQL

Pluralsight, PostgreSQL

Today I want to share PostgreSQL Learning Path at Pluralsight where you can learn this technology systematically. PostgreSQL is known as Postgres as well.