What is parallelism?

• miss.delinda

  SSCommitted

  Points: 1616

  More actions

  June 12, 2011 at 10:01 pm

  #239055

  What is parallelism?

  I want to using SCOPE_IDENTITY(). After read about parallelism, it make me afraid

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 12, 2011 at 10:10 pm

  #1337562

  miss.delinda (6/12/2011)

  ---

  What is parallelism?

  I want to using SCOPE_IDENTITY(). After read about parallelism, it make me afraid

  The following article contains a solution to this problem:

  http://blog.sqlauthority.com/2009/03/24/sql-server-2008-scope_identity-bug-with-multi-processor-parallel-plan-and-solution/

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• CarpenterBob

  Ten Centuries

  Points: 1026

  More actions

  June 20, 2011 at 10:28 am

  #1341315

  http://msdn.microsoft.com/en-us/library/ms188611.aspx

  'for parallelsim'

  http://msdn.microsoft.com/en-us/library/ms190315.aspx

  'for scope identity'