Pinal Dave

Find Expensive Queries - SQL in Sixty Seconds 159

Read Only Tables - Is it Possible? - SQL in Sixty Seconds 179

Tuning Query Cost 100% - SQL in Sixty Seconds 181

Priority Boost and Performance - SQL in Sixty Seconds 131

Query Ignoring CPU Threads - SQL in Sixty Seconds 161

Install MongoDB on Windows - SQL in Sixty Seconds 091

Performance Battle: Single Scan for Count and Sum - SQL in Sixty Seconds 178

Wait Stats for Performance - SQL in Sixty Seconds 157

Install SQL Server 2016 Sample Database WideWorldImporters - SQL in Sixty Seconds #081

Get Date and Time From Current DateTime - SQL in Sixty Seconds #025

Reset SA Password - SQL in Sixty Seconds #066

Where are Table Variables Stored? - SQL in Sixty Seconds 095

Three Methods to Insert Multiple Rows into Single Table - SQL in Sixty Seconds #024

Resolving SQL Server Connection Errors - SQL in Sixty Seconds #030

TOP DISTINCT - Epic Confusion - SQL in Sixty Seconds 141

Excel - SUM vs SUBTotal - SQL in Sixty Seconds 167

9 SQL Server Performance Tuning Tips - SQL in Sixty Seconds 168

Difference Between Login and User - SQL in Sixty Seconds #070

Compressed Backup - Performance - SQL in Sixty Seconds 196

Importing CSV into SQL Server - SQL in Sixty Seconds #018

Performance: Between and Other Operators - SQL in Sixty Seconds 191

Line Numbers for Efficiency - SQL in Sixty Seconds 147

Arrow in Execution Plan - SQL in Sixty Seconds 136

Possible to Rollback TRUNCATE? - SQL in Sixty Seconds 105

Shortcut to SELECT Single Row from Table - SQL in Sixty Seconds #046

Finding Object Dependencies in SSMS - SQL in Sixty Seconds #071

Index Used for Query - SQL in Sixty Seconds 088

Email an Execution Plan - SQL in Sixty Seconds 114

MAX Columns Ever Existed in Table - SQL in Sixty Seconds 182

Swap Columns - SQL in Sixty Seconds 199

Install and Configure SQL Server 2017 In 100 Seconds

Single Column Single Row and TABLE SCAN - SQL in Sixty Seconds 111

Find Missing Identity - SQL in Sixty Seconds 195

Rebuild All Indexes for a Single Table - SQL in Sixty Seconds

Query to Find Row and Index Count of Database Tables - SQL in Sixty Seconds

Sleeping vs Suspended Process - SQL in Sixty Seconds 122

Resolve Cannot Resolve Collation Conflict Error - SQL in Sixty Seconds

Attach or Detach Database - SQL in Sixty Seconds

T-SQL Constructs - += and *= - SQL in Sixty Seconds

Copy Data from One Table to Another Table - SQL in Sixty Seconds

Wrap SQL Code in SSMS - SQL in Sixty Seconds

Recover Crashed Query in SSMS - SQL in Sixty Seconds 116

Hide Code in SSMS - SQL in Sixty Seconds 154

Infinite Loop - SQL in Sixty Seconds 144

Get Memory Details - SQL in Sixty Seconds 165

Uninstall SQL Server 2019 Instance - SQL in Sixty Seconds 093

SUM(1) vs COUNT(1) Performance Battle - SQL in Sixty Seconds 177

Copy Database in SQL Server - SQL in Sixty Seconds 169

Generate Script of SQL Server Objects - SQL in Sixty Seconds 184

Restore SQL Database using SSMS - SQL in Sixty Seconds

Copy Database - SQL in Sixty Seconds