摘要: CAST and CONVERT have similar functionality. CONVERT is specific to SQL Server, and allows for a greater breadth of flexibility when converting betwee 阅读全文
posted @ 2016-01-28 14:43 腻害的小笼包 阅读(114) 评论(0) 推荐(0) 编辑
摘要: Slow in the Application, Fast in SSMS?Understanding Performance Mysteries An SQL text by Erland Sommarskog, SQL Server MVP. Last revision: 2013-08-30. 阅读全文
posted @ 2016-01-22 17:35 腻害的小笼包 阅读(269) 评论(0) 推荐(0) 编辑
摘要: DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE select arithabort from SYS.DM_EXEC_REQUESTS where session_id = *** 阅读全文
posted @ 2016-01-22 17:30 腻害的小笼包 阅读(93) 评论(0) 推荐(0) 编辑
摘要: 以下是MSDN Magazine 里面的一段文章:http://msdn.microsoft.com/zh-cn/magazine/cc163523.aspx我很好奇这样到底能不能够注入SQL,所以我建了个 console 程序 static void Main(string[] ar... 阅读全文
posted @ 2014-05-09 14:25 腻害的小笼包 阅读(130) 评论(0) 推荐(0) 编辑