﻿<?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>博客园-SQL Server -最新评论</title><link>http://www.cnblogs.com/nzperfect/CommentsRSS.aspx</link><description /><language>zh-cn</language><pubDate>Thu, 31 May 2012 02:32:50 GMT</pubDate><lastBuildDate>Thu, 31 May 2012 02:32:50 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:测试sql server 2008 Mirror+log shipping+replication 同时存在，并故障转移后，log shipping 和 replication不受影响,可继续使用</title><link>http://www.cnblogs.com/nzperfect/archive/2012/04/09/1552739.html#2350801</link><dc:creator>希望虫</dc:creator><author>希望虫</author><pubDate>Mon, 09 Apr 2012 08:41:11 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/04/09/1552739.html#2350801</guid><description><![CDATA[谢谢楼主，问题已解决！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">希望虫</a> 2012-04-09 16:41 <a href="http://www.cnblogs.com/nzperfect/archive/2012/04/09/1552739.html#2350801#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:测试sql server 2008 Mirror+log shipping+replication 同时存在，并故障转移后，log shipping 和 replication不受影响,可继续使用</title><link>http://www.cnblogs.com/nzperfect/archive/2012/04/09/1552739.html#2350293</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Mon, 09 Apr 2012 01:51:07 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/04/09/1552739.html#2350293</guid><description><![CDATA[[quote]希望虫：
http://support.microsoft.com/kb/937041
我按照这个来跟踪1448，但是启动参数 改后 ，服务启动不了。不知道啥问题[/quote]

方案没有问题，你的问题可能是其它原因了，检查一下log吧。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2012-04-09 09:51 <a href="http://www.cnblogs.com/nzperfect/archive/2012/04/09/1552739.html#2350293#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:测试sql server 2008 Mirror+log shipping+replication 同时存在，并故障转移后，log shipping 和 replication不受影响,可继续使用</title><link>http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349677</link><dc:creator>希望虫</dc:creator><author>希望虫</author><pubDate>Sun, 08 Apr 2012 01:05:46 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349677</guid><description><![CDATA[http://support.microsoft.com/kb/937041
我按照这个来跟踪1448，但是启动参数 改后 ，服务启动不了。不知道啥问题<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">希望虫</a> 2012-04-08 09:05 <a href="http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349677#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:测试sql server 2008 Mirror+log shipping+replication 同时存在，并故障转移后，log shipping 和 replication不受影响,可继续使用</title><link>http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349660</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Sun, 08 Apr 2012 00:04:36 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349660</guid><description><![CDATA[[quote]希望虫：
46760558, 请加我QQ。镜像上建立复制问题：
主体和镜像都可用时，没有问题，
一但二者丢失一个， 日志读取器代理就报错：
复制的事务正等待下一次日志备份或等待镜像伙伴更新[/quote]

你可以使用trace flag 1448来解决这个问题。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2012-04-08 08:04 <a href="http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349660#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:测试sql server 2008 Mirror+log shipping+replication 同时存在，并故障转移后，log shipping 和 replication不受影响,可继续使用</title><link>http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349657</link><dc:creator>希望虫</dc:creator><author>希望虫</author><pubDate>Sat, 07 Apr 2012 23:54:46 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349657</guid><description><![CDATA[46760558, 请加我QQ。镜像上建立复制问题：
主体和镜像都可用时，没有问题，
一但二者丢失一个， 日志读取器代理就报错：
复制的事务正等待下一次日志备份或等待镜像伙伴更新<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">希望虫</a> 2012-04-08 07:54 <a href="http://www.cnblogs.com/nzperfect/archive/2012/04/08/1552739.html#2349657#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2008 install SP3后，发布数据库log变得越来越大</title><link>http://www.cnblogs.com/nzperfect/archive/2012/03/09/2384783.html#2326749</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Fri, 09 Mar 2012 06:31:11 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/03/09/2384783.html#2326749</guid><description><![CDATA[邮件请教了下微软支持组，得到答复了：
[b]这是一个已知问题，解决方案请参考以下kb文档, 谢谢。
http://support.microsoft.com/kb/2509302[/b]<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2012-03-09 14:31 <a href="http://www.cnblogs.com/nzperfect/archive/2012/03/09/2384783.html#2326749#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2008 install SP3后，发布数据库log变得越来越大</title><link>http://www.cnblogs.com/nzperfect/archive/2012/03/08/2384783.html#2325571</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Thu, 08 Mar 2012 04:39:50 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/03/08/2384783.html#2325571</guid><description><![CDATA[@CareySon
补丁出一个月，我们基本上是都要打的，补丁总会修订一些我们知道或不知道的问题。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2012-03-08 12:39 <a href="http://www.cnblogs.com/nzperfect/archive/2012/03/08/2384783.html#2325571#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2008 install SP3后，发布数据库log变得越来越大</title><link>http://www.cnblogs.com/nzperfect/archive/2012/03/08/2384783.html#2325556</link><dc:creator>CareySon</dc:creator><author>CareySon</author><pubDate>Thu, 08 Mar 2012 04:13:25 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/03/08/2384783.html#2325556</guid><description><![CDATA[受教了，当时为什么要打sp3补丁呢？为了解决什么问题?<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">CareySon</a> 2012-03-08 12:13 <a href="http://www.cnblogs.com/nzperfect/archive/2012/03/08/2384783.html#2325556#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2012 正式发布</title><link>http://www.cnblogs.com/nzperfect/archive/2012/03/08/2383437.html#2325394</link><dc:creator>CareySon</dc:creator><author>CareySon</author><pubDate>Thu, 08 Mar 2012 01:48:29 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/03/08/2383437.html#2325394</guid><description><![CDATA[@nzperfect
  可读镜像实现读写分离来的太晚了.下一个跑跑试试<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">CareySon</a> 2012-03-08 09:48 <a href="http://www.cnblogs.com/nzperfect/archive/2012/03/08/2383437.html#2325394#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2012 正式发布</title><link>http://www.cnblogs.com/nzperfect/archive/2012/03/07/2383437.html#2324900</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Wed, 07 Mar 2012 08:38:00 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/03/07/2383437.html#2324900</guid><description><![CDATA[@CareySon
对，下载下来先用用，特别是那个 alwayson.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2012-03-07 16:38 <a href="http://www.cnblogs.com/nzperfect/archive/2012/03/07/2383437.html#2324900#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2012 正式发布</title><link>http://www.cnblogs.com/nzperfect/archive/2012/03/07/2383437.html#2324868</link><dc:creator>CareySon</dc:creator><author>CareySon</author><pubDate>Wed, 07 Mar 2012 08:02:35 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/03/07/2383437.html#2324868</guid><description><![CDATA[普及需要一段时间。先学点新特性吧。SQL Server一个版本比一个版本更让人振奋。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">CareySon</a> 2012-03-07 16:02 <a href="http://www.cnblogs.com/nzperfect/archive/2012/03/07/2383437.html#2324868#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:令人无法理解的死锁案例分析</title><link>http://www.cnblogs.com/nzperfect/archive/2012/02/29/2192006.html#2319708</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Wed, 29 Feb 2012 05:18:00 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/02/29/2192006.html#2319708</guid><description><![CDATA[[quote]魔君六道：好文章，微软亚太区数据库技术支持组还是满亲民的，上次请教那个 crash recovery 的过程他们也回复的很快。[/quote]

那我知道你是谁了，呵呵。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2012-02-29 13:18 <a href="http://www.cnblogs.com/nzperfect/archive/2012/02/29/2192006.html#2319708#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:[分享]系统crash后SQL Server 在recovery时的rollback机制</title><link>http://www.cnblogs.com/nzperfect/archive/2012/02/29/2360887.html#2319463</link><dc:creator>CareySon</dc:creator><author>CareySon</author><pubDate>Wed, 29 Feb 2012 02:03:51 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/02/29/2360887.html#2319463</guid><description><![CDATA[非常感谢分享。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">CareySon</a> 2012-02-29 10:03 <a href="http://www.cnblogs.com/nzperfect/archive/2012/02/29/2360887.html#2319463#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:令人无法理解的死锁案例分析</title><link>http://www.cnblogs.com/nzperfect/archive/2012/02/28/2192006.html#2319173</link><dc:creator>魔君六道</dc:creator><author>魔君六道</author><pubDate>Tue, 28 Feb 2012 11:55:47 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/02/28/2192006.html#2319173</guid><description><![CDATA[好文章，微软亚太区数据库技术支持组还是满亲民的，上次请教那个 crash recovery 的过程他们也回复的很快。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">魔君六道</a> 2012-02-28 19:55 <a href="http://www.cnblogs.com/nzperfect/archive/2012/02/28/2192006.html#2319173#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:令人无法理解的死锁案例分析</title><link>http://www.cnblogs.com/nzperfect/archive/2012/02/28/2192006.html#2319032</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Tue, 28 Feb 2012 09:14:53 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2012/02/28/2192006.html#2319032</guid><description><![CDATA[微软支持组回复：
[url=http://blogs.msdn.com/b/apgcdsd/archive/2012/02/28/sql-server-deadlock.aspx]http://blogs.msdn.com/b/apgcdsd/archive/2012/02/28/sql-server-deadlock.aspx[/url]<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2012-02-28 17:14 <a href="http://www.cnblogs.com/nzperfect/archive/2012/02/28/2192006.html#2319032#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:在发布订阅中增加rowversion数据类型字段引发错误(or bug)</title><link>http://www.cnblogs.com/nzperfect/archive/2011/12/06/2270427.html#2263412</link><dc:creator>toEverybody</dc:creator><author>toEverybody</author><pubDate>Tue, 06 Dec 2011 10:37:22 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/12/06/2270427.html#2263412</guid><description><![CDATA[向微软反应这种情况。。不过新产品的Bug多是正常的，所以一般我不跟风，数据可不是玩着耍的，呵呵。。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">toEverybody</a> 2011-12-06 18:37 <a href="http://www.cnblogs.com/nzperfect/archive/2011/12/06/2270427.html#2263412#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:在发布订阅中增加rowversion数据类型字段引发错误(or bug)</title><link>http://www.cnblogs.com/nzperfect/archive/2011/12/02/2270427.html#2259204</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Fri, 02 Dec 2011 02:30:08 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/12/02/2270427.html#2259204</guid><description><![CDATA[经微软客户支持组确认，这应该是产品问题，是一个Bug.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2011-12-02 10:30 <a href="http://www.cnblogs.com/nzperfect/archive/2011/12/02/2270427.html#2259204#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:存在即更新反之插入的三种防唯一键冲突和死锁的写法</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/30/2193143.html#2257837</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Wed, 30 Nov 2011 13:54:08 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/30/2193143.html#2257837</guid><description><![CDATA[@鸽子飞扬
是的，但事务很短，等待比死锁还是要好一些。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2011-11-30 21:54 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/30/2193143.html#2257837#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:存在即更新反之插入的三种防唯一键冲突和死锁的写法</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/30/2193143.html#2257799</link><dc:creator>鸽子飞扬</dc:creator><author>鸽子飞扬</author><pubDate>Wed, 30 Nov 2011 12:29:23 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/30/2193143.html#2257799</guid><description><![CDATA[第3写法新颖啊，加了 serializable 既不是降低了并发量<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">鸽子飞扬</a> 2011-11-30 20:29 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/30/2193143.html#2257799#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:关于Blocked Process Report 一个让人迷惑的问题分析</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/25/2263264.html#2253649</link><dc:creator>czperfectaction</dc:creator><author>czperfectaction</author><pubDate>Fri, 25 Nov 2011 07:37:31 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/25/2263264.html#2253649</guid><description><![CDATA[good practise~~<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">czperfectaction</a> 2011-11-25 15:37 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/25/2263264.html#2253649#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:[荐]SAN Performance Tuning with SQLIO</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/25/2259023.html#2253538</link><dc:creator>徐郞顾</dc:creator><author>徐郞顾</author><pubDate>Fri, 25 Nov 2011 06:14:26 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/25/2259023.html#2253538</guid><description><![CDATA[好东西<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">徐郞顾</a> 2011-11-25 14:14 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/25/2259023.html#2253538#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:[转]收缩数据文件会导致严重的索引碎片,KG写的.</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/23/1768876.html#2251760</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Wed, 23 Nov 2011 08:25:55 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/23/1768876.html#2251760</guid><description><![CDATA[工具名称：
http://internalsviewer.codeplex.com/<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2011-11-23 16:25 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/23/1768876.html#2251760#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server 2000 单主键高效分页存储过程</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/22/1503237.html#2250814</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Tue, 22 Nov 2011 08:58:08 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/22/1503237.html#2250814</guid><description><![CDATA[@hh007
这个是07年写的了<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2011-11-22 16:58 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/22/1503237.html#2250814#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server 2000 单主键高效分页存储过程</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/22/1503237.html#2250808</link><dc:creator>hh007</dc:creator><author>hh007</author><pubDate>Tue, 22 Nov 2011 08:55:20 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/22/1503237.html#2250808</guid><description><![CDATA[都两年前的文章了，我现在都还在用ASP呢。。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">hh007</a> 2011-11-22 16:55 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/22/1503237.html#2250808#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server 2000 单主键高效分页存储过程</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/06/1503237.html#2236924</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Sun, 06 Nov 2011 14:08:49 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/06/1503237.html#2236924</guid><description><![CDATA[@永川城市门户
对C#不精通，也太久没写过程序了，不好意思了。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2011-11-06 22:08 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/06/1503237.html#2236924#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server 2000 单主键高效分页存储过程</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/05/1503237.html#2236277</link><dc:creator>永川城市门户</dc:creator><author>永川城市门户</author><pubDate>Sat, 05 Nov 2011 11:32:55 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/05/1503237.html#2236277</guid><description><![CDATA[ 能否提供一下C#版的调用示例呢 <br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">永川城市门户</a> 2011-11-05 19:32 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/05/1503237.html#2236277#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:某个订阅库下存在很多关于更新MSreplication_subscriptions表造成的大量死锁</title><link>http://www.cnblogs.com/nzperfect/archive/2011/11/04/2234015.html#2235585</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Fri, 04 Nov 2011 06:34:24 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/11/04/2234015.html#2235585</guid><description><![CDATA[观察一天，已无死锁！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2011-11-04 14:34 <a href="http://www.cnblogs.com/nzperfect/archive/2011/11/04/2234015.html#2235585#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:令人无法理解的死锁案例分析</title><link>http://www.cnblogs.com/nzperfect/archive/2011/09/27/2192006.html#2208840</link><dc:creator>无为是最高</dc:creator><author>无为是最高</author><pubDate>Tue, 27 Sep 2011 04:01:24 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/09/27/2192006.html#2208840</guid><description><![CDATA[呵，正好也在研究这个，我也无法理解其为啥会导致死锁。也许就是max的错。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">无为是最高</a> 2011-09-27 12:01 <a href="http://www.cnblogs.com/nzperfect/archive/2011/09/27/2192006.html#2208840#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:令人无法理解的死锁案例分析</title><link>http://www.cnblogs.com/nzperfect/archive/2011/09/26/2192006.html#2208308</link><dc:creator>木鱼</dc:creator><author>木鱼</author><pubDate>Mon, 26 Sep 2011 12:20:40 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/09/26/2192006.html#2208308</guid><description><![CDATA[嗯。。对锁不是很熟悉……个人猜测是SPID54在开始的U锁加锁时没有覆盖所有的数据页（为了保证锁尽可能少的数据量），后来发现要更新C的数据所以需要重新加锁（因为之前锁的范围不够）。
个人猜测，不对不要踩我 :-(<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">木鱼</a> 2011-09-26 20:20 <a href="http://www.cnblogs.com/nzperfect/archive/2011/09/26/2192006.html#2208308#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:【分享】我想成为坐在路边鼓掌的人</title><link>http://www.cnblogs.com/nzperfect/archive/2011/08/22/1886480.html#2183011</link><dc:creator>czperfectaction</dc:creator><author>czperfectaction</author><pubDate>Mon, 22 Aug 2011 08:55:54 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/08/22/1886480.html#2183011</guid><description><![CDATA[好文，中国的教育折射出：一个喜欢“外交”的孩子竟然是那么受欢迎，从悲观的角度说是一个悲哀<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">czperfectaction</a> 2011-08-22 16:55 <a href="http://www.cnblogs.com/nzperfect/archive/2011/08/22/1886480.html#2183011#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:取硬盘大小及可用空间</title><link>http://www.cnblogs.com/nzperfect/archive/2011/07/29/2119659.html#2163781</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Fri, 29 Jul 2011 01:17:36 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/07/29/2119659.html#2163781</guid><description><![CDATA[[quote]三人行，必有我师：
取硬盘可用空间可用系统过程实现：
 EXEC master.sys.xp_fixeddrives[/quote]

是的，不过取不了硬盘总大小。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2011-07-29 09:17 <a href="http://www.cnblogs.com/nzperfect/archive/2011/07/29/2119659.html#2163781#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:取硬盘大小及可用空间</title><link>http://www.cnblogs.com/nzperfect/archive/2011/07/28/2119659.html#2163288</link><dc:creator>三人行，必有我师</dc:creator><author>三人行，必有我师</author><pubDate>Thu, 28 Jul 2011 08:18:45 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2011/07/28/2119659.html#2163288</guid><description><![CDATA[取硬盘可用空间可用系统过程实现：
 EXEC master.sys.xp_fixeddrives<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">三人行，必有我师</a> 2011-07-28 16:18 <a href="http://www.cnblogs.com/nzperfect/archive/2011/07/28/2119659.html#2163288#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Process Explorer v14.01 Windows进程查看</title><link>http://www.cnblogs.com/nzperfect/archive/2010/12/03/1886670.html#1976329</link><dc:creator>Gerrard</dc:creator><author>Gerrard</author><pubDate>Fri, 03 Dec 2010 02:00:13 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2010/12/03/1886670.html#1976329</guid><description><![CDATA[喔~ 竟然更新了<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">Gerrard</a> 2010-12-03 10:00 <a href="http://www.cnblogs.com/nzperfect/archive/2010/12/03/1886670.html#1976329#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:鼻中隔偏曲手术_15年鼻炎斗争最后的抉择</title><link>http://www.cnblogs.com/nzperfect/archive/2010/11/20/1873714.html#1965214</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Sat, 20 Nov 2010 09:08:02 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2010/11/20/1873714.html#1965214</guid><description><![CDATA[@Gerrard
谢谢Gerrard，现在的确比以前好太多了，逐步恢复中。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2010-11-20 17:08 <a href="http://www.cnblogs.com/nzperfect/archive/2010/11/20/1873714.html#1965214#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:鼻中隔偏曲手术_15年鼻炎斗争最后的抉择</title><link>http://www.cnblogs.com/nzperfect/archive/2010/11/20/1873714.html#1965015</link><dc:creator>Gerrard</dc:creator><author>Gerrard</author><pubDate>Sat, 20 Nov 2010 02:16:21 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2010/11/20/1873714.html#1965015</guid><description><![CDATA[恭喜NZ,脱离了困扰N年的东西 : )

看完后真庆幸自己没有鼻炎...过程真够痛苦.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">Gerrard</a> 2010-11-20 10:16 <a href="http://www.cnblogs.com/nzperfect/archive/2010/11/20/1873714.html#1965015#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:修改SQL Server 2005/2008 用户数据库文件默认路径和默认备份路径</title><link>http://www.cnblogs.com/nzperfect/archive/2010/11/18/1724557.html#1963215</link><dc:creator>lindon_poppy</dc:creator><author>lindon_poppy</author><pubDate>Thu, 18 Nov 2010 01:15:39 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2010/11/18/1724557.html#1963215</guid><description><![CDATA[不错 不错<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">lindon_poppy</a> 2010-11-18 09:15 <a href="http://www.cnblogs.com/nzperfect/archive/2010/11/18/1724557.html#1963215#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2008 Datetime Cast 成 Date 类型可以使用索引</title><link>http://www.cnblogs.com/nzperfect/archive/2010/06/01/1746509.html#1837395</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Tue, 01 Jun 2010 01:37:30 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2010/06/01/1746509.html#1837395</guid><description><![CDATA[@Gerrard
WindowsLiveWriter在windows 2003不能使用，真遗憾.

春节前和微软的SQL Server企业培训工程师有聊起过，据称下个版本将会有一个支持负载的加强功能.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2010-06-01 09:37 <a href="http://www.cnblogs.com/nzperfect/archive/2010/06/01/1746509.html#1837395#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2008 Datetime Cast 成 Date 类型可以使用索引</title><link>http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836884</link><dc:creator>Gerrard</dc:creator><author>Gerrard</author><pubDate>Mon, 31 May 2010 07:09:21 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836884</guid><description><![CDATA[从这个执行计划的细节来看....
SQL Server从2000 直至 2008,都一直在进步,
包括真正意义的表分区,分析函数,动态管理视图,online维护,执行计划,优化器,等等...

但感觉还不够~ 哈哈 缺乏一点重口味的东西~ 

DB2 9.7已经开始搞个XX特性,兼容95%+以上的PLSQL程序...
还有以后的pureScale可以shared disk,64个结点间的通讯 只损耗&lt;10%的资源...
估计以后DB2会把ZOS那一套东西慢慢拿出来见人了,

Oracle也打算把rac的性能做一次大的改进....

很期待SQL Server出现重口味的那一天 : ) <br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">Gerrard</a> 2010-05-31 15:09 <a href="http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836884#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2008 Datetime Cast 成 Date 类型可以使用索引</title><link>http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836787</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Mon, 31 May 2010 05:26:51 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836787</guid><description><![CDATA[[quote]Gerrard：
访问速度不好的话,推荐用 WindowsLiveWriter ,在word里编辑好了,贴到WindowsLiveWriter里,直接点击发布...
在word里的图片会自动上传到blog里的 [/quote]

我试试，非常好的办法.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2010-05-31 13:26 <a href="http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836787#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server 2008 Datetime Cast 成 Date 类型可以使用索引</title><link>http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836786</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Mon, 31 May 2010 05:26:10 GMT</pubDate><guid>http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836786</guid><description><![CDATA[[quote]多拉A孟：
我只说2点（纯个人观点）：
1.从执行计划上看，第三中明显比第四高效。
2.第三种的写法可以改为 where  OPTIME &gt;='2010-05-27' AND
OPTIME &lt;'2010-05-28' [/quote]

是的，从执行计划上看，第三要比四少步骤，不过从IO上看是相同的page,执行计划上看，四比三多的步骤，开销相对为0%，基本上应该可以忽略.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/nzperfect/" target="_blank">nzperfect</a> 2010-05-31 13:26 <a href="http://www.cnblogs.com/nzperfect/archive/2010/05/31/1746509.html#1836786#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
