杀虫剂 发表于 2025-3-27 00:57:37

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.

Dna262 发表于 2025-3-27 04:32:02

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

Confirm 发表于 2025-3-27 06:45:51

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.

大方不好 发表于 2025-3-27 10:05:36

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.

Cryptic 发表于 2025-3-27 16:50:33

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

malapropism 发表于 2025-3-27 17:50:44

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

陶器 发表于 2025-3-27 22:04:09

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

Perigee 发表于 2025-3-28 05:52:23

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

Chromatic 发表于 2025-3-28 07:06:39

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

使长胖 发表于 2025-3-28 12:13:37

http://reply.papertrans.cn/83/8247/824612/824612_40.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