SSRS is a wonderful tool for quickly retrieving data and presenting it to the user in a format predefined at design-time. But what if there is a need to create a new report at run-time, based on some dynamic data structure or any specific user needs? Of course, for advanced business users Microsoft Report Builder […]
Continue reading…
SQL Server
How to exclusively lock a table in MS SQL
Start a transaction and select from the table using the (TABLOCKX) hint. As the result, read from this table outside of the transaction will be queued until the transaction is committed or rolled back. 1 2 3 4 5 6 7 8 BEGIN TRAN SELECT * FROM Table1 (TABLOCKX) […]
Continue reading…