找回密碼
 To register

QQ登錄

只需一步，快速開始

掃一掃，訪問微社區(qū)

打印 上一主題 下一主題

Titlebook: Refactoring Legacy T-SQL for Improved Performance; Modern Practices for Lisa Bohm Book 2020 Lisa Bohm 2020 T-SQL.Transact-SQL.Performance.L

[復(fù)制鏈接]
查看: 27874|回復(fù): 40
樓主
發(fā)表于 2025-3-21 17:32:10 | 只看該作者 |倒序瀏覽 |閱讀模式
書目名稱Refactoring Legacy T-SQL for Improved Performance
副標(biāo)題Modern Practices for
編輯Lisa Bohm
視頻videohttp://file.papertrans.cn/825/824612/824612.mp4
概述Helps to mitigate technical debt found in legacy code.Shows how to target performance pain points commonly found in older code.Promotes awareness of modern coding techniques yielding strong performanc
圖書封面Titlebook: Refactoring Legacy T-SQL for Improved Performance; Modern Practices for Lisa Bohm Book 2020 Lisa Bohm 2020 T-SQL.Transact-SQL.Performance.L
描述Breathe 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, then rewriting those anti-patterns using new functionality that is supported in current versions of SQL Server, including SQL Server 2019. The focus moves through the different types of database objects and the code used to create them, discussing the limitations and anti-patterns commonly found for each object type in your database..Legacy code isn’t just found in queries and external applications. It’s also found in the definitions of underlying database objects such as views and tables. This book helps you quickly find problematic code throughout the database and points out where and how modern solutions can replace older code, thereby making your legacy applications run faster and extending their lifetimes. Author Lisa Bohm explains the logic behind each anti-pattern, helping you understand why each pattern is a problem and showing how it can be avoided. Good coding habits are discussed, including guidance on topics such as readability and main
出版日期Book 2020
關(guān)鍵詞T-SQL; Transact-SQL; Performance; Legacy Code; Triggers; Views; Stored Functions; Stored Procedures; Indexes
版次1
doihttps://doi.org/10.1007/978-1-4842-5581-0
isbn_softcover978-1-4842-5580-3
isbn_ebook978-1-4842-5581-0
copyrightLisa Bohm 2020
The information of publication is updating

書目名稱Refactoring Legacy T-SQL for Improved Performance影響因子(影響力)




書目名稱Refactoring Legacy T-SQL for Improved Performance影響因子(影響力)學(xué)科排名




書目名稱Refactoring Legacy T-SQL for Improved Performance網(wǎng)絡(luò)公開度




書目名稱Refactoring Legacy T-SQL for Improved Performance網(wǎng)絡(luò)公開度學(xué)科排名




書目名稱Refactoring Legacy T-SQL for Improved Performance被引頻次




書目名稱Refactoring Legacy T-SQL for Improved Performance被引頻次學(xué)科排名




書目名稱Refactoring Legacy T-SQL for Improved Performance年度引用




書目名稱Refactoring Legacy T-SQL for Improved Performance年度引用學(xué)科排名




書目名稱Refactoring Legacy T-SQL for Improved Performance讀者反饋




書目名稱Refactoring Legacy T-SQL for Improved Performance讀者反饋學(xué)科排名




單選投票, 共有 1 人參與投票
 

1票 100.00%

Perfect with Aesthetics
 

0票 0.00%

Better Implies Difficulty
 

0票 0.00%

Good and Satisfactory
 

0票 0.00%

Adverse Performance
 

0票 0.00%

Disdainful Garbage
您所在的用戶組沒有投票權(quán)限
沙發(fā)
發(fā)表于 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.
板凳
發(fā)表于 2025-3-22 02:17:45 | 只看該作者
地板
發(fā)表于 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.
5#
發(fā)表于 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.
6#
發(fā)表于 2025-3-22 16:39:20 | 只看該作者
7#
發(fā)表于 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
8#
發(fā)表于 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.
9#
發(fā)表于 2025-3-23 05:26:17 | 只看該作者
10#
發(fā)表于 2025-3-23 06:29:41 | 只看該作者
 關(guān)于派博傳思  派博傳思旗下網(wǎng)站  友情鏈接
派博傳思介紹 公司地理位置 論文服務(wù)流程 影響因子官網(wǎng) 吾愛論文網(wǎng) 大講堂 北京大學(xué) Oxford Uni. Harvard Uni.
發(fā)展歷史沿革 期刊點評 投稿經(jīng)驗總結(jié) SCIENCEGARD IMPACTFACTOR 派博系數(shù) 清華大學(xué) Yale Uni. Stanford Uni.
QQ|Archiver|手機版|小黑屋| 派博傳思國際 ( 京公網(wǎng)安備110108008328) GMT+8, 2025-10-15 03:13
Copyright © 2001-2015 派博傳思   京公網(wǎng)安備110108008328 版權(quán)所有 All rights reserved
快速回復(fù) 返回頂部 返回列表
杭锦旗| 阳高县| 安顺市| 饶河县| 新余市| 涟源市| 玛多县| 诸暨市| 德兴市| 株洲市| 霞浦县| 闸北区| 贵州省| 三门县| 浦北县| 丹东市| 永靖县| 北辰区| 庆云县| 城固县| 依兰县| 成武县| 天祝| 长岭县| 静安区| 高唐县| 平泉县| 河池市| 金寨县| 昔阳县| 塘沽区| 邢台县| 抚顺市| 达日县| 天津市| 徐闻县| 大关县| 津市市| 鄄城县| 抚远县| 定陶县|