PDW - prevent table locking when Fast Appending records (allow selects) - by Dave_Le

Status : 


Sign in
to vote
ID 865034 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 5/1/2014 11:19:51 AM
Access Restriction Public


right now fast append lock the destination table and prevent reads from it, in a situation when PDW is being used as a critical DWH (as it should) and being loaded with data every 30 sec (for example) fast append prevent selects and by doing that the users can see the newly inserted data - unlike SMP sql where the table data is available all the time.
Sign in to post a comment.