asp.net,c#,sql server

摘要: Excpetion is a situation when a piece of code encounters some unexpected problem while running, and couldn't accomplish its task. The emphasis on the “unexpected“ is important, because it ...阅读全文

摘要: 子查询优化 一条好的值得称赞的规则是尽量用连接代替所有的子查询。优化器有时可以自动将子查询“扁平化”，并且用常规或外连接代替。但那样也不总是有效。明确的连接对选择表的顺序和找到最可能的计划给出了更多的选项。当你优化一个特殊查询时，了解一下是否去掉自查询可产生很大的差异。 示例 下面查询选择了pubs数据库中所有表的名字，以及每个表的聚集索引（如果存在）。如果没有聚集索引，表...阅读全文

摘要: 40 simultaneous connections!! Couple that with no HTTP Keep-Alives and it may actually work for you... From that post (for my own reference, as it was down some days ago):A lot of people were pinging ...阅读全文