ChuckLu - 博客园

2022年6月20日

摘要： 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 阅读(265) 评论(0) 推荐(0)

SQL Server - Management Studio - Client Statistics - Wait time on server replies vs Client processing time

摘要： 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 阅读(80) 评论(0) 推荐(0)

How Client Statistics helps in improving performance in SQL Server

摘要： 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 阅读(58) 评论(0) 推荐(0)

Columnstore indexes: Overview

摘要： 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 阅读(68) 评论(0) 推荐(0)

Running SUM across large amount of rows

摘要： 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 阅读(45) 评论(0) 推荐(0)

到底如何通过看美剧来提高英语听力和口语？

摘要：到底如何通过看美剧来提高英语听力和口语？下面我们就从科学出发，不谈个人经验，真正分析一下口语能力的培养所需要经历的步骤和每一步所需要攻克的问题，还有具体的解决方案：一听力能力障碍首先我们来看看上面这张图，稍微有点物理学常识的人都知道，这是著名的「虹吸现象」，即想要让左侧杯中的液体通过一根导管阅读全文

posted @ 2022-06-20 00:48 ChuckLu 阅读(715) 评论(0) 推荐(0)

2022年6月17日

Get top 1 row of each group

摘要： 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 阅读(50) 评论(0) 推荐(0)

Top 3 Tips You Need to Know to Write Faster SQL Views

摘要： 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 阅读(52) 评论(0) 推荐(0)

2022年6月16日

forms authentication自己实现impersonate的要点中转

摘要： Admin站点，impersonate到用户站点。需要在用户站点添加一个LoginAsUser的页面，然后在页面里面读取identiyname，这个一般用户userid。然后设置Application variable里面对应的user id的login status为true。这样可以避开和r 阅读全文

posted @ 2022-06-16 20:34 ChuckLu 阅读(31) 评论(0) 推荐(0)

2022年6月14日

CREATE STATISTICS (Transact-SQL)

摘要： CREATE STATISTICS (Transact-SQL) Creates query optimization statistics on one or more columns of a table, an indexed view, or an external table. For m 阅读全文

posted @ 2022-06-14 15:34 ChuckLu 阅读(67) 评论(0) 推荐(0)

Chuck Lu

公告