Nested Transactions are Myth - SQL in Sixty Seconds 125

preview_player
Показать описание
Nested Transactions are Myth and let us learn that in this quick video.

0:00 Intro
0:12 Real-World Scenario
0:44 Demonstration of Nested Transactions are Myth
2:08 Summary
2:31 Tip on Trancount

#SQLServer #PerformanceTuning #SQLAuthority
  1. Pinal Dave
  2. SQL
  3. SQL Server
  4. SQLAuthority
  5. pinaldave
  6. Sixty Seconds
Рекомендации по теме
Nested Transactions are 0:02:44

Nested Transactions are Myth - SQL in Sixty Seconds 125

Nested Transactions in 0:07:32

Nested Transactions in T-SQL

MySQL : Total 0:01:18

MySQL : Total rollback on nested transactions

Can you have 0:00:35

Can you have a nested transaction

Transaction Modes in 0:18:29

Transaction Modes in SQL Server

Nested Transaction Model 0:02:02

Nested Transaction Model

Myths and Truths 1:10:17

Myths and Truths about SQL Server Transaction

SQL : Does 0:01:23

SQL : Does Postgres support nested or autonomous transactions?

Embracing Transactions • 0:32:45

Embracing Transactions • Reid Draper • GOTO 2016

Nested Transaction in 0:07:49

Nested Transaction in Distributed Computing

70-461 Test Prep 0:41:33

70-461 Test Prep - Transactions

Jayoti Vidyapeeth - 0:10:47

Jayoti Vidyapeeth - NESTED TRANSACTIONS

Nested Banking Transaction 0:07:39

Nested Banking Transaction

PREA MULȚI OAMENI 1:59:10

PREA MULȚI OAMENI PE TERRA? GHIȘEUL ÎNTREBĂRILOR STUPIDE! CRISTIAN PRESURĂ #IGDLCC 260 @presura

FIBA FCB NESTED 0:00:29

FIBA FCB NESTED ACCOUNTS Animation

NESTED TRANSACTION IN 0:05:52

NESTED TRANSACTION IN MALAYALAM|DISTRIBUTED TRANSACTION |KTU|EASY CSE LECTURES

SQL : Use 0:01:27

SQL : Use nested stored procedure results in calling stored procedure Sql Server 2008

Delete Vs Truncate 0:53:55

Delete Vs Truncate - Myths & Misconceptions by Satya Ramesh

SQL Server SET 0:04:53

SQL Server SET XACT_ABORT ON

Tableau_Session 4 2:00:39

Tableau_Session 4

The Excel SUMIFS 0:06:12

The Excel SUMIFS Function

Conflict Resolution for 0:51:36

Conflict Resolution for Eventual Consistency • Martin Kleppmann • GOTO 2016

XRPL Server - 0:11:33

XRPL Server - Debug, Connect & Look Up Transaction with JS

Exp22 Excel AppCapstone 0:18:23

Exp22 Excel AppCapstone CompAssessment Manufacturing

Комментарии
Автор

This is a very useful info. I have been following you for about 15 years. Thanks for your effort in making all these videos and articles

sanakya
Автор

Watching your videos. Look like a playing Games. So much fun.✌️

PravinKale
Автор

The intro was awesome.... Tell me more secrets. Good one.

kirankkadam
Автор

You are a great person Pinal.. Thanks for sharing.

achilleskocaeli
Автор

that was completly unexpected behaviour, thanks!

Obratim
Автор

Ohhh Pinal, this is very useful! thank you so much!

cepedamasmasmas
Автор

My sql server configuration not showing any thing or any instance I can't start my any instance by service I run mof file on cmd but command say access denied how I started my all instance, please give some solution

maheshgupta
Автор

Should Transaction be across multiple table be maintained at Database level or Data Access Layer like Entity Framework ?
Looking at your video DB leave seems to give a more consistent result.

manumobile
Автор

Sir can u tell me how to download MySQL server I tried hundreds of times but couldn't install
Currently working on liveSQL
I need to install to be able to do college practicals

koynagupta
Автор

good one sir, using nested transactions are like floccinaucinihilipilification 😂

ateeqahmad
Автор

You just demonstrated that there ARE actually nested transactions. The 2 inner transactions were rolled back. If there were NOT rolled back then you could say there are no nested transactions. I don't get it why you say there are not. I guess the part that needs clarification is what actually "nested" means. :o)

zberteoc