SQL Performance Tuning

Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database. Not a list of one-off tr

Proven PL/SQL optimization solutions from Oracle Press Oracle PL/SQL Performance Tuning Tips & Techniques presents a hands-on approach to enabling better, faster, and safer results from PL/SQL. Th

Offers tips for improving the performance of any SQL database, no matter what the platform. Written for experienced database administrators familiar with SQL, the book identifies the similarities and

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's bookSQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance proble

SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor per

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or

Field-tested techniques for optimizing SQL Server 2014 databases and applications for speed and performanceMicrosoft SQL Server 2014 Query Tuning & Optimization reveals how to get peak performance

台灣微軟雲端解決方案副總經理 宋明遠 專業推薦! *　完整涵蓋SQL Server 2022及其向下相容版本之管理技巧 *　從DBA觀點出發，建立正確的資料庫系統觀念 *　最實用的企業級資料庫管理與維護指南，解決常見的技術瓶頸 現今的資訊系統邁向全面性地連結整合，從手機、平板乃至於各種裝置、個人電腦與伺服器在結合公有/私有雲後，強化了無所不在的資料應用。但隨之而來的是處理資料的質與量爆增。企業的競爭力絕大部分取決於資訊系統，而資訊系統的核心之一是資料庫。 本書作者以累計超過30年的資料庫管理經驗，由建置穩健的資料庫系統開始，教導讀者一步步打造出可靠有效的環境，並學會最實務的管理與維護技巧。 ■　介紹SQL Server 2022的新功能，說明其設計理念與應用情境。 ■　安裝SQL Server，介紹硬體需求、選擇適當的服務、元件與帳戶，設定系統的驗證模式與管理帳戶的密碼等，開始邁入SQL Server的殿堂。 ■　說明SQL Server Management Studio（SSMS）各項功能，透過圖形化管理介面來管理伺服器。 ■　解說SQL Server資料庫的資料檔案與交易記錄檔案的結構與特性，以獲取最佳磁碟效能。 ■　計畫完善的備份/還原策略，可協助保護資料庫免於遺失資料。藉由還原備份和復原資料庫來測試備份/還原策略，以有效地面對各類災難事件。 ■　SQL Server提供完善的自動化自我管理機制，管理人員可將管理工作交由SQL Server Agent服務代勞，讓管理SQL Server資料庫系統事半功倍。 ■　介紹監控常用的擴充事件和SQL Server Profiler工具程式，並說明如何透過Windows系統提供的效能計數器分析整體效能，以透過資源管理員控管伺服器上的硬體資源。 ■　說明系統「可用性」的需求及規劃，進而說明SQL Server提供的「高可用性」解決方案及相關技術。 ■　實做SQL Server不同類型的複寫，針對部分的資料內容，持續且即時地將變動從一個資料庫帶到另一個資料庫。 ■　介紹Azure上與SQL Server相關的架構與技術，說明備份與高可用性、基本的安全規劃、紀錄與監控，以及自動化作業等。

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next

"System Performance Tuning" covers two distinct areas: performance tuning, or the art of increasing performance for a specific application, and capacity planning, or deciding what hardware best fulfil

Real Learning Happens as You Work!Implement performance support to increase and accelerate employee performance.Research shows that 80 percent of learning in the workplace occurs on the job, rather th

The complete guide to analyzing and maximizing a company's balanced scorecardPresenting the next step for balanced scorecard implementation, Balanced Scorecard Diagnostics provides a step-by-step methodology for analyzing the effectiveness of a company's balanced scorecard and the tools to reevaluate balanced scorecard measures to drive maximum performance. CEOs, CFOs, CIOs, vice presidents, department managers, and business consultants will find all the essential tools for analyzing a balanced scorecard methodology to determine if it's running at maximum performance and for seamlessly implementing changes into the scorecard.Paul R. Niven (San Marcos, CA) is President of the Senalosa Group, a consulting firm exclusively dedicated to helping businesses get best-in-class performance. He is the author of two successful books, Balanced Scorecard Step-by-Step (0-471-07872-7) and Balanced Scorecard Step-by-Step for Government and Nonprofit Agencies (0-471-42328-9), both from Wiley.

An indispensable guide for the study of performance, by France's leading theater critic, now available in English

SQL tuning improvements existing execution plans. The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution

Expert Oracle RAC Performance Diagnostics and Tuning provides comprehensive coverage of the features, technology and principles for testing and tuning RAC databases. The book takes a deep look at opti

Packed with practical examples, this book looks at a different aspect of performance tuning in each chapter and shows you how to apply them to their existing Java applications. Anyone with an interest

With contributions from some of the most notable experts in the field, Performance Tuning of Scientific Applications presents current research in performance analysis. The book focuses on the followin

【書籍特點】☆Transformer：自注意力、多頭注意力、位置編碼☆GPT：文字生成、Greedy Search、Beam Search、困惑度評估☆BERT：遮罩語言模型、預訓練、微調、分類任務☆ViT：影像分塊、視覺嵌入、注意力量化☆微調方法：Adapter Tuning、LoRA、P-Tuning☆資料處理：文字清洗、分詞、嵌入向量、資料增強☆混合精度與分散式訓練：Data Parallel、Model Parallel、梯度累積☆對比學習與對抗訓練：SimCLR、GAN、自監督任務☆最佳化器：AdamW、LAMB、動態學習率、Warmup、餘弦退火☆模型壓縮：知識蒸餾、教師學生架構、權重剪枝☆訓練流程：Tokenization、多GPU訓練、訓練中斷與恢復☆微調實作：資料集切分、層級凍結、超參數調整、推理量化【內容簡介】本書共分為12章，涵蓋大模型的建構、訓練與微調流程。第一章介紹Transformer的基本原理，包括自注意力、多頭注意力與位置編碼。第二章說明GPT模型的文字生成機制與實作方法，並比較Greedy與Beam Search等生成策略。第三章講解BERT模型的編碼結構與遮罩語言模型任務，並說明如何應用於分類任務。第四章介紹ViT模型在影像分塊、嵌入與注意力運算上的應用。第五章說明Adapter Tuning、LoRA、P-Tuning等常見微調方法。第六章說明資料清洗、資料增強與嵌入向量生成等處理技術。第七章解釋混合精度訓練、多GPU併行與梯度累積等效率優化技術。第八章涵蓋對比學習與對抗訓練，包括SimCLR與GAN的實作細節。第九章介紹AdamW與LAMB最佳化器，並比較各種動態學習率排程方式。第十章說明知識蒸餾與剪枝，包括教師學生架構與多頭注意力精簡方法。第十一章示範大模型訓練流程，從資料前處理到訓練中斷與恢復。第十二章介紹模型微調的實作，包括資料集切分、參數設定與推理效能調整。

Why performance improvement programs fail--and what you can do about it "Too often, outstanding performance seems out of reach. Karen Martin explains, with elegant simplicity, why so many organization

As a manager, you aren’t truly successful unless your employees are as well. Helping them establish compelling, actionable performance goals is the first and most important step, and 2600 Phrases for

Master the Powerful Virtualization Tools in Oracle VMSet up and maintain a dynamic virtualization platform across your enterprise using the detailed information contained in this Oracle Press guide. Oracle VM Implementation and Administration Guide contains key virtualization concepts, practical instructions, examples, and best practices. Find out how to design Oracle VM server farms, build and deploy virtual machines, handle provisioning and cloning, and work with Oracle VM Manager. Monitoring, tuning, and security techniques are also covered in this comprehensive volume.Install, configure, and manage all Oracle VM componentsPlan, size, and set up Oracle VM server farms and server poolsControl resources from Oracle Enterprise Manager Grid Control, Oracle VM Manager, and Oracle VM Command Line InterfaceGovern network drives and virtual storage using Oracle VM toolsCreate virtual machines manually or from Oracle library templatesConvert existing virtual machines on other systems to Orac

Put every employee on the path to excellence!Solving Employee Performance Problems provides the tools you need to handle the most difficult employees—from the chronically late or distractingly dramati

In this title, a renowned sports psychologist shows business leaders how to play to win - using the proven secrets of professional athletes. Business, like sports, is all about performance. Performanc

Use this fast and complete guide to optimize the performance of MongoDB databases and the applications that depend on them. You will be able to turbo-charge the performance of your MongoDB applications to provide a better experience for your users, reduce your running costs, and avoid application growing pains. MongoDB is the world's most popular document database and the foundation for thousands of mission-critical applications. This book helps you get the best possible performance from MongoDB.MongoDB Performance Tuning takes a methodical and comprehensive approach to performance tuning that begins with application and schema design and goes on to cover optimization of code at all levels of an application. The book also explains how to configure MongoDB hardware and cluster configuration for optimal performance. The systematic approach in the book helps you treat the true causes performance issues and get the best return on your tuning investment. Even when you're under pressure and

As with previous versions of this Oracle Press bestseller, Oracle Database 11g Performance Tuning Tips & Techniques provides instructions that explain the best ways of maintaining a high-performance O

【書籍特點】☆GPT模型歷史、架構與API功能解析☆OpenAI文字轉語音與語音轉文字實作☆Chat系列API端點與流式回應設計☆ChatGPT應用介面建構與訊息狀態處理☆System Prompt建構與角色扮演範例☆ChatGPT跨平台部署與Vercel整合☆飛書機器人API連接與事件回應開發☆VSCode外掛模組開發流程與通訊機制☆AI程式輔助：自動生成、語言轉換、程式診斷☆Hugging Face模型私有部署與P-Tuning微調☆文本向量化技術與嵌入式匹配範例☆向量資料庫Chroma操作與距離計算方式☆ChatGPT外掛知識庫系統建構與查詢設計☆提示詞工程模組化設計與Coze平台整合【內容簡介】本書共分九章。第一章介紹GPT模型歷程、原理與API介面。第二章說明OpenAI文字與語音轉換功能、API端點設計與請求庫封裝。第三章展示ChatGPT應用構建，包括互動區域、聊天快取與角色設定。第四章實作飛書機器人與OpenAI結合，開發多種回應與通知功能。第五章說明VSCode外掛程式開發流程與Webview通訊技術。第六章實作AI程式輔助模組，包含語言轉換、程式診斷與自動修復。第七章說明如何部署ChatGLM等開源模型與進行P-Tuning微調。第八章介紹RAG技術，實作文字向量化與Chroma向量資料庫整合，建構查詢式知識庫。第九章為提示詞工程與LLM社群工具介紹，說明提示詞模式、模型回應最佳化與Coze平台應用。

☆★暢銷好書，好評再上市★☆◆ 滲透測試之資訊收集，包括域名、子域名、旁站C段、通訊埠、社會工程學◆ DVWA漏洞平臺、SQL注入平臺、XSS測試平臺◆ 滲透測試過程中「神器」：SQLMap、Burp Suite和Nmap◆ 暴力破解漏洞、SQL注入漏洞、XSS漏洞、CSRF漏洞、SSRF漏洞、檔案上傳漏洞、命令執行漏洞、越權存取漏洞、XXE漏洞、反序列化漏洞、邏輯漏洞◆ WAF的基本概念、分類、處理流程、繞過WAF及WebShell的變形方式◆ 雲端環境和Redis服務的滲透◆ Metasploit和PowerShell技術實戰全書共分9章：第一章主要介紹進行滲透測試之前，最重要的資訊收集。第二章說明漏洞環境的架設(使用Docker)，示範了DVWA漏洞平臺、SQL注入平臺、XSS測試平臺。第三章介紹常用的滲透測試工具SQLMap、Burp Suite和Nmap。第四章說明Web滲透測試的核心技術包括暴力破解漏洞、SQL注入漏洞、XSS漏洞、CSRF漏洞、SSRF漏洞、檔案上傳漏洞、命令執行漏洞、越權存取漏洞、XXE漏洞、反序列化漏洞、邏輯漏洞。第五章介紹WAF的基本概念、分類、處理流程和如何辨識。第六章詳細介紹雲端環境和Redis服務的概念、滲透想法、實際應用以及實戰案例。第七章講解程式稽核的學習路線、常見漏洞的稽核場景和技巧。第八章說明Metasploit的發展歷史、主要特點、使用方法和攻擊步驟，並介紹具體的內網滲透測試實例，也介紹了PowerShell的基本概念、重要命令和指令稿知識。第九章過幾個實際案例介紹了程式稽核和滲透測試過程中常見漏洞的利用過程，讓讀者累積經驗，關注細節，最終挖掘到漏洞。

?回顧對話機器人歷史，從人機交流到現代語言模型?解析人工智慧發展，聚焦通用人工智慧（AGI）?指導大型語言模型私有化部署，涵蓋環境建置?介紹語言模型核心理論，從統計方法到Transformer?解析Hugging Face與Transformers函數庫應用?介紹高效微調技術，如Prompt Tuning與LoRA?實作LoRA與QLoRA微調GLM-4，提升效能?探討提示工程，提升模型推理與應用能力?解析多角色對話與AI Agent的運作模式?介紹LangChain框架，涵蓋Chain與Agents?展示垂直領域模型應用，以紅十字會資料實作?解析檢索增強生成（RAG），結合LLM與知識庫本書第一章回顧對話機器人的發展，探討人工智慧的演進與未來趨勢。第二章介紹大型語言模型的私有化部署，包括CUDA環境建置、PyTorch安裝與GLM-4模型執行。第三章解析語言模型的理論基礎，涵蓋統計語言模型、Transformer架構與Attention機制。第四章說明Hugging Face與Transformers函數庫的應用，幫助讀者開發與微調LLM。第五章介紹高效微調技術，如Prompt Tuning、LoRA、QLoRA等方法，提升模型效能。第六章進一步探討LoRA微調GLM-4的實戰應用與量化技術。第七章解析提示工程，說明Few-shot、Chain of Thought等推理增強技術。第八章介紹AI Agent與多角色對話模式，並探討Function Calling的應用。第九章深入LangChain框架，涵蓋Chain、Memory與Agents的實作，並整合資料庫與檢索增強生成（RAG）技術。第十章展示大型模型在垂直領域的應用，例如微調GLM-4處理紅十字會資料，提供完整的實戰示範。

FINALIST HEALTH AND WELLBEING AWARDS 2025EMBRACE THE POWER OF PLANTS AND RIDE STRONGER WITH EVERY BITE.'A great selection of achievablerecipes whether you're vegan or looking to reduce your meat and dairy consumption'–CycleMagazine'Amust for anyone who wants to perform on a plant-based diet'–Men's FitnessTHE CYCLING CHEF GOES VEGAN – TO DELIVER MOUTH-WATERING PLANT-BASED RECIPES AND EXPERT ADVICE TO BOOST ENERGY AND PERFORMANCE.Michelin-starred chef and leading sports nutritionist Alan Murchison knows all about the rise of veganism among cyclists. Cycling and food are the twin passions of his life, and he believes that food should be both for pleasure and for performance. Therefore, Alan has created a range of delicious recipes to give plant-powered cyclists or riders who want to reduce their meat intake the best possible preparation.A plant-based diet should not diminish performance, and can even improve it with the right balance of nutrients, vitamins, carbs and protein. From energis

Understanding and applying psychology within youth sport settings is key to maximising young athletes’ enjoyment, wellbeing, and sporting performance. Written by a team of leading international resear

Learn how diagnostic ultrasound works, and find out how to properly handle artifacts, scan safely, evaluate instrument performance, and prepare for registry examinations, with the market-leadingSonogr

Chinese opera embraces over 360 different styles of theatre that make one of the richest performance arts in the world. It combines music, speech, poetry, mime, acrobatics, stage fighting, vivid face-

One of the most notable features of nanometer scale CMOS technology is the increasing magnitude of variability of the key device parameters affecting performance of integrated circuits. The growth of variability can be attributed to multiple factors, including the difficulty of manufacturing control, the emergence of new systematic variation-generating mechanisms, and most importantly, the increase in atomic-scale randomness, where device operation must be described as a stochastic process. In addition to wide-sense stationary stochastic device variability and temperature variation, existence of non-stationary stochastic electrical noise associated with fundamental processes in integrated-circuit devices represents an elementary limit on the performance of electronic circuits.In an attempt to address these issues, Stochastic Process Variation in Deep-Submicron CMOS: Circuits and Algorithms offers unique combination of mathematical treatment of random process variation, electrical noise

Conklin (human performance and safety integration, Los Alamos National Laboratory) outlines a road map for understanding how to manage safety in the workplace and solve problems before they become acc

It’s an insidious disease that is crippling companies, destroying our economy, and crushing potential. It’s infecting the very roots of business performance, and it’s spreading fast. It isn’t the rece

Chermack (organizational performance and change, Colorado State U.) discusses the complexities of the scenario planning method and its theoretical basis, and outlines a five-step planning system. The

Announcing an all-new SELF-PACED TRAINING KIT designed to help maximize your performance on 70-652, the required exam for the new Microsoft Certified Technology Specialist (MCTS): Windows Server Virtu

Modern multicore processors offer immense opportunities to improve Java performance, but they also make Java performance tuning more complex than ever. Java Performance Companion helps you systematica

The only Oracle Press guide to JD Edwards EnterpriseOne performance tuning, covering the latest release Real-world examples show how system administrators can get radically improved performance from e