ChuckLu - 博客园

2021年6月1日

with(nolock) or (nolock) - Is there a difference?

摘要： with(nolock) or (nolock) - Is there a difference? Everything is based on the assumption that with(nolock) is entirely appropriate for the situtation. 阅读全文

posted @ 2021-06-01 11:07 ChuckLu 阅读(64) 评论(0) 推荐(0)

What is “with (nolock)” in SQL Server?

摘要： What is “with (nolock)” in SQL Server? Can someone explain the implications of using with (nolock) on queries, when you should/shouldn't use it? For e 阅读全文

posted @ 2021-06-01 10:54 ChuckLu 阅读(72) 评论(0) 推荐(0)

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 阅读(46) 评论(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 阅读(76) 评论(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 阅读(112) 评论(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 阅读(102) 评论(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 阅读(113) 评论(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 阅读(83) 评论(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 阅读(120) 评论(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 阅读(104) 评论(0) 推荐(0)

Chuck Lu

公告