05 2021 档案

摘要:Changing SQL Server Collation After Installation We can now redefine the desired collation for database Products with the following code: -- make sure 阅读全文
posted @ 2021-05-31 18:03 ChuckLu 阅读(40) 评论(0) 推荐(0) 编辑
摘要:High CPU Usage SQL Server (One Bad Query) My colleague reported to me that one of our database server is reporting consistent high CPU usage so I look 阅读全文
posted @ 2021-05-31 13:58 ChuckLu 阅读(62) 评论(0) 推荐(0) 编辑
摘要:What “Clustered Index Scan (Clustered)” means on SQL Server execution plan? I would appreciate any explanations to "Clustered Index Scan (Clustered)" 阅读全文
posted @ 2021-05-31 13:31 ChuckLu 阅读(94) 评论(0) 推荐(0) 编辑
摘要:Execution Plans in SQL Server Introduction In this article, I’m going to explain what the Execution Plans in SQL Server are and how to understand the 阅读全文
posted @ 2021-05-28 18:30 ChuckLu 阅读(87) 评论(0) 推荐(0) 编辑
摘要:Difference between Seek Predicate and Predicate Let's throw one million rows into a temp table along with a few columns: CREATE TABLE #174860 ( PK INT 阅读全文
posted @ 2021-05-28 18:07 ChuckLu 阅读(100) 评论(0) 推荐(0) 编辑
摘要:Query tuning 101: What’s a probe residual? Query tuning is an important process that will probably never go away and sharpening your tuning skills is 阅读全文
posted @ 2021-05-28 17:33 ChuckLu 阅读(67) 评论(0) 推荐(0) 编辑
摘要:Index Key Column VS Index Included Column Can someone explain this two - Index Key Column VS Index Included Column? Currently, I have an index that ha 阅读全文
posted @ 2021-05-28 17:20 ChuckLu 阅读(105) 评论(0) 推荐(0) 编辑
摘要:Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it? The most common two types of operators that consume mem 阅读全文
posted @ 2021-05-28 15:45 ChuckLu 阅读(86) 评论(0) 推荐(0) 编辑
摘要:https://www.apexsql.com/Download.aspx Other ApexSQL Plan Open, view, analyze and explore an execution plan in SQL Server, profile SQL code and more Re 阅读全文
posted @ 2021-05-28 14:00 ChuckLu 阅读(165) 评论(0) 推荐(0) 编辑
摘要:The SQL Server Query Optimizer To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query opti 阅读全文
posted @ 2021-05-28 13:56 ChuckLu 阅读(56) 评论(0) 推荐(0) 编辑
摘要:Table of contents SQL Server Execution Plans Overview SQL Server Execution Plans Types How to Analyze SQL Execution Plan Graphical Components SQL Serv 阅读全文
posted @ 2021-05-28 13:54 ChuckLu 阅读(45) 评论(0) 推荐(0) 编辑
摘要:https://en.wikipedia.org/wiki/Sargable In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can ta 阅读全文
posted @ 2021-05-28 13:26 ChuckLu 阅读(109) 评论(0) 推荐(0) 编辑
摘要:Working with covering indexes As you could read in the indexing basics article, a well-defined index can boost query performance, but there are a few 阅读全文
posted @ 2021-05-28 13:23 ChuckLu 阅读(49) 评论(0) 推荐(0) 编辑
摘要:How to group by month from Date field using sql 问题 How can I group only by month from a date field (and not group by day)? Here is what my date field 阅读全文
posted @ 2021-05-28 11:18 ChuckLu 阅读(58) 评论(0) 推荐(0) 编辑
摘要:Improve SQL performance – find your missing indexes Missing indexes are one reason why an SQL query takes longer (much longer) to complete. Here's how 阅读全文
posted @ 2021-05-28 10:55 ChuckLu 阅读(66) 评论(0) 推荐(0) 编辑
摘要:Why is this NuGet dependency missing when compiling .NET Framework project depending on .NET Standard? I have a Visual Studio solution, with 3 project 阅读全文
posted @ 2021-05-27 13:31 ChuckLu 阅读(87) 评论(0) 推荐(0) 编辑
摘要:What is NuGetPackageImportStamp for? NuGetPackageImportStamp is a workaround for Visual Studio 2013 and later versions not being able to detect that a 阅读全文
posted @ 2021-05-26 15:18 ChuckLu 阅读(200) 评论(0) 推荐(0) 编辑
摘要:https://docs.specflow.org/projects/getting-started/en/latest/GettingStarted/Step1.html https://docs.specflow.org/projects/getting-started/en/latest/Ge 阅读全文
posted @ 2021-05-25 18:05 ChuckLu 阅读(85) 评论(0) 推荐(0) 编辑
摘要:https://cucumber.io/docs/guides/overview/ Cucumber is a tool that supports Behaviour-Driven Development(BDD). If you’re new to Behaviour-Driven Develo 阅读全文
posted @ 2021-05-25 17:58 ChuckLu 阅读(58) 评论(0) 推荐(0) 编辑
摘要:https://cucumber.io/docs/bdd/ Behaviour-Driven Development (BDD) is the software development process that Cucumber was built to support. There’s much 阅读全文
posted @ 2021-05-25 17:53 ChuckLu 阅读(49) 评论(0) 推荐(0) 编辑
摘要:Import or export text (.txt or .csv) files Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 There are two ways to import 阅读全文
posted @ 2021-05-25 13:47 ChuckLu 阅读(470) 评论(0) 推荐(0) 编辑
摘要:How can I detect the encoding/codepage of a text file You can't detect the codepage, you need to be told it. You can analyse the bytes and guess it, b 阅读全文
posted @ 2021-05-25 13:37 ChuckLu 阅读(69) 评论(0) 推荐(0) 编辑
摘要:https://baijiahao.baidu.com/s?id=1669933570082526346 重新开一把。22找232抽娜迦,也直接锤爆对面。这里只能说终极随从和恶魔猎手随从真的强。 开局找虚无行者 然后找2/3/2 BT_321虚无行者(Netherwalker)Netherwalke 阅读全文
posted @ 2021-05-22 12:39 ChuckLu 阅读(183) 评论(0) 推荐(0) 编辑
摘要:// NPOI.SS.UserModel.IWorkbook// Token: 0x0600056E RID: 1390void Write(Stream stream); // NPOI.HSSF.UserModel.HSSFWorkbook // Token: 0x06001EB2 RID: 7 阅读全文
posted @ 2021-05-21 15:58 ChuckLu 阅读(447) 评论(0) 推荐(0) 编辑
摘要:https://en.wikipedia.org/wiki/List_of_Unicode_characters 选取一个特殊字符 U+015E Ş 350 Ş Latin Capital Letter S with cedilla 0286 然后尝试处理 [Test] public 阅读全文
posted @ 2021-05-21 13:27 ChuckLu 阅读(377) 评论(0) 推荐(0) 编辑
摘要:字符编码详解 版本:v2.3.1 Crifan Li 摘要 本文主要介绍了字符编码的基础知识,以及常见的字符编码类型,比如ASCII,Unicode,UTF-8,ISO 8859等,以及各种编码之间的关系,同时专门解释了中文字符相关的编码标准,包括GB2312,GBK,GB18030,也专门解释了W 阅读全文
posted @ 2021-05-21 12:48 ChuckLu 阅读(1118) 评论(0) 推荐(0) 编辑
摘要:Unicode To UTF8 及编码过程实时解析 这也是一个资源链接 u'囧'.encode('gb2312') throws UnicodeEncodeError 在这个页面进行查询,https://www.qqxiuzi.cn/bianma/zifuji.php 字符集编码是指对多个字符(通常 阅读全文
posted @ 2021-05-21 12:30 ChuckLu 阅读(129) 评论(0) 推荐(0) 编辑
摘要:Unicode 和 UTF-8 有什么区别? 作者:uuspider链接:https://www.zhihu.com/question/23374078/answer/65352538来源:知乎著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。 举一个例子:It's 知乎日报 你看 阅读全文
posted @ 2021-05-21 12:08 ChuckLu 阅读(174) 评论(0) 推荐(0) 编辑
摘要:“Unable to find an entry point named [function] in dll” (c++ to c# type conversion) First make sure the function is actually exported: In the Visual S 阅读全文
posted @ 2021-05-20 11:32 ChuckLu 阅读(469) 评论(0) 推荐(0) 编辑
摘要:Comparison with Other Frameworks Knockout Knockout was a pioneer in the MVVM and dependency tracking spaces and its reactivity system is very similar 阅读全文
posted @ 2021-05-20 11:29 ChuckLu 阅读(41) 评论(0) 推荐(0) 编辑
摘要:Keras: the Python deep learning API 阅读全文
posted @ 2021-05-20 09:50 ChuckLu 阅读(46) 评论(0) 推荐(0) 编辑
摘要:Matrices and Vectors https://numerics.mathdotnet.com/Matrix.html // Copy of an existing matrix (can also be sparse or diagonal) Matrix<double> x = ... 阅读全文
posted @ 2021-05-18 18:58 ChuckLu 阅读(111) 评论(0) 推荐(0) 编辑
摘要:SQL Server Profiler - Why are some calls RPC:Completed and Some Calls SQL:BatchCompleted BatchCompleted means TSQL code (e.g. selects) have completed. 阅读全文
posted @ 2021-05-18 14:32 ChuckLu 阅读(91) 评论(0) 推荐(0) 编辑
摘要:### Druid# 职业:德鲁伊# 模式:狂野模式## 2x (1) 自然研习# 2x (1) 生物计划# 1x (1) 感知宝珠# 2x (1) 小型法术玉石# 1x (3) 凶猛咆哮# 1x (4) 过度生长# 2x (4) 橡树的召唤# 2x (4) 横扫# 1x (4) 大法师瓦格斯# 2 阅读全文
posted @ 2021-05-15 16:43 ChuckLu 阅读(314) 评论(0) 推荐(0) 编辑
摘要:Appveyor: FIND: Parameter format not correct directory需要双引号 阅读全文
posted @ 2021-05-14 20:44 ChuckLu 阅读(163) 评论(0) 推荐(0) 编辑
摘要:Creating an archive from a directory without the directory name being added to the archive From the 7-Zip Help file: a (Add) command Adds files to arc 阅读全文
posted @ 2021-05-14 20:41 ChuckLu 阅读(71) 评论(0) 推荐(0) 编辑
摘要:Overview of the M&A Process 反垄断学习的补充知识 The mergers and acquisitions (M&A) process has many steps and can often take anywhere from 6 months to several 阅读全文
posted @ 2021-05-13 17:31 ChuckLu 阅读(89) 评论(0) 推荐(0) 编辑
摘要:Make sure base method gets called in C# Can I somehow force a derived class to always call the overridden methods base? public class BaseClass { publi 阅读全文
posted @ 2021-05-12 16:40 ChuckLu 阅读(60) 评论(0) 推荐(0) 编辑
摘要:How to delete specific nodes from an XElement? You can try this approach: var nodes = xRelation.Elements().Where(x => x.Element("Conditions") != null) 阅读全文
posted @ 2021-05-11 19:01 ChuckLu 阅读(53) 评论(0) 推荐(0) 编辑
摘要:如何学习数据结构? 作者:孟蛋蛋链接:https://www.zhihu.com/question/21318658/answer/42690576来源:知乎著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。 前言 2015年03月第一次编写这个答案,之后于2016年01月和201 阅读全文
posted @ 2021-05-11 01:38 ChuckLu 阅读(662) 评论(0) 推荐(0) 编辑
摘要:3.2.1 Toy problemsThe first example we examine is the vacuum world first introduced in Chapter 2. (SeeFigure 2.2.) This can be formulated as a problem 阅读全文
posted @ 2021-05-11 01:22 ChuckLu 阅读(237) 评论(0) 推荐(0) 编辑
摘要:CS 3600 Intro to Artificial Intelligence — Spring 2020 Course description CS 3600 - Introduction to Artificial Intelligence is a 3-credit introductory 阅读全文
posted @ 2021-05-11 00:57 ChuckLu 阅读(138) 评论(0) 推荐(0) 编辑
摘要:CS 3600 – Introduction to Intelligent Systems https://www.cc.gatech.edu/~riedl/classes/2014/cs3600/homeworks/missionaries.pdf 题目 https://www.cc.gatech 阅读全文
posted @ 2021-05-11 00:36 ChuckLu 阅读(54) 评论(0) 推荐(0) 编辑
摘要:https://github.com/Kevin-QAQ/IntelligentSearch/tree/master/MCproblem https://github.com/marianafranco/missionaries-and-cannibals AI Search to Solve th 阅读全文
posted @ 2021-05-10 19:08 ChuckLu 阅读(432) 评论(0) 推荐(0) 编辑
摘要:River crossing puzzle A river crossing puzzle is a type of puzzle in which the object is to carry items from one river bank to another, usually in the 阅读全文
posted @ 2021-05-10 18:46 ChuckLu 阅读(109) 评论(0) 推荐(0) 编辑
摘要:Part 1/4 – Rogue Your deck needs to contain Bamboozle, Plagiarize, Yoink!, Coerce and Potion of Illusion. Since they cost 12 mana in total, once you g 阅读全文
posted @ 2021-05-09 15:28 ChuckLu 阅读(161) 评论(0) 推荐(0) 编辑
摘要:塔维什·雷矛:“快,宝贝儿!敌人数量太多了!到处都是蛇!它们看起来是有点萌,但那毕竟是凶猛的 蛇!”,分别暗示快速射击、数量压制、毒蛇陷阱、萌物来袭、凶猛狂暴这五张卡牌 Part 4/4 – Hunter Once again, start the match against Innkeeper w 阅读全文
posted @ 2021-05-09 15:16 ChuckLu 阅读(253) 评论(0) 推荐(0) 编辑
摘要:中文版本 /// <summary> /// https://zhuanlan.zhihu.com/p/370273345 /// </summary> public static string ChineseSolution = @"左转 直行 直行 右转 直行 直行右转 直行 左转 直行 左转 阅读全文
posted @ 2021-05-08 22:27 ChuckLu 阅读(181) 评论(0) 推荐(0) 编辑
摘要:Dijkstra最短路径算法 首先描述一下问题:给定一个有向图G和源点v,求v0到G中某个顶点u的最短路径。限定各边上的权值大于或等于0。 算法的基本思想很简单:所有的顶点,按照它到源点v的距离,客观上存在一个从小到大的顺序,我们只要按照这个顺序找下去,总有一步会找到目标顶点u,而此时的距离就是u到 阅读全文
posted @ 2021-05-08 14:56 ChuckLu 阅读(3154) 评论(0) 推荐(0) 编辑
摘要:LeetCode 到底怎么刷?GitHub 上多位大厂程序员亲测的高效刷题方式 https://github.com/halfrost/LeetCode-Go LeetCode Cookbook 是 @halfrost 去年刷的 LeetCode 整理出的 520 题,每道题都写了解题思路,全部都是 阅读全文
posted @ 2021-05-08 00:33 ChuckLu 阅读(163) 评论(0) 推荐(0) 编辑
摘要:How do I run a Python script from C#? The reason it isn't working is because you have UseShellExecute = false. If you don't use the shell, you will ha 阅读全文
posted @ 2021-05-08 00:25 ChuckLu 阅读(70) 评论(0) 推荐(0) 编辑
摘要:What is a good network graph library for language X? I have noticed that a recurring question is: “What is a good network graph library for language X 阅读全文
posted @ 2021-05-08 00:06 ChuckLu 阅读(107) 评论(0) 推荐(0) 编辑
摘要:http://staff.ustc.edu.cn/~rui/courses/mm.html http://staff.ustc.edu.cn/~rui/ppt/modeling/ppt.html http://staff.ustc.edu.cn/~rui/ppt/modeling/modeling_ 阅读全文
posted @ 2021-05-07 23:38 ChuckLu 阅读(165) 评论(0) 推荐(0) 编辑
摘要:微分方程模型 概率建模 统计回归模型 http://staff.ustc.edu.cn/~rui/ppt/modeling/modeling_5.html#/7 阅读全文
posted @ 2021-05-07 23:24 ChuckLu 阅读(51) 评论(0) 推荐(0) 编辑
摘要:用图论解决 核心问题是,如何构造出图,转换成数据结构 https://math.stackexchange.com/questions/344158/wolves-and-chicks-puzzle (Too long for a remark.) By the way, one can visua 阅读全文
posted @ 2021-05-07 21:53 ChuckLu 阅读(3067) 评论(0) 推荐(0) 编辑
摘要:NEW SECRET “???” ACHIEVEMENT AND CARD BACK FROM BARRENS – MYSTERIES OF THE PHOENIX – FULL SOLUTION INSIDE! The last patch added one new thing that was 阅读全文
posted @ 2021-05-07 20:57 ChuckLu 阅读(101) 评论(0) 推荐(0) 编辑
摘要:成就系统 生涯,游戏,收藏,冒险,其他 在游戏里面,有一个贫瘠之地的成就。 InnKeeper 客栈老板; (乡村)酒铺掌柜; Note: If you cannot join a game against the Innkeeper it is because the servers are fu 阅读全文
posted @ 2021-05-07 13:13 ChuckLu 阅读(104) 评论(0) 推荐(0) 编辑
摘要:.Money laundering, means helping to unlawfully justify the origin of goods or revenues from the author of a crime (bank robbery for example) ormisdeme 阅读全文
posted @ 2021-05-05 23:45 ChuckLu 阅读(2005) 评论(0) 推荐(0) 编辑
摘要:What is the difference between ManualResetEvent and AutoResetEvent in .NET? I have read the documentation on this and I think I understand. An AutoRes 阅读全文
posted @ 2021-05-02 04:05 ChuckLu 阅读(46) 评论(0) 推荐(0) 编辑
摘要:### Mage# 职业:法师# 模式:狂野模式## 2x (1) 暗金教侍从# 2x (2) 麦迪文的男仆# 2x (2) 远古谜团# 2x (2) 秘法学家# 2x (2) 疯狂的科学家# 2x (2) 对空奥术法师# 2x (3) 非公平游戏# 2x (3) 肯瑞托法师# 2x (3) 爆炸符 阅读全文
posted @ 2021-05-01 13:01 ChuckLu 阅读(161) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示