﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>博客园-zping-最新评论</title><link>http://www.cnblogs.com/zping/CommentsRSS.aspx</link><description>SQL SERVER，ORACLE数据库分析,设计,研究,优化,重构等</description><language>zh-cn</language><pubDate>Thu, 12 Jan 2012 10:13:31 GMT</pubDate><lastBuildDate>Thu, 12 Jan 2012 10:13:31 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:清理大批量数据例子</title><link>http://www.cnblogs.com/zping/archive/2011/11/14/2169974.html#2243194</link><dc:creator>jamesten</dc:creator><author>jamesten</author><pubDate>Mon, 14 Nov 2011 09:36:52 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/11/14/2169974.html#2243194</guid><description><![CDATA[非常好的例子，兄弟的博客很久没有更新了？<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">jamesten</a> 2011-11-14 17:36 <a href="http://www.cnblogs.com/zping/archive/2011/11/14/2169974.html#2243194#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:一条诡异的SQL</title><link>http://www.cnblogs.com/zping/archive/2011/09/08/2169940.html#2195388</link><dc:creator>gobird</dc:creator><author>gobird</author><pubDate>Thu, 08 Sep 2011 05:53:20 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/09/08/2169940.html#2195388</guid><description><![CDATA[前面的看懂了,解释没看懂.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">gobird</a> 2011-09-08 13:53 <a href="http://www.cnblogs.com/zping/archive/2011/09/08/2169940.html#2195388#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:浅谈系统优化设计--复杂运算放在逻辑层还是在数据库层？</title><link>http://www.cnblogs.com/zping/archive/2011/09/06/1336254.html#2193637</link><dc:creator>455582663</dc:creator><author>455582663</author><pubDate>Tue, 06 Sep 2011 03:54:02 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/09/06/1336254.html#2193637</guid><description><![CDATA[挺不错的<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">455582663</a> 2011-09-06 11:54 <a href="http://www.cnblogs.com/zping/archive/2011/09/06/1336254.html#2193637#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:经典存储过程</title><link>http://www.cnblogs.com/zping/archive/2011/08/16/1243361.html#2178452</link><dc:creator>海南.胡勇</dc:creator><author>海南.胡勇</author><pubDate>Tue, 16 Aug 2011 07:53:59 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/08/16/1243361.html#2178452</guid><description><![CDATA[兄弟，你这...<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">海南.胡勇</a> 2011-08-16 15:53 <a href="http://www.cnblogs.com/zping/archive/2011/08/16/1243361.html#2178452#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL优化--使用 EXISTS 代替 IN 和 inner join来选择正确的执行计划</title><link>http://www.cnblogs.com/zping/archive/2011/08/16/1260959.html#2178441</link><dc:creator>海南.胡勇</dc:creator><author>海南.胡勇</author><pubDate>Tue, 16 Aug 2011 07:47:23 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/08/16/1260959.html#2178441</guid><description><![CDATA[不能以pian gai quan.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">海南.胡勇</a> 2011-08-16 15:47 <a href="http://www.cnblogs.com/zping/archive/2011/08/16/1260959.html#2178441#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:数据库大型应用解决方案总结（转）</title><link>http://www.cnblogs.com/zping/archive/2011/08/16/1913857.html#2178405</link><dc:creator>海南.胡勇</dc:creator><author>海南.胡勇</author><pubDate>Tue, 16 Aug 2011 07:14:10 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/08/16/1913857.html#2178405</guid><description><![CDATA[GOot article.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">海南.胡勇</a> 2011-08-16 15:14 <a href="http://www.cnblogs.com/zping/archive/2011/08/16/1913857.html#2178405#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server 同步复制要点</title><link>http://www.cnblogs.com/zping/archive/2011/07/05/1913000.html#2143751</link><dc:creator>ms sql菜鸟</dc:creator><author>ms sql菜鸟</author><pubDate>Tue, 05 Jul 2011 09:35:36 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/07/05/1913000.html#2143751</guid><description><![CDATA[今年当开始了MS SQL的工作，看到你的东西，受益匪浅啊
<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">ms sql菜鸟</a> 2011-07-05 17:35 <a href="http://www.cnblogs.com/zping/archive/2011/07/05/1913000.html#2143751#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL server 系统优化--通过执行计划优化索引（1）</title><link>http://www.cnblogs.com/zping/archive/2011/05/26/1288583.html#2106936</link><dc:creator>chen1177</dc:creator><author>chen1177</author><pubDate>Thu, 26 May 2011 02:56:39 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/05/26/1288583.html#2106936</guid><description><![CDATA[[quote]zping.com：@zyli
&lt;br/&gt;将数据库兼容级别从“80”改成”90“[/quote]
我是从2000升级到2005，请问修改哪个数据库的兼容级别<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">chen1177</a> 2011-05-26 10:56 <a href="http://www.cnblogs.com/zping/archive/2011/05/26/1288583.html#2106936#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server性能分析--检测数据库阻塞语句</title><link>http://www.cnblogs.com/zping/archive/2011/03/14/1211617.html#2045978</link><dc:creator>zping</dc:creator><author>zping</author><pubDate>Mon, 14 Mar 2011 03:13:47 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/03/14/1211617.html#2045978</guid><description><![CDATA[@yishanhai
通过sql_handle获取sql语句，具体看DMVS表值函数。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">zping</a> 2011-03-14 11:13 <a href="http://www.cnblogs.com/zping/archive/2011/03/14/1211617.html#2045978#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server性能分析--检测数据库阻塞语句</title><link>http://www.cnblogs.com/zping/archive/2011/03/11/1211617.html#2044620</link><dc:creator>yishanhai</dc:creator><author>yishanhai</author><pubDate>Fri, 11 Mar 2011 10:29:30 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2011/03/11/1211617.html#2044620</guid><description><![CDATA[您好， cross apply sys.dm_exec_sql_text(a.sql_handle) b
 是什么意思？谢谢<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">yishanhai</a> 2011-03-11 18:29 <a href="http://www.cnblogs.com/zping/archive/2011/03/11/1211617.html#2044620#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:数据库设计--多对多模式(转)</title><link>http://www.cnblogs.com/zping/archive/2010/08/30/1260397.html#1904405</link><dc:creator>魅影骑士</dc:creator><author>魅影骑士</author><pubDate>Mon, 30 Aug 2010 02:09:04 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2010/08/30/1260397.html#1904405</guid><description><![CDATA[写的很好，就是简单了点，如果能加上一个实例就更好了
<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">魅影骑士</a> 2010-08-30 10:09 <a href="http://www.cnblogs.com/zping/archive/2010/08/30/1260397.html#1904405#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server性能分析--执行sql次数和逻辑次数</title><link>http://www.cnblogs.com/zping/archive/2010/08/14/1243367.html#1893420</link><dc:creator>serf _lee</dc:creator><author>serf _lee</author><pubDate>Sat, 14 Aug 2010 11:18:57 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2010/08/14/1243367.html#1893420</guid><description><![CDATA[学习了。 相当于数据的跟踪功能了<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">serf _lee</a> 2010-08-14 19:18 <a href="http://www.cnblogs.com/zping/archive/2010/08/14/1243367.html#1893420#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:JProfiler V5.1.4注册</title><link>http://www.cnblogs.com/zping/archive/2010/06/22/1671743.html#1853690</link><dc:creator>辰</dc:creator><author>辰</author><pubDate>Tue, 22 Jun 2010 07:35:28 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2010/06/22/1671743.html#1853690</guid><description><![CDATA[还是博客园最好。其他垃圾网站什么javaeye之类的，都下不了<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">辰</a> 2010-06-22 15:35 <a href="http://www.cnblogs.com/zping/archive/2010/06/22/1671743.html#1853690#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Sql Server 2005  统计信息用途</title><link>http://www.cnblogs.com/zping/archive/2010/05/21/1247210.html#1829410</link><dc:creator>znyin</dc:creator><author>znyin</author><pubDate>Fri, 21 May 2010 00:35:12 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2010/05/21/1247210.html#1829410</guid><description><![CDATA[不错，顶<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">znyin</a> 2010-05-21 08:35 <a href="http://www.cnblogs.com/zping/archive/2010/05/21/1247210.html#1829410#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL 语句优化--IN语句优化案例</title><link>http://www.cnblogs.com/zping/archive/2010/05/03/1290990.html#1815453</link><dc:creator>yongfa365</dc:creator><author>yongfa365</author><pubDate>Mon, 03 May 2010 06:16:08 GMT</pubDate><guid>http://www.cnblogs.com/zping/archive/2010/05/03/1290990.html#1815453</guid><description><![CDATA[N年前留贴，问题今天解决：

SET STATISTICS IO ON 
SET STATISTICS TIME ON

SELECT Id,username,[dbo].[fn_GetPinyin](username) FROM dbo.Users 

SET STATISTICS TIME OFF
SET STATISTICS IO OFF<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/zping/" target="_blank">yongfa365</a> 2010-05-03 14:16 <a href="http://www.cnblogs.com/zping/archive/2010/05/03/1290990.html#1815453#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
