ChuckLu - 博客园

2021年6月1日

摘要： Bad habits : Putting NOLOCK everywhere [See an index of all bad habits / best practices posts] I went through the archive above, and was quite surpris 阅读全文

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

Understanding the Impact of NOLOCK and WITH NOLOCK Table Hints in SQL Server

摘要： Understanding the Impact of NOLOCK and WITH NOLOCK Table Hints in SQL Server Every once in a while, SQL Server database administrators find themselves 阅读全文

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

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 阅读(89) 评论(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 阅读(93) 评论(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 阅读(54) 评论(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 阅读(102) 评论(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 阅读(139) 评论(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 阅读(130) 评论(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 阅读(147) 评论(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 阅读(98) 评论(0) 推荐(0)

Chuck Lu

公告