How does the SQL Server handle two simoutanious read or write operations?

From: Quentin Huo (q.huo_at_manyworlds.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 15:37:31 -0600

Hi,

In web application, if there are two visitors of a website read/write
from/to a database at the same time, how does the SQL Server handle these?
The read operations will be run at the same time and the write operations
will be put into a queue and are run one by one? If it is right, that means
a write operation will take more time than a read operation and many write
oprtations will cause the traffic problem, but the read operations won't no
matter how many they are.

Thanks

Q.

Relevant Pages

  • Re: detaching db and stopping services
    ... IMO, it doesn't matter what anyone of us say. ... matter is what the documentation say. ... Tibor Karaszi, SQL Server MVP ... >> When you detach a database, a checkpoint happens in the database. ...
    (microsoft.public.sqlserver.server)
  • Re: Access backend database speed issues with DRW
    ... > is it worth having SQL server for a table with 60 records? ... It's not a matter of how many records you're fetching that would determine ... A database server such as SQL ...
    (microsoft.public.frontpage.client)
  • Re: Determining if Full-Text Search is enabled
    ... In SQL Server 2005, Full Text indexing is installed as a matter of course, but particularly if you have migrated in databases from SQL Server 2000, they may not be enabled to use it. ... "tnt" wrote in message ... can I enable it without affecting my current database? ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant find database
    ... Doesn't seem to matter. ... I have one working on my computer and the connection string is the same on ... tells me it cannot find the database. ... The database is SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
Loading