ChuckLu - 博客园

2021年5月31日

Changing SQL Server Collation After Installation

摘要： Changing SQL Server Collation After Installation We can now redefine the desired collation for database Products with the following code: -- make sure 阅读全文

posted @ 2021-05-31 18:03 ChuckLu 阅读(49) 评论(0) 推荐(0)

High CPU Usage SQL Server (One Bad Query)

摘要： High CPU Usage SQL Server (One Bad Query) My colleague reported to me that one of our database server is reporting consistent high CPU usage so I look 阅读全文

posted @ 2021-05-31 13:58 ChuckLu 阅读(86) 评论(0) 推荐(0)

What “Clustered Index Scan (Clustered)” means on SQL Server execution plan?

摘要： What “Clustered Index Scan (Clustered)” means on SQL Server execution plan? I would appreciate any explanations to "Clustered Index Scan (Clustered)" 阅读全文

posted @ 2021-05-31 13:31 ChuckLu 阅读(125) 评论(0) 推荐(0)

2021年5月28日

Execution Plans in SQL Server

摘要： Execution Plans in SQL Server Introduction In this article, I’m going to explain what the Execution Plans in SQL Server are and how to understand the 阅读全文

posted @ 2021-05-28 18:30 ChuckLu 阅读(118) 评论(0) 推荐(0)

Difference between Seek Predicate and Predicate

摘要： Difference between Seek Predicate and Predicate Let's throw one million rows into a temp table along with a few columns: CREATE TABLE #174860 ( PK INT 阅读全文

posted @ 2021-05-28 18:07 ChuckLu 阅读(135) 评论(0) 推荐(0)

Query tuning 101: What’s a probe residual?

摘要： Query tuning 101: What’s a probe residual? Query tuning is an important process that will probably never go away and sharpening your tuning skills is 阅读全文

posted @ 2021-05-28 17:33 ChuckLu 阅读(89) 评论(0) 推荐(0)

Index Key Column VS Index Included Column

摘要： Index Key Column VS Index Included Column Can someone explain this two - Index Key Column VS Index Included Column? Currently, I have an index that ha 阅读全文

posted @ 2021-05-28 17:20 ChuckLu 阅读(133) 评论(0) 推荐(0)

Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it?

摘要： Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it? The most common two types of operators that consume mem 阅读全文

posted @ 2021-05-28 15:45 ChuckLu 阅读(110) 评论(0) 推荐(0)

ApexSQL Plan

摘要： https://www.apexsql.com/Download.aspx Other ApexSQL Plan Open, view, analyze and explore an execution plan in SQL Server, profile SQL code and more Re 阅读全文

posted @ 2021-05-28 14:00 ChuckLu 阅读(195) 评论(0) 推荐(0)

The SQL Server Query Optimizer

摘要： The SQL Server Query Optimizer To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query opti 阅读全文

posted @ 2021-05-28 13:56 ChuckLu 阅读(76) 评论(0) 推荐(0)

Chuck Lu

公告