Concurrency issue and virtal table????

• sumith1andonly1

  SSCrazy

  Points: 2250

  More actions

  January 16, 2013 at 6:21 am

  #393950

  when lots of request comes to a table (for insert /update).

  Can we split the table to virtual tables ?

  After process the request , the virtual table are concatenated into single and update the original table.

  Is that possible?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 16, 2013 at 8:03 am

  #1577831

  There's no such thing as a virtual table in SQL. You could write your code to insert into temp tables and later into the main table, probably over-complicating things

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  January 16, 2013 at 8:45 am

  #1577867

  You can use staging tables, or partitioning, if your edition supports it. Partitioning sounds like what you are thinking of.