TSQL ANTIPATTERN IMPLICIT CONVERSION

  Рет қаралды 504

SQLMaestros

SQLMaestros

Күн бұрын

Пікірлер: 2
@waynehamberg9248
@waynehamberg9248 Ай бұрын
The problem with this concept is that you depend upon the query being run enough times that you get the query's plan stored in the Plan Cache and then if a DBA happens to catch that issue. Every database has this issue but this only really works for queries and doesn't catch these types of patters in C# Entity Framework code or in stored procedures. There is a better way with SqlParser and that can be done without looking at the execution plan and even without querying the database.
INSTALLING SQL SERVER 2022
17:03
SQLMaestros
Рет қаралды 406
Capturing TSQL Antipatterns with Extended Events
9:19
SQLMaestros
Рет қаралды 182
Database Indexing for Dumb Developers
15:59
Laith Academy
Рет қаралды 79 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 220 М.
Querying 100 Billion Rows using SQL, 7 TB in a single table
9:07
Arpit Agrawal (Elastiq.AI)
Рет қаралды 53 М.
OS_MEMORY_CLERKS Dynamic Management View
11:44
SQLMaestros
Рет қаралды 375
TCP/IP for Programmers
3:03:31
Eli the Computer Guy
Рет қаралды 239 М.
Reading & Analyzing Execution Plans
20:38
SQLMaestros
Рет қаралды 558
#01 - Relational Model & Algebra (CMU Intro to Database Systems)
1:23:38
CMU Database Group
Рет қаралды 23 М.
Tracking Pending IO Requests in SQL Server
9:31
SQLMaestros
Рет қаралды 635