<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Glows_hui的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Glows_hui</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Glows_hui]]></copyright><item><title><![CDATA[sql server isnull 真是个坑，CPU飙升90% +]]></title><link>https://blog.youkuaiyun.com/Glows_hui/article/details/122128527</link><guid>https://blog.youkuaiyun.com/Glows_hui/article/details/122128527</guid><author>Glows_hui</author><pubDate>Fri, 24 Dec 2021 15:10:49 +0800</pubDate><description><![CDATA[table1大概1100多万数据

table2大概80多万数据

MES系统，使用了以下SQL语句，并且这个语句每分钟终端会并发执行一次(大概30个客户端)

SELECT
 AA.id
FROM
 table1 aa
 LEFT JOIN table2bb ON bb.No= aa.No
WHERE

--就下面这句，把服务器CPU干到90%多
 isnull( aa.fanCode,'0')!='0'
 

修改为 :aa.fanCode IS NOT NULL ...]]></description><category></category></item><item><title><![CDATA[帆软 在线Cron表达式]]></title><link>https://blog.youkuaiyun.com/Glows_hui/article/details/121652054</link><guid>https://blog.youkuaiyun.com/Glows_hui/article/details/121652054</guid><author>Glows_hui</author><pubDate>Wed, 01 Dec 2021 11:41:56 +0800</pubDate><description><![CDATA[在线Cron表达式生成器 (pppet.net)

在线Cron表达式生成器 (pppet.net)https://www.pppet.net/
]]></description><category></category></item><item><title><![CDATA[SQL SERVER 已有分区，新加分区步骤]]></title><link>https://blog.youkuaiyun.com/Glows_hui/article/details/121495609</link><guid>https://blog.youkuaiyun.com/Glows_hui/article/details/121495609</guid><author>Glows_hui</author><pubDate>Tue, 23 Nov 2021 16:06:46 +0800</pubDate><description><![CDATA[SQL SERVER 已有分区，新加分区步骤]]></description><category></category></item><item><title><![CDATA[C#、VS2012 Winform程序解决方案名称更改后报错“调试器无法继续运行该进程。调用的目标发生了异常。”]]></title><link>https://blog.youkuaiyun.com/Glows_hui/article/details/78625960</link><guid>https://blog.youkuaiyun.com/Glows_hui/article/details/78625960</guid><author>Glows_hui</author><pubDate>Fri, 24 Nov 2017 16:30:49 +0800</pubDate><description><![CDATA[C#、VS2012 Winform程序解决方案名称更改后报错“调试器无法继续运行该进程。调用的目标发生了异常。”如果解决方案名称需要更改,可以参考http://blog.youkuaiyun.com/puppet_master/article/details/48212037修改解决方案名称的补充：在解决方案右键-属性。打开下面窗口，命名空间等也要修改以上都修改完毕后，启动调试报如下错误：解决方法1：在VS上的]]></description><category></category></item></channel></rss>