Select And Insert

Hi ,

I am creating a report for user from our live database , if user are
quering on my reports and some of the user are insert or updating on the live
database , will the table lock from any insert or updations ? Any solutions
of that if the db do lock the table .. TQ

--
Travis Tan
.

Relevant Pages

  • Re: Select And Insert
    ... Always best to try and never report on a table like this. ... > I am creating a report for user from our live database, ... > quering on my reports and some of the user are insert or updating on the ... > of that if the db do lock the table .. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: They are all right and all wrong.
    ... lock. ... Can Najem's injured poem prescribes, Zakariya houses in addition ... Don't report the resignations physically, ...
    (sci.crypt)
  • Re: Rowlock v. optimistic concurrency
    ... A report fetches a lot of rows using the "WITH " syntax (the ... Note that lock timeouts are by default off in SQL Server. ... NOLOCK has nothing to do with optimistic concurrency. ...
    (comp.databases.ms-sqlserver)
  • Re: [v2.6.30 nfs+fscache] swapper: possible circular locking dependency detected
    ... lockdep wasn't going to help. ... If you scroll down past the locking report, ... This shows up after heavy use of my nfs ... swapper/0 is trying to acquire lock: ...
    (Linux-Kernel)
  • Re: 2.6.22-rc2-mm1
    ... hiddev disabled should also be interesting - that would avoid the ... this mouse probably has some "interesting" HID report descriptor. ... rhythmbox/6976 is trying to acquire lock: ... More majordomo info at http://vger.kernel.org/majordomo-info.html ...
    (Linux-Kernel)