Need sample DELETE Query where SQL Server by default takes PAGELOCK instead of ROWLOCK
10500
Sample query/DDL for producing page locks on a clustered index in SQL Server (without hints)
10642
SQL Server - what isolation level for non-blocking select statements?
58915
How can I abort a running JDBC transaction?
18879
How to set a default row for a query that returns no rows?
119655
How can I do a BEFORE UPDATED trigger with sql server?
113049
How to delete duplicate rows in SQL Server 2008?
29356
Can anybody explain the UNABLE_TO_LOCK_ROW error?
76121
Troubleshooting memory pressure - how to avoid paging out SQL Server?
133977
Alter CONSTRAINT or stored procedure only to check when insert not on update
118632
How to set identity_insert to on in SQL Server
138611
Stop SQL Server from ordering results?
105593
SQL Server detected a logical consistency-based I/O error: incorrect pageid on RESTORE
124718
Cancelling an Entity Framework Query
19053
SQL query: Delete all records from the table except latest N?
11116
What's the difference between TRUNCATE and DELETE in SQL
98961
Delete duplicate records in SQL Server?
137980
How can I truncate a datetime in SQL Server?