table lock 中文意思是什麼

table lock 解釋
表鎖
  • table : n 1 桌子；飯桌，餐臺。2 手術臺；工作臺；游戲臺；賭臺；寫字臺。3 （飯桌上的）食物，酒菜，伙食；一...
  • lock : n 1 鎖，閂，栓。2 （運河等的）船閘。3 制輪楔。4 【機械工程】氣閘，氣塞，鎖氣室。5 【軍事】槍機。6...
  1. During the time that it is held, the sch - m lock prevents concurrent access to the table

    保持該鎖期間， sch - m鎖將阻止對表進行並發訪問。
  2. Are escalated to an exclusive lock on the table, and all other lower - granularity locks, including intent locks, on

    上持有的所有鎖都將被升級到該表上的排他鎖，而
  3. For example, a shared intent lock is requested at the table level before shared locks are requested on pages or rows within that table

    例如，在該表的頁或行上請求共享鎖（ s鎖）之前，在表級請求共享意向鎖。
  4. Setting an intent lock at the table level prevents another transaction from subsequently acquiring an exclusive lock on the table containing that page

    在表級設置意向鎖可防止另一個事務隨后在包含那一頁的表上獲取排他鎖（ x鎖） 。
  5. For example, before a sql server database engine task applies shared or exclusive row locks within a table, it places an intent lock on the table

    其他用戶可以同時讀取數據，但在釋放所有共享鎖之前，任何事務都不能獲取對該數據的排他鎖。
  6. Rid lock on a single row in a table identified by a row identifier

    Rid =表中單個行的鎖，由行標識符（ rid ）標識。
  7. Table scans always read and lock all the rows in the table

    表掃描總是讀取（並上鎖）表中所有行。
  8. It must acquire a shared table lock

    運行dbcc checktable ，則必須獲取一個共享表鎖。
  9. This paper posts some new design methods 1 ) blurred simple code input method raise working efficiency 2 ) a standard method about the join of ado and database 3 ) open and lock table method for solving concurrency control about table. this research is only an initial investigation in prompting restaurant information management. but it can develop continuely with the growth of science

    針對中小型飯店管理中迫切需要解決的問題充分結合計算機管理系統的開發方法和計算機網路技術，實現了一種新的模糊簡碼的點菜輸入方式，提高了點菜的工作效率;為解決飯店中餐桌管理的並發性問題，提出了實時鎖開桌解決方法;為與后臺數據庫實現有效地快速連接，設計了ado與ini文件連接的有效方法。
  10. When the escalation occurs at the table level, no requests can be made for any lock lower than a table

    在表級別上升級時，不能請求低於表的鎖。
  11. Using tablock causes a table - level lock to be taken for the duration of the bulk operation and eliminates the overhead of locking individual rows

    使用tablock會導致在大容量操作期間進行表級鎖定，並消除按行鎖定的開銷。
  12. Lock escalation is the process of converting many fine - grain locks, such as a row, into fewer coarse - grain locks, such as a table

    鎖升級就是將大量較細粒度的鎖（例如行）轉換為少量較粗粒度的鎖（例如表） 。
  13. If the lock escalation attempt succeeds and the full table lock is acquired, then all heap or b - tree, page page, key - range, or row - level locks held by the transaction on the heap or index are released

    如果鎖升級嘗試成功並獲取全表鎖，將釋放事務在堆或索引上所持有的所有堆或b樹鎖、頁鎖（ page鎖） 、鍵范圍鎖（ key鎖）或行級鎖（ rid鎖） 。
  14. Similarly, lock escalation is not triggered if a statement has a self join on a table, and each reference to the table only acquires 3, 000 locks in the table

    同樣，如果語句中含有表的自聯接，並且表的每一個引用僅在表中獲取3 ， 000個鎖，則不會觸發鎖升級。
  15. After acquiring the stronger lock, all page - and row - level locks held by the transaction on the table are released

    得到更強的鎖后，事務在表上所持有的所有頁級及行級鎖都將予以釋放。
  16. Specifies that an exclusive lock is taken on the table

    指定表採用排他鎖。
  17. This will let you see what applications are connected to a database, help you diagnose lock problems, and allow you to view buffer pool, table space, and table usage, and statements being executed

    這樣您便可以看到是什麼應用程序正連接到數據庫，還可以診斷鎖問題，並允許查看緩沖池、表空間和表的使用情況，以及正在執行的語句。
  18. The following table shows the resource lock modes that the database engine uses

    下表顯示了數據庫引擎使用的資源鎖模式。
  19. Specifies that a bulk update table - level lock is acquired for the duration of the bulk load operation ; otherwise, a row - level lock is acquired

    指定在大容量加載操作期間獲取大容量更新表級別的鎖；否則，獲取行級別的鎖。
  20. This option only requires an intent - shared table lock

    用戶必須是表所有者，或者是
分享友人
分享到 Line

分享到臉書