I am new to SQL Server and am not sure about how the locking mechanism works here. Please help
Issue: Need to delete close to 5 mil records in a table. A website pulls data from that table quite frequently.
My understanding is: delete would lock only the row hence this shouldn't affect the website. Is that right? Then, what would happen if the website is trying to pull the record that is being deleted? I know I sound very amateurish but I badly need to understand these basics.
Could one of the gurus please share a link where I can read up about the various kinds of locks in SQL Server as well