Search results
Retired 2022. SQL Server performance expertise without peer. Root cause analysis of…. · Experience: Retired · Education: Caltech · Location: Boston, Massachusetts, United States · 500 ...
- 500+
- 1.4K
- Retired
- Greater Boston
- Summary
- Employment
- Education
- Speaking Engagements and Publications
- Deep expert SQL Server Query Performance and database engine internals - Expert knowledge of the Execution Plan Cost Model - Expert knowledge of actual query cost, very different from plan cost - Writing SQL to a specific execution plan shape (old school) - Handling skewed data distribution for resilient execution plans - Tricks to mitigate exces...
Tax Manager - still doing SQL Server and other HW/SW performance. Investigate work arounds for excessive memory grant allocation issues. Handling Entity-Attribute-Value searches, pivoting, etc. Database Architect and Performance Consultant Major Projects: A redo of the original line-of-business system was undertaken 4-5 years ago.The company electe...
GaAs MESFET numerical modeling, Hot-Carrier Transport Effect. Microwave circuit simulation. BS Physics, 1984 Microsoft Certified System Engineer, 1995 Novell Certified NetWare Engineer, 1994
PASS Summit 2018, Seattle Rethink Server Sizing Joe ChangDate: Nov 7, Time: 4:45PM - 6:00PM, Room: 618 Data Architecture Summit 2017, ChicagoIs Performance Still Important SQL Server Cost Based Optimizer Queries barely over the Cost Threshold for Parallelism Hyper-Threading Performance In-Memory Database Technology Big Iron Systems and NUMA System ...
Pending retirement notice for qdpma.com, please use QDPMA.azurewebsites.net. Also, retirement notice for Joe Chang. About Joe, former SQL Server Consultant, now retired. Contact: jchang6 at yahoo.com or jchang61 at outlook.com.
1y Edited. SQL Insert, Update and Delete Plan Cost ( https://lnkd.in/ePpzNPG6 ) is my look at SQL Server execution plan cost for simple Insert, Update and Delete (IUD) operations. Previously at...
Jan 12, 2023 · Joe Chang. Published Jan 12, 2023. + Follow. Data distribution statistics is one the foundational elements of cost-based query optimization in modern relational database engines. A statistical...
Learn which techniques are absolutely essential and which contribute a only few percent. Joe is a freelance consultant specializing in SQL Server scalability. The common approach to database performance tuning seems to be a laundry list of techniques with no unifying theme. Try random items until something works.
Joe Chang SQL Server Performance Architect Consultant. Links. Joe on SQLblogs. Joe on SQL-Server-Performance. Articles on SQL-Server-Performance
