• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • 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?
0
mattphung
Asked:
mattphung
  • 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.
0
 
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
0
 
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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