ChuckLu - 博客园

2021年6月1日

Does EXCEPT execute faster than a JOIN when the table columns are the same

摘要： Does EXCEPT execute faster than a JOIN when the table columns are the same To find all the changes between two databases, I am left joining the tables 阅读全文

posted @ 2021-06-01 14:36 ChuckLu 阅读(57) 评论(0) 推荐(0)

Bad habits : Putting NOLOCK everywhere

摘要： 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 阅读(44) 评论(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 阅读(41) 评论(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 阅读(58) 评论(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 阅读(66) 评论(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 阅读(44) 评论(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 阅读(70) 评论(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 阅读(101) 评论(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 阅读(94) 评论(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 阅读(109) 评论(0) 推荐(0)

Chuck Lu

公告