<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[李展的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/zhanli</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; zhanli]]></copyright><item><title><![CDATA[My new blog]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/5729140</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/5729140</guid><author>zhanli</author><pubDate>Mon, 12 Jul 2010 15:52:00 +0800</pubDate><description><![CDATA[<br />http://blogs.msdn.com/zhanli]]></description><category></category></item><item><title><![CDATA[出差香港]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/396878</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/396878</guid><author>zhanli</author><pubDate>Fri, 17 Jun 2005 17:48:00 +0800</pubDate><description><![CDATA[Hong Kong Hospital Authority(医管局)的SQL Server出了问题，SQL Server会不定期的产生stack dump，有时候产生stack dump后还会hang住。问题又被上升到Political的高度(哎,不知道那里来的这么多Political问题,什么问题一扯到它就麻烦)，香港方面直接打电话给Wing要求onsite.于是安排我去，找Visa Desk更新]]></description><category></category></item><item><title><![CDATA[一个实用的HTTP traffic探测工具：fiddler]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/376968</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/376968</guid><author>zhanli</author><pubDate>Fri, 20 May 2005 16:54:00 +0800</pubDate><description><![CDATA[http://www.fiddlertool.com/fiddler/]]></description><category></category></item><item><title><![CDATA[A Key SQL Server 2005 developer's blog]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/274654</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/274654</guid><author>zhanli</author><pubDate>Mon, 31 Jan 2005 09:46:00 +0800</pubDate><description><![CDATA[http://blogs.msdn.com/slavao]]></description><category></category></item><item><title><![CDATA[Company Meeting]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/264725</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/264725</guid><author>zhanli</author><pubDate>Sun, 23 Jan 2005 14:02:00 +0800</pubDate><description><![CDATA[昨天公司开年会聚餐，吃饺子没吃到铜钱，抽奖没抽到，红包没发。今天也没捡到钱，一会儿买张彩票去......]]></description><category></category></item><item><title><![CDATA[SQL Server 2005: 利用新的ranking函数实现高效的数据分页操作]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/259512</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/259512</guid><author>zhanli</author><pubDate>Wed, 19 Jan 2005 15:37:00 +0800</pubDate><description><![CDATA[最近MSDN Magazine上的一篇文章10 Tips for Writing High-Performance Web Applications提到了有效的数据分页技术对提高ASP .NET程序性能的重要性；并给出了一个实现数据分页的stored procedure的例子，抄录如下： CREATE PROCEDURE northwind_OrdersPaged(    @Pag]]></description><category></category></item><item><title><![CDATA[SQL Server merge replication: 巧用Merge Agent的hostname参数创建dynamic filter]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/259295</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/259295</guid><author>zhanli</author><pubDate>Wed, 19 Jan 2005 13:33:00 +0800</pubDate><description><![CDATA[我们知道，SQL Server 2000的Merge Replication支持dynamic filter的功能。如果我们有多个subscriber，每个subscriber只需要维护自己特定的数据，这时候我们只需创建一个publication, 然后利用dynamic filter的功能，把每个subscriber需要的特定数据复制过去。最常用的用于dynamic filter的系统函数是SU]]></description><category></category></item><item><title><![CDATA[SQL Server 2000 Reporting Services: 怎样根据用户的语言偏好显示本地化的信息]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/257958</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/257958</guid><author>zhanli</author><pubDate>Tue, 18 Jan 2005 14:19:00 +0800</pubDate><description><![CDATA[Microsoft的Reporting Servcies发布以来，由于其简单易用，功能强大，越来越多的用户选择它来做为报表解决方案。在当今国际化的大趋势下，很多用户在使用Reporting Servcies的时候会遇到一个难题，那就是怎样根据用户的语言偏好显示本地化的信息，比如为中国的用户显示中文的报表标题，为美国的用户显示英文的报表标题；还有如为不同国家的用户显示不同的货币符号等。本文提供了解决]]></description><category></category></item><item><title><![CDATA[SQL Server加过密的存储过程可以被解密？]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/253406</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/253406</guid><author>zhanli</author><pubDate>Fri, 14 Jan 2005 14:47:00 +0800</pubDate><description><![CDATA[1. Protecting the stored procedure and making it totally non-decryptable is technically impossible. There has to be a way to reverse it so that SQL Server can generate the execution plan and execute t]]></description><category></category></item><item><title><![CDATA[怎样手工删除数据库里的Merge Replication信息]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/217362</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/217362</guid><author>zhanli</author><pubDate>Wed, 15 Dec 2004 16:53:00 +0800</pubDate><description><![CDATA[1. The best way is to run sp_removedbreplication.2. After you run sp_removedbreplication, you may run the followingscript in your restored database. This script will generate the dropcommands for repl]]></description><category></category></item><item><title><![CDATA[用DTS导入文本文件时， 怎样跳过文本文件的第一行和最后一行]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/190476</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/190476</guid><author>zhanli</author><pubDate>Mon, 22 Nov 2004 11:35:00 +0800</pubDate><description><![CDATA[Suppose we have a table as follows:CREATE TABLE [ignore_rows] ( [c1] [int] NULL , [c2] [char] (10) )And the text file is as follows:1,aaa2,bbb3,ccc100,dddTo ignore the first and the last row o]]></description><category></category></item><item><title><![CDATA[怎样查询磁盘的可用空间，数据库数据文件及日志文件大小及利用率]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/190433</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/190433</guid><author>zhanli</author><pubDate>Mon, 22 Nov 2004 11:13:00 +0800</pubDate><description><![CDATA[1. To check the available disk space, you may use the undocumented system extended stored procedure xp_fixeddrives,  which can return the available free space (MB) for each fixed drive. You can run it]]></description><category></category></item><item><title><![CDATA[怎样把login从一个SQL Server 2000实例导入到另一个实例]]></title><link>https://blog.youkuaiyun.com/zhanli/article/details/128399</link><guid>https://blog.youkuaiyun.com/zhanli/article/details/128399</guid><author>zhanli</author><pubDate>Fri, 08 Oct 2004 18:14:00 +0800</pubDate><description><![CDATA[1. 使用T-SQL你可以先在源SQL Server上运行下面的脚本，该脚本会生成可以执行的T-SQL语句；然后您把这些生成的T-SQL语句在目的服务器上执行就可以了:SET NOCOUNT ONSELECT EXEC sp_addlogin @loginame =  + loginname + ,, @defdb =  + dbname + ,, @defl]]></description><category></category></item></channel></rss>