title: Concurrent SQL Insert Are Blocking to a Table
body: <p>I am using the SQL 2005 for an application. In my case, numbers of requests are being generated through different processes and inserting the Record to one Table. But when I examine the processes running in database by sp_who2 active procedure, I find the Inserts are being blocked by other Inserts Statements and causing the process slower. Is there any way to avoid the blocking / deadlocks in concurrent inserts to one table. Below is the structure of my table.</p>
  
  <pre><code>`CREATE TABLE [dbo].[Tbl_Meta_JS_Syn_Details](
      [ID] [int] IDENTITY(1,1) NOT NULL,
      [EID] [int] NULL,
      [Syn_Points_ID] [int] NULL,
      [Syn_ID] [int] NULL,
      [Syn_Word_ID] [int] NULL,
      [Created_Date_Time] [datetime] NULL CONSTRAINT [DF_Tbl_JS_Syn_Details_Created_Date_Time]  DEFAULT (getdate()),
   CONSTRAINT [PK_Tbl_JS_Syn_Details] PRIMARY KEY CLUSTERED 
  (
      [ID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]`
  </code></pre>