ChuckLu - 博客园

2022年6月28日

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 阅读(51) 评论(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 阅读(38) 评论(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 阅读(30) 评论(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 阅读(86) 评论(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 阅读(287) 评论(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 阅读(29) 评论(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 阅读(43) 评论(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 阅读(16) 评论(0) 推荐(0)

2022年6月22日

SQL Server: Difference between PARTITION BY and GROUP BY

摘要： SQL Server: Difference between PARTITION BY and GROUP BY 问题 I've been using GROUP BY for all types of aggregate queries over the years. Recently, I've 阅读全文

posted @ 2022-06-22 18:11 ChuckLu 阅读(52) 评论(0) 推荐(0)

2022年6月21日

SQL Server 2012 copy database without data

摘要： SQL Server 2012 copy database without data 回答1 Right click your database in your server, and select Tasks > Generate Scripts. At Introduction step, cl 阅读全文

posted @ 2022-06-21 18:06 ChuckLu 阅读(37) 评论(0) 推荐(0)

Chuck Lu

公告