New answers tagged concurrency
3
votes
Accepted
I've TABLOCKed a table. How can I read it?
There are two possibilities:
1. Truncating inside a transaction
This applies if you are truncating the table then loading in batches within a transaction.
Truncating a table takes a schema ...
- 83k
1
vote
I've TABLOCKed a table. How can I read it?
There are two kinds of table locks. The DML table lock which is an X lock on the object, like if you added a TABLOCKX table hint, and the excusive schema lock SCH-M, that you get from altering ...
- 45.9k
0
votes
Accepted
Two queries to retrieve user profile and tweets, or join and get user data from first column?
Two queries to retrieve user profile and tweets, or join and get user data from first column?
Is it better to fetch them in two separate, possibly concurrent/parallel calls?
OR
make a one query, ...
- 35.1k
Top 50 recent answers are included