Researcher

摘要： In some case, we found that when we execute the sql commands like truncate table, drop table, delete all records in table, join 2 tables, it will take 阅读全文

posted @ 2016-12-10 00:10 Researcher 阅读(138) 评论(0) 推荐(0)

2016年12月8日

How to get the mapping relationship between two columns in a table

摘要： If a table have column A and B Count(distinct A) as Da Count(distinct B) as Db Count(distinct A, B) as Dab The Da/Db<=Dab, this will be always true; 1 阅读全文

posted @ 2016-12-08 18:43 Researcher 阅读(118) 评论(0) 推荐(0)

2016年12月1日

Use Select To Generate Any Insert/Delete/Update Statement

摘要： If you don't have the permission to generate script according to an existing db, but you have the read permission for that db, if so you can use selec 阅读全文

posted @ 2016-12-01 16:02 Researcher 阅读(109) 评论(0) 推荐(0)

2016年10月21日

用Redis作为缓存服务器，加快数据库操作速度

摘要： https://zh.wikipedia.org/wiki/Redis http://www.jianshu.com/p/01b37cdb3f33 阅读全文

posted @ 2016-10-21 10:47 Researcher 阅读(798) 评论(0) 推荐(0)

2016年9月29日

Yield Usage Understanding

摘要： When would I use Task.Yield()? http://stackoverflow.com/questions/22645024/when-would-i-use-task-yield In order to have a better understanding for abo 阅读全文

posted @ 2016-09-29 12:49 Researcher 阅读(79) 评论(0) 推荐(0)

公告