Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2008-02-19 : 10:47:00
|
| Hi,From what I understand, any update done to a table row is actually deleting the row and then inserting?If there is a update (delete + insert) in process, will any SELECT statement be held up until the update is finished?For example, say on a website, whenever someone views a article, the application updates the page views count for that particle article in the tblArticles table. Now say at the same time, many visitors are viewing the 'latest articles' page. If there are updates going on at the same time, will this slow things down for SELECTS? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 23:30:26
|
| Not really, depends on several factors. Kalen Delaney had article about this on sql server magazine. |
 |
|
|
|
|
|
UPDATE command, is a delete + insert? Locking?