2008AUG291238
"... does this article say that an Update statement is blocking selects? Does SQL Server really work like this? ..."
I don't know.
One thing I do know is in the places I've seen SQLServer used this wasn't a problem. In StackOverflow #17~ itc.conversationsnetwork.org/shows/detail3792.html Atwood mentions using LINQ a lot, instead of raw SQL or code they have written. I'm wary of generated code from MS tools. I wonder if this might be the problem? You can read the transcript here. The podcast is pretty good. Spolsky the Morcombe to Atwoods, Wise ~ en.wikipedia.org/wiki/Morecambe_and_Wise
"... I'm guessing that MySQL, which grew up on web apps, is much less pessimistic out of the box than SQL Server ..."
That one sums it all up. But does it summarise the problem? SQLServer works well enough out of the box.
next >>>
2008AUG291238
"... does this article say that an Update statement is blocking selects? Does SQL Server really work like this? ..."
I don't know.
One thing I do know is in the places I've seen SQLServer used this wasn't a problem. In StackOverflow #17~ itc.conversationsnetwork.org/shows/detail3792.html Atwood mentions using LINQ a lot, instead of raw SQL or code they have written. I'm wary of generated code from MS tools. I wonder if this might be the problem? You can read the transcript here. The podcast is pretty good. Spolsky the Morcombe to Atwoods, Wise ~ en.wikipedia.org/wiki/Morecambe_and_Wise
"... I'm guessing that MySQL, which grew up on web apps, is much less pessimistic out of the box than SQL Server ..."
That one sums it all up. But does it summarise the problem? SQLServer works well enough out of the box.
next >>>