民俗学 发表于 2025-3-21 17:32:10

书目名称Refactoring Legacy T-SQL for Improved Performance影响因子(影响力)<br>        http://impactfactor.cn/if/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance影响因子(影响力)学科排名<br>        http://impactfactor.cn/ifr/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance网络公开度<br>        http://impactfactor.cn/at/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance网络公开度学科排名<br>        http://impactfactor.cn/atr/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance被引频次<br>        http://impactfactor.cn/tc/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance被引频次学科排名<br>        http://impactfactor.cn/tcr/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance年度引用<br>        http://impactfactor.cn/ii/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance年度引用学科排名<br>        http://impactfactor.cn/iir/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance读者反馈<br>        http://impactfactor.cn/5y/?ISSN=BK0824612<br><br>        <br><br>书目名称Refactoring Legacy T-SQL for Improved Performance读者反馈学科排名<br>        http://impactfactor.cn/5yr/?ISSN=BK0824612<br><br>        <br><br>

bifurcate 发表于 2025-3-21 22:27:33

Documentationed down in nested if statements, while loops, or calls to other SQL objects. If we have an understanding of the desired functionality, as well, we can make the determination whether the current code should be refactored or if we should just start from scratch.

sundowning 发表于 2025-3-22 02:17:45

http://reply.papertrans.cn/83/8247/824612/824612_3.png

NIL 发表于 2025-3-22 07:53:01

Functionses in return. There are also scalar-valued functions, in which you pass in one or a group of values and get a single return value. Different types of functions can have vastly different effects on your query performance.

Malleable 发表于 2025-3-22 09:55:38

Agent Jobsed mess. How many times have you heard about periodic slowness in the application or database, but it’s always gone by the time you get online to look for it? You need to determine if there is a real pattern to the slowness, then you can see if there are jobs that coincide with the painful times.

说不出 发表于 2025-3-22 16:39:20

http://reply.papertrans.cn/83/8247/824612/824612_6.png

dermatomyositis 发表于 2025-3-22 20:19:57

eness of modern coding techniques yielding strong performancBreathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, th

骑师 发表于 2025-3-22 21:57:50

T-SQL Triageed, you can perform triage for some immediate relief. Once that is accomplished, document the code thoroughly to identify any anti-patterns. This will help you as you rewrite the code using more performant techniques.

放气 发表于 2025-3-23 05:26:17

http://reply.papertrans.cn/83/8247/824612/824612_9.png

defray 发表于 2025-3-23 06:29:41

http://reply.papertrans.cn/83/8247/824612/824612_10.png
页: [1] 2 3 4 5
查看完整版本: Titlebook: Refactoring Legacy T-SQL for Improved Performance; Modern Practices for Lisa Bohm Book 2020 Lisa Bohm 2020 T-SQL.Transact-SQL.Performance.L