摘要:
RabbitMQ内存爆出问题:The management statistics database currently has a queue of xx events to process. If this number keeps increasing, so will the memory used by the management plugin. You may find it useful to set the rates_mode config item to none. 阅读全文
摘要:
SQL server特殊用法笔记:递归,CTE,Merge,Output,XML解析,Cross Apply,STUFF.... 阅读全文
摘要:
mysql笔记一——安装和设置root密码 阅读全文
摘要:
centos7环境安装rabbitMQ 阅读全文
摘要:
"指定的架构无效。错误:
CLR 类型到 EDM 类型的映射不明确,因为多个 CLR 类型与 EDM 类型“Person”匹配。
以前找到的是 CLR 类型“A.Person”,
新找到的则是 CLR 类型“B.Person”。 阅读全文
摘要:
There are times when I find myself needing to run a SQL command against each database on one of my SQL Server instances. There is a handy undocumented stored procedure that allows you to do this without needing to set up a cursor against your sysdatabases table in the master database: sp_MSforeachdb. 阅读全文
摘要:
sp_getapplock 阅读全文
摘要:
转自:http://blog.sqlauthority.com/2010/05/14/sql-server-find-most-expensive-queries-using-dmv/ The title of this post is what I can express here for thi 阅读全文
摘要:
TransactionScope的回滚测试。回滚效果,同步SQL里面的操作回滚了,但内存中的object并未回滚,异步的SQL里面也未回滚. 阅读全文
摘要:
在config里面配置Section 阅读全文
摘要:
原文:https://msdn.microsoft.com/en-us/data/jj691402.aspx 阅读全文
摘要:
LINQ To SQL 语法及实例大全 阅读全文