2013年06月_garcon1986

10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 SQL Server Management Studio Tips : How to activate saving table modifications

How to activate saving table modifications

2013-06-28 18:19:08 739

原创 SQL 2008 Installation error: Impossible de charger le fichier ou l'assembly System, Version=4.0.0.0

/*Author: Jiangong SUN*/The error:Impossible de charger le fichier ou l'assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' ou une de ses dépendances. Le f

2013-06-28 17:09:51 1566

原创 What is Index and how it works in SQL Server?

What is Index and how it works in SQL Server?

2013-06-27 21:05:32 1525

原创 SQL Optimization

Table should have primary keyTable should have minimum of one clustered indexTable should have appropriate amount of non-clustered indexNon-clustered index should be created on columns of table

2013-06-19 02:02:21 734

原创交流技巧

/*Author: Jiangong SUN*/好的交流者：积极的倾听者，印象深刻的演讲者，快速的思考者，双赢的协商者。经济的成功15%来自个人的只是，85%来自和人的相处技巧和带来的信任和尊重。面对面的交流中, 身体语言占到50%，声音声调占到40%，话语占到10%。我们更喜欢和好的倾听者说话，而不是演讲者。 80% vs 20%好

2013-06-10 03:27:56 676

原创 Design patterns IV : Decorator/Wrapper Pattern

Design patterns IV : Decorator/Wrapper Pattern

2013-06-08 01:55:18 1319

原创 Refactoring - Bad Smells in Code

/*Author: Jiangong SUN*/There is a list of refactoring techniques with examples.http://www.refactoring.com/catalog/1. Duplicated codeExtract method or Extract class2. Long meth

2013-06-05 06:53:26 1019

原创 Refactoring - replace Switch statement with state/strategy

/*Author: Jiangong SUN*/switch statements is procedural structure, not object programming, it can be replaced by strategy pattern with implementation of interface/abstract strategy, with con

2013-06-05 02:11:58 1440

原创 Knowledge Conclusion - PART VI: WCF

/*Author: Jiangong SUN*/Last update: 18/06/20131. What is WCF and how it works?Windows Communication Foundation is a framework for intercommunication between different applications reg

2013-06-03 19:20:09 746

原创 NET Framework 4.0 new features

/*Author: Jiangong SUN*/Named and optional parameters: public class NamedOptionalParameter { public int Add(int x, int y, int z) { return x + y + z;

2013-06-03 18:46:13 809

原创 CSharp - Value types vs reference types

/*Author: Jiangong SUN*/public class CompareValueTypeAndReferenceType { public class ReferenceClass { public string Value { get; set; } } pu

2013-06-03 04:12:20 867

原创 CSharp - Collections(List, Dictionary) vs Generic collections(ArrayList, HashTable)

/*Author: Jiangong SUN*/I'll add 5 million numbers using ArrayList, List and List. We will compare the time used for each iteration.ArrayLi

2013-06-01 20:13:02 1786

原创 CSharp - Modifiers

Access Modifiers:publicprivateinternalprotectedModifiers:abstract: Indicates that a class is intended only to be a base class of other classes.async: Indicates that the modified

2013-06-01 05:30:53 730

原创 CSharp - Unsafe code

/*Author: Jiangong SUN*/To maintain type safety and security, C# does not support pointer arithmetic, by default. However, by using the unsafe keyword, you can define an unsafe context in wh

2013-06-01 05:16:45 913

原创 CSharp - Anonymous method

/*Author: Jiangong SUN*/In versions of C# previous to 2.0, the only way to declare a delegate was to use named methods. C# 2.0 introduces anonymous methods.Creating anonymous methods is essent

2013-06-01 04:20:25 1191