[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

Does uploading a 1MB file into SQL 2005 locks the table?

Does uploading a 1MB file into SQL 2005 locks the table and block others from uploading to the same table? Does it block queries against that table?
  • 2
1 Solution
Daniel WilsonCommented:
It should not block other inserts.  Now if your upload is more complicated & does some comparison to what's already there, the could block.

Depending on the criteria your SELECT uses, it could block while you insert the data.
mattphungAuthor Commented:
So for example, if I'm uploading an email attachment and another user logs into the email system and trys to download an attachment from the same table by using this statement:

Select * from Attachment (nolock) where AttachmentId = @Id

Does the statement above execute without waiting for the upload to complete? Thanks
Daniel WilsonCommented:
Someone may correct me on this, but I believe you are fine with that WHERE clause UNLESS @ID is the ID of the new record.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now