Все публикации

0:06:38

tempdb System Database importance and configuration

0:08:18

SQL Server Trouble Shooting using Single User Mode

0:16:33

Performance optimization using wait stats( an important technique for performance related issues)

0:09:17

Constant Folding (optimization of some constant expressions )

0:11:44

Select Query process & optimization through Database Engine

0:11:33

Query Optimization and Select Query Analysis

0:06:48

Select Query Operators and Logical Operators Precedence

0:05:24

Batch Model Execution (Query Execution Methods in Query Plan)

0:06:14

Query Execution Methods(Row Execution Method) in SQL Server

0:04:42

Alter Index Rebuild (Index maintenance method)

0:05:49

Comparison between Rebuild VS Reorganize Index method.

0:07:36

Alter Index Rebuild Demo using SQL Server management studio

0:10:36

Alter Index Reorganize Demo using SSMS.

0:02:58

Alter Index Reorganize(Index maintenance method)

0:00:47

Index Maintenance Methods

0:02:33

Low page density and its problems(index Performance Issue)

0:03:16

Low Page Density ( a big Index Performance Issue)

0:09:58

Demo of Index Fragmentation ( An Index Scan Problem)

0:02:16

Fragmentation problems in SQL Server index

0:03:21

logical/External Vs Internal Fragmentation in SQL Server Index

0:04:45

Fragmentation in SQL Server Index

0:11:48

Read-Ahead Demo (how it works in SQL Server using Index Scan)

0:07:57

Read-ahead mechanism for Index Scanning

0:04:26

Allocation Order Scans or Physical Scan in SQL Server Index Structure