03 2011 档案
摘要:AN “Always Visible” area with JavaScript转自:http://www.msjoe.com/2011/03/an-always-visible-area-with-javascript/CSS:#stickydiv { position: fixed; visibility: hidden; height: 100px; width: 200px; background-color: Yellow; } HTML:<div id="stickydiv"> This is always visible</div> J
阅读全文
摘要:来自:http://www.cnbeta.com/articles/133129.htm?1299690294注:《代码阅读方法与实践》(Code Reading: The Open Source Perspective):http://www.verycd.com/topics/14267/原文作者Alan Skorkin是一名软件开发人员,他在博客中分享对软件开发相关的心得,其中有很多优秀的文章,本文是其中的另一篇。Alan认为:阅读优秀代码是提高开发人员修为的一种捷径。以下是全文。我突然想起来,很多程序员都讨厌阅读代码。来吧,承认吧! 每个人都喜欢编写代码,编代码是件趣事。 另一方面,阅
阅读全文
摘要:http://blog.sqlauthority.com/2011/03/08/sql-server-difference-between-countdistinct-vs-countall/COUNT(DISTINCT)和COUNT(ALL)的区别:前者像select distinct 字段1,字段2 from table一样会去掉重复的,后者则是统计字段的所有数据条数,与Count(字段1)相同。COUNT(ALL)中的ALL实际上是缺省项,不需要指定。(注:本人还有点怀疑COUNT(ALL)与COUNT(字段1)是否有区别,待验证)。Here is the script:1 SELECT
阅读全文
摘要:SQL Azure Performance – Query Optimization:http://www.sqlazureperformance.com/2010/sql-azure-performance-query-optimization/Simple Query tuning with STATISTICS IO and Execution plans:http://www.simple-talk.com/sql/performance/simple-query-tuning-with-statistics-io-and-execution-plans/显示图形执行计划 (SQL S
阅读全文