上一页 1 ··· 70 71 72 73 74 75 76 77 78 ··· 400 下一页
摘要: ASCII or UTF-8? 问题 Long long time ago before world scripts birth, text files are all ASCII.Nowadays, we have world scripts.I would like to ask if I op 阅读全文
posted @ 2022-06-20 18:59 ChuckLu 阅读(35) 评论(0) 推荐(0)
摘要: Msg 1939, Level 16, State 1, Line 19Cannot create index on view 'vw_Invoice_chuck_005' because the view is not schema bound. Msg 4512, Level 16, State 阅读全文
posted @ 2022-06-20 17:40 ChuckLu 阅读(253) 评论(0) 推荐(0)
摘要: SQL Server - Management Studio - Client Statistics - Wait time on server replies vs Client processing time 'Wait time on server replies' is the time b 阅读全文
posted @ 2022-06-20 16:19 ChuckLu 阅读(70) 评论(0) 推荐(0)
摘要: How Client Statistics helps in improving performance in SQL Server Time Statistics Value of ‘Client processing time’ is 20 which indicates the time sp 阅读全文
posted @ 2022-06-20 15:25 ChuckLu 阅读(40) 评论(0) 推荐(0)
摘要: Columnstore indexes: Overview Columnstore indexes are the standard for storing and querying large data warehousing fact tables. This index uses column 阅读全文
posted @ 2022-06-20 10:31 ChuckLu 阅读(52) 评论(0) 推荐(0)
摘要: Running SUM across large amount of rows 回答1 You can take a look to the column store in SQL Server. In short, you are able to create a column store ind 阅读全文
posted @ 2022-06-20 10:00 ChuckLu 阅读(27) 评论(0) 推荐(0)
摘要: 到底如何通过看美剧来提高英语听力和口语? 下面我们就从科学出发,不谈个人经验,真正分析一下口语能力的培养所需要经历的步骤和每一步所需要攻克的问题,还有具体的解决方案: 一 听力能力障碍 首先我们来看看上面这张图,稍微有点物理学常识的人都知道,这是著名的「虹吸现象」,即想要让左侧杯中的液体通过一根导管 阅读全文
posted @ 2022-06-20 00:48 ChuckLu 阅读(652) 评论(0) 推荐(0)
摘要: Get top 1 row of each group 回答1 ;WITH cte AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY DocumentID ORDER BY DateCreated DESC) AS rn FROM DocumentStat 阅读全文
posted @ 2022-06-17 14:15 ChuckLu 阅读(43) 评论(0) 推荐(0)
摘要: Top 3 Tips You Need to Know to Write Faster SQL Views Friend or foe? SQL Server views have been a subject of heated debates when I was in my first yea 阅读全文
posted @ 2022-06-17 12:53 ChuckLu 阅读(32) 评论(0) 推荐(0)
摘要: Admin站点,impersonate到用户站点。需要在用户站点添加一个LoginAsUser的页面,然后在页面里面读取identiyname,这个一般用户userid。 然后设置Application variable里面对应的user id的login status为true。 这样可以避开和r 阅读全文
posted @ 2022-06-16 20:34 ChuckLu 阅读(25) 评论(0) 推荐(0)
上一页 1 ··· 70 71 72 73 74 75 76 77 78 ··· 400 下一页