Functions and Missing Indexes - SQL in Sixty Seconds 204
3 ChatGPT Tricks to Tune SQL Server - SQL in Sixty Seconds 203
Deceptive Execution Plan - SQL in Sixty Seconds 202
Function in the WHERE Clause - SQL in Sixty Seconds 201
Parameter Sensitive Plan optimization - SQL in Sixty Seconds 200
Swap Columns - SQL in Sixty Seconds 199
Find Database File Latency - SQL in Sixty Seconds 198
Indexing for Delete - SQL in Sixty Seconds 197
Compressed Backup - Performance - SQL in Sixty Seconds 196
3 Important Features - Monitoring Your Database Servers
Find Missing Identity - SQL in Sixty Seconds 195
Remove Key Lookup - SQL in Sixty Seconds 194
Using Stored Procedure in SELECT - SQL in Sixty Seconds 193
5 Questions Answered - Comprehensive Database Performance Health Check
Performance Troubles - Function on Date Variable - SQL in Sixty Seconds 192
Performance: Between and Other Operators - SQL in Sixty Seconds 191
Most Used Database Files - SQL in Sixty Seconds 190
Optimize DATE in WHERE Clause - SQL in Sixty Seconds 189
Data Compression for Performance - SQL in Sixty Seconds 188
Get Current Time Zone - SQL in Sixty Seconds 187
Detecting Memory Pressure - SQL in Sixty Seconds 186
CPU Running 100% - SQL in Sixty Seconds 185
Generate Script of SQL Server Objects - SQL in Sixty Seconds 184
Prevent Unauthorized Index Modifications - SQL in Sixty Seconds 183
MAX Columns Ever Existed in Table - SQL in Sixty Seconds 182
SQL Performance Troubles - Execution Plans - Live 2
Tuning Query Cost 100% - SQL in Sixty Seconds 181
Fixing SQL Performance Troubles - Live 1
Queries Using Specific Index - SQL in Sixty Seconds 180
Read Only Tables - Is it Possible? - SQL in Sixty Seconds 179
Performance Battle: Single Scan for Count and Sum - SQL in Sixty Seconds 178
SUM(1) vs COUNT(1) Performance Battle - SQL in Sixty Seconds 177
COUNT(*) and COUNT(1): Performance Battle - SQL in Sixty Seconds 176
COUNT(*) and Index - SQL in Sixty Seconds 175
Index SCANs - Good or Bad? - SQL in Sixty Seconds 174
Optimize for Ad Hoc Workloads - SQL in Sixty Seconds 173
Avoid Join Hints - SQL in Sixty Seconds 172
One Query Many Plans - SQL in Sixty Seconds 171
Best Value for Maximum Worker Threads - SQL in Sixty Seconds 170
Copy Database in SQL Server - SQL in Sixty Seconds 169
9 SQL Server Performance Tuning Tips - SQL in Sixty Seconds 168
Excel - SUM vs SUBTotal - SQL in Sixty Seconds 167
3 Ways to Configure MAXDOP - SQL in Sixty Seconds 166
Get Memory Details - SQL in Sixty Seconds 165
Get CPU Details - SQL in Sixty Seconds 164
Shutdown SQL Server Via T-SQL - SQL in Sixty Seconds 163
SQL Server on Linux - SQL in Sixty Seconds 162
Query Ignoring CPU Threads - SQL in Sixty Seconds 161
Bitwise Puzzle - SQL in Sixty Seconds 160
Find Expensive Queries - SQL in Sixty Seconds 159
