السلام عليكم ورحمته الله وبركاته
هو لما استخدام الخاصية دى allow_row_locks دى معناها انه هيقفل التعامل مع الrow دا ولا ايه سواء كان اضافه او حذف او استعلام ودا فى ايه حالة حالة انشاءة ولا على طول بعد الانشاء
وشكرا
السلام عليكم ورحمته الله وبركاته
هو لما استخدام الخاصية دى allow_row_locks دى معناها انه هيقفل التعامل مع الrow دا ولا ايه سواء كان اضافه او حذف او استعلام ودا فى ايه حالة حالة انشاءة ولا على طول بعد الانشاء
وشكرا
It means that the database engine could lock the row when doing some operations on the index that require either modifying the indexes (i.e. adding data to the table) or the or one of the dimensions that the query plans are refreshed on
In the past, it was always a table lock, now there's an ability of having row lock
The question of whether my row will be locked or not, is based on the operation you're performing.
Mohamed Meshref
Software Design Engineer
SQL Server Team
Microsoft Corporation, Redmond HQ
Phone: +1-(425)704-8684
Mobile: +1-(425)445-7386