ChuckLu - 博客园

2022年6月28日

Clustered vs Non-clustered Index: Key Differences with Example

摘要： Clustered vs Non-clustered Index: Key Differences with Example What is an Index?An Index is a key built from one or more columns in the database that 阅读全文

posted @ 2022-06-28 23:10 ChuckLu 阅读(80) 评论(0) 推荐(0)

Why use the INCLUDE clause when creating an index?

摘要： Why use the INCLUDE clause when creating an index? 问题 While studying for the 70-433 exam I noticed you can create a covering index in one of the follo 阅读全文

posted @ 2022-06-28 23:07 ChuckLu 阅读(87) 评论(0) 推荐(0)

Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?

摘要： Back To Basics: Clustered vs NonClustered Indexes; what’s the difference? SQL Server has two basics kinds of indexes. They are clustered and noncluste 阅读全文

posted @ 2022-06-28 22:39 ChuckLu 阅读(77) 评论(0) 推荐(0)

When to Use Clustered or Non-Clustered Indexes in SQL Server

摘要： When to Use Clustered or Non-Clustered Indexes in SQL Server Database indexes are used to improve the speed of database operations in a table with a l 阅读全文

posted @ 2022-06-28 21:24 ChuckLu 阅读(51) 评论(0) 推荐(0)

SQL Server: Order of Rows

摘要： SQL Server: Order of Rows 问题 We all know that a simple statement such as: SELECT * FROM stuff;should not produce an ordered result. However, when I tr 阅读全文

posted @ 2022-06-28 21:10 ChuckLu 阅读(43) 评论(0) 推荐(0)

Being Agile vs. doing Agile: What's the difference?

摘要： Being Agile vs. doing Agile: What's the difference? Doing Agile and being Agile, compared The difference between being Agile and doing Agile is akin t 阅读全文

posted @ 2022-06-28 12:08 ChuckLu 阅读(103) 评论(0) 推荐(0)

2022年6月25日

炉石传说佣兵战纪贫瘠之地

摘要：神秘的奶牛 H1-10 https://www.bilibili.com/video/BV1PY411M7ms 先解决一个小怪，降低自然伤害。然后集火boss LT23_825H奶牛王(The Cow King)The Cow King奶牛王After this takes damage, cast 阅读全文

posted @ 2022-06-25 12:39 ChuckLu 阅读(338) 评论(0) 推荐(0)

2022年6月23日

Logical Processing Order of the SELECT statement

摘要： What's the execute order of the different parts of a SQL select statement? 问题 What's the execute order of the different parts of a SQL select statemen 阅读全文

posted @ 2022-06-23 13:40 ChuckLu 阅读(72) 评论(0) 推荐(0)

Multiple Indexes vs Multi-Column Indexes

摘要： Multiple Indexes vs Multi-Column Indexes 问题 What is the difference between creating one index across multiple columns versus creating multiple indexes 阅读全文

posted @ 2022-06-23 13:17 ChuckLu 阅读(70) 评论(0) 推荐(0)

Partitioned SUM and COUNT sql online,在线示例，online example, partition by

摘要：最新的理解 4张表 as cte1， abcd 3张表 as cte2, aef 把cet1和cte2进行join的时候，partition需要调整， cte1里面的partition by需要加上ef的字段 cte2里面的partition by需要加上bcd的字段核心，这里做除法的时候 cou 阅读全文

posted @ 2022-06-23 12:24 ChuckLu 阅读(39) 评论(0) 推荐(0)

Chuck Lu

公告