delete sql | partition in sql server | sql server delete row | Truncate | part 2

  Рет қаралды 871

sql expert

sql expert

Күн бұрын

Пікірлер: 4
@anilpatil692
@anilpatil692 Жыл бұрын
👌🏻👌🏻👍🏻👍🏻👍🏻🙏🏻🙏🏻🙏🏻
@mssqlexpert
@mssqlexpert Жыл бұрын
Thanks Anil Bhai
@rommelrueco
@rommelrueco Ай бұрын
Tried using table partition but dropping the original constraint and creating a new constraint is taking more than 1 hour each for 11 million of records. Is this expected? It’s not ideal if you cannot afford long downtime just to do the maintenance.
@mssqlexpert
@mssqlexpert Ай бұрын
Yes it’s expected. If no any primary key foreign key relationship then it will take less time. But constraints are available then definitely it will take longer time drop and create.
Why Table Partitioning Doesn't Speed Up Query Performance
19:27
Kendra Little
Рет қаралды 25 М.
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 81 МЛН
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
SQL Server Table partitioning - DOs and DON’Ts
45:55
SQLBits
Рет қаралды 26 М.
SQL Portfolio Project | Data Analytics | Danny's Diner SQL Challenge
1:18:13
Table Partitioning In MS SQL SERVER Part 2 #sql #sqlserver #sqlserverdba
25:49
MS SQL DBA Tech Support
Рет қаралды 2,6 М.
Deadlocks: Lets Do One, Understand It, and Fix It
44:01
SQLBits
Рет қаралды 38 М.
Table Partitioning 101
1:08:57
PASS Data Community Summit
Рет қаралды 951
Fastest way to delete data?
7:27
SQL and Database explained!
Рет қаралды 4 М.