34 тысяч подписчиков
217 видео
Find Expensive Queries - SQL in Sixty Seconds 159
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
5 Questions Answered - Comprehensive Database Performance Health Check
Remove Key Lookup - SQL in Sixty Seconds 194
Attach Database Without Log File - SQL in Sixty Seconds
Get Current Time Zone - SQL in Sixty Seconds 187
Rename Columnname or Tablename - SQL in Sixty Seconds
Performance Troubles - Function on Date Variable - SQL in Sixty Seconds 192
3 ChatGPT Tricks to Tune SQL Server - SQL in Sixty Seconds 203
Deceptive Execution Plan - SQL in Sixty Seconds 202
Indexing for Delete - SQL in Sixty Seconds 197
Functions and Missing Indexes - SQL in Sixty Seconds 204
SQL Performance Troubles - Execution Plans - Live 2
Alter Index Add Column - Workaround - SQL in Sixty Seconds 097
Optimize DATE in WHERE Clause - SQL in Sixty Seconds 189
Best Value for Maximum Worker Threads - SQL in Sixty Seconds 170
Using Stored Procedure in SELECT - SQL in Sixty Seconds 193
Function in the WHERE Clause - SQL in Sixty Seconds 201
Index SCANs - Good or Bad? - SQL in Sixty Seconds 174
Avoid Join Hints - SQL in Sixty Seconds 172
3 Important Features - Monitoring Your Database Servers
Transactions and Variables - SQL in Sixty Seconds 150
Most Used Database Files - SQL in Sixty Seconds 190
Detecting Memory Pressure - SQL in Sixty Seconds 186
Parameter Sensitive Plan optimization - SQL in Sixty Seconds 200
3 Answers Every Performance Tuning Experts Always Seeking
Find Database File Latency - SQL in Sixty Seconds 198
Subquery to CTE - SQL in Sixty Seconds
