Tuesday, June 17, 2014 3:26 PM
rusanu.com
SQL Server 2014 updateable columnstores Q and A
Are INSERTs serialized because of row group locks? No. If a trickle INSERT requires an OPEN row group and it cannot place a lock on it it will create a new one. any number of INSERT statements can proceed in parallel, each locking its own row group. While
Read More...