ChuckLu - 博客园

2021年6月4日

摘要： Where Did the Other Dollar Go, Jeff? 多出来的一美元三名游客来到一家旅馆，经理告诉他们，三人间的价格是30美元。游客每人掏出10美元，入住了房间。第二天退房时，经理意识到，这间客房的定价应该是25美元，便要求服务员将多收的5美元退还给客人。服务员不诚实，仅向每阅读全文

posted @ 2021-06-04 12:52 ChuckLu 阅读(104) 评论(0) 推荐(0)

You Can’t Sacrifice Partition Tolerance

摘要： http://www.ruanyifeng.com/blog/2021/06/weekly-issue-161.html CAP 定理解读（英文）这篇文章从学术角度，详细解读分布式系统的 CAP 定理，写得很好。CAP 定理的核心含义就是，发生故障时，开发者必须选择，优先满足一致性还是可用性。 Y 阅读全文

posted @ 2021-06-04 12:44 ChuckLu 阅读(59) 评论(0) 推荐(0)

Cookies are deleted when I close the browser?

摘要： cookie默认的生命周期，是跟着session走的。session结束了，cookie也就被自动清除了。不过可以设置cookie的过期时间来避免自动清除 Cookies are deleted when I close the browser? The default cookie lifetim 阅读全文

posted @ 2021-06-04 10:46 ChuckLu 阅读(66) 评论(0) 推荐(0)

2021年6月1日

Using more than one index per table is dangerous?

摘要： Using more than one index per table is dangerous? 问题 In a former company I worked at, the rule of thumb was that a table should have no more than one 阅读全文

posted @ 2021-06-01 17:26 ChuckLu 阅读(61) 评论(0) 推荐(0)

Multiple Indexes vs Multi-Column Indexes

摘要： Multiple Indexes vs Multi-Column Indexes 问题 I've just been adding an Index to a table in SQL Server 2005 and it got me thinking. What is the differenc 阅读全文

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

SQL Server Index Naming Conventions

摘要： SQL Server Index Naming Conventions [closed] 回答1 I use PK_ for primary keys UK_ for unique keys IX_ for non clustered non unique indexes UX_ for uniqu 阅读全文

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

What's different between INTERSECT and JOIN?

摘要： What's different between INTERSECT and JOIN? 1.INTERSECT just compares 2 sets and picks only distinct equivalent values from both sets. It's important 阅读全文

posted @ 2021-06-01 15:58 ChuckLu 阅读(95) 评论(0) 推荐(0)

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 阅读(64) 评论(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 阅读(48) 评论(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 阅读(44) 评论(0) 推荐(0)

Chuck Lu

公告