[SQL ]Nolock對DB的影響
資料庫名稱:Ms Sql
資料庫版本:2012
內容/問題描述:
在之前的公司,資料庫一天到晚都Lock,所以學會用Nolock來避免Lock,
但剛剛,前同事看到我的寫法說:這寫法會對DB的Insert與Update有影響。
就我所知,會有Dirty Data的問題,除此之外還會有哪些問題呢?
請各位高手解惑
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.234.46.112
※ 文章網址: http://www.ptt.cc/bbs/Database/M.1412002919.A.3FE.html
推
09/29 23:10, , 1F
09/29 23:10, 1F
→
09/29 23:16, , 2F
09/29 23:16, 2F
→
09/29 23:16, , 3F
09/29 23:16, 3F
→
09/29 23:19, , 4F
09/29 23:19, 4F
→
09/29 23:24, , 5F
09/29 23:24, 5F
→
09/29 23:24, , 6F
09/29 23:24, 6F
→
09/29 23:24, , 7F
09/29 23:24, 7F
→
09/29 23:25, , 8F
09/29 23:25, 8F
→
09/29 23:25, , 9F
09/29 23:25, 9F
→
09/29 23:25, , 10F
09/29 23:25, 10F
→
09/29 23:26, , 11F
09/29 23:26, 11F
→
09/29 23:39, , 12F
09/29 23:39, 12F
→
09/29 23:39, , 13F
09/29 23:39, 13F
→
09/29 23:40, , 14F
09/29 23:40, 14F