Love Fendi - 博客园

性能优化系列---查询高cup的sql

摘要： SELECT TOP 10 [Average CPU used] = total_worker_time / qs.execution_count,[Total CPU used] = total_worker_time,[Execution count] = qs.execution_count,[Individual Query] = SUBSTRING (qt.text,qs.stateme... 阅读全文

posted @ 2010-02-26 13:17 Love Fendi 阅读(241) 评论(0) 推荐(0) 编辑

State模式学习

摘要： enum DocumentState{ readonly,Editable}class Document{DocumentState state;public void Handle(){if(state=DocumentState.readonly){}else{}}}-------------------------------------abstract clasass StatedDocu... 阅读全文

posted @ 2009-11-01 21:53 Love Fendi 阅读(191) 评论(0) 推荐(0) 编辑

8.17--8.24积累

摘要： 1. 性能优化 performence tuning 1.1 css compressor http://www.cssdrive.com/index.php/main/csscompressor 1.2 js optimizer http://www.xtreeme.com/javascript-optimizer/2Nhibernate profile 用于Nhibernate的调试3.利用f... 阅读全文

posted @ 2009-08-20 21:00 Love Fendi 阅读(184) 评论(0) 推荐(0) 编辑

sql server 2005 analysis service step by step(三)：创建父子维度

摘要： 1.什么是父子维度。 the parent-child relationship in the table that the wizard detected by the self-referencing join on the table.例如在Dim.Employee表中有个外键是ParentEmployeeKey,她关联的主键就是.Employee表的EmployKey建。 2. 创建父子维... 阅读全文

posted @ 2009-04-27 22:47 Love Fendi 阅读(443) 评论(0) 推荐(0) 编辑

sql server 2005 analysis service step by step(二)：创建时间维度

摘要： 1. In Solution Explorer, right-click the Dimensions folder, click New Dimension, and then click Next. 2. Clear the Auto Build check box, and then click Next. 3. Click the SSAS Step by Step DW DSV, and... 阅读全文

posted @ 2009-04-26 21:30 Love Fendi 阅读(646) 评论(0) 推荐(0) 编辑

sql serve 2005 analysis service step by step(一)：创建标准维度

摘要：一. add a datasource 新增数据源 Add a data source to an Analysis Services project1. If necessary, start SQL Server Business Intelligence Development Studio (BIDS).2. On the File menu, point to New, and then... 阅读全文

posted @ 2009-04-23 21:48 Love Fendi 阅读(496) 评论(0) 推荐(0) 编辑

算法练习五：求数组中第k大的数

摘要： static int FindK(IList a, int k) { IList listTemp; int start=0; int end = a.Count-1; int middle = (start + end) / 2; //int a= ... 阅读全文

posted @ 2009-04-08 11:27 Love Fendi 阅读(750) 评论(1) 推荐(0) 编辑

算法练习四：求N!不溢出

摘要：思想：普通的按递归的方法求阶层的话，到70的时候就会溢出了。所以采用数组去保存结果的每一位数字， static void Main(string[] args) { int[] a = CalculateLargeNumber(5); for (int i = a.Length-1; i >= 0; i--) ... 阅读全文

posted @ 2009-04-07 13:44 Love Fendi 阅读(225) 评论(0) 推荐(0) 编辑

算法练习三：奇偶分割

摘要： static void Main(string[] args) { int[] a = new int[] { 1,2,3,4,5,6,7,8,9,16,18}; int[] b = FenGei(a); foreach (int i in b) { ... 阅读全文

posted @ 2009-04-02 16:40 Love Fendi 阅读(219) 评论(0) 推荐(0) 编辑

算法练习二：二分查找

摘要： static void Main(string[] args) { int[] a=new int[] {1,3,58,654,7,9,11,18,17}; int c = Serarch(a, 9); Console.WriteLine(c); Console.ReadLine();... 阅读全文

posted @ 2009-04-02 15:40 Love Fendi 阅读(153) 评论(0) 推荐(0) 编辑

Tracy.Bai

导航

公告