摘要：sql慢查询分析优化步骤： 1.使用profiler记录慢查询的语句到日志文件 2.分析日志文件找到慢的sql语句 3.使用查询分析器和数据库引擎优化顾问，找到性能瓶颈得出优化建议 阅读全文

摘要：在项目中采用wcf通讯，客户端很多地方调用服务，需要统一的处理超时和通讯异常以及关闭连接。1.调用尝试和异常捕获首先，项目中添加一个通用类ServiceDelegate.cs 1 public delegate void UseServiceDelegate(T proxy); 2 3 public static class Service 4 { 5 public static ChannelFactory _channelFactory = new ChannelFactory(""); 6 7 public static void Use(UseServiceDel. 阅读全文

摘要：http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/guid-vs-int-debate.aspxI recently read a blog post on what was better using GUIDs or Integer values. This is been an age long debate and there are advocates in both camps stressing on the disadvantages of the other. Well both implementations ha 阅读全文