ChuckLu - 博客园

2022年6月30日

摘要： C# "Using" Syntax 问题 Does the using catch the exception or throw it? i.e. using (StreamReader rdr = File.OpenText("file.txt")) { //do stuff } If the s 阅读全文

posted @ 2022-06-30 14:45 ChuckLu 阅读(59) 评论(0) 推荐(0)

Can you use reflection to find the name of the currently executing method?

摘要： Can you use reflection to find the name of the currently executing method? 回答1 For non-async methods one can use System.Reflection.MethodBase.GetCurre 阅读全文

posted @ 2022-06-30 14:41 ChuckLu 阅读(120) 评论(0) 推荐(0)

Kentico lots of log with event code “CREATEOBJ” and “UPDATEOBJ”

摘要：问题 You are right, our customer have written a class inherit CustomTableItem class, which named as EventLogItem. We also have a CustomTable named as Ev 阅读全文

posted @ 2022-06-30 13:50 ChuckLu 阅读(74) 评论(0) 推荐(0)

Kentico There is already an open DataReader associated with this Command which must be closed first.

摘要： System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.at System.Data.SqlClient 阅读全文

posted @ 2022-06-30 12:09 ChuckLu 阅读(265) 评论(0) 推荐(0)

2022年6月29日

Stairway to SQL Server Indexes

摘要： Stairway to SQL Server Indexes Indexes are fundamental to database design, and tell the developer using the database a great deal about the intentions 阅读全文

posted @ 2022-06-29 00:46 ChuckLu 阅读(65) 评论(0) 推荐(0)

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 阅读(84) 评论(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 阅读(97) 评论(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 阅读(81) 评论(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 阅读(61) 评论(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 阅读(59) 评论(0) 推荐(0)

Chuck Lu

公告