problem while inserting data

• ManoharV

  SSCommitted

  Points: 1730

  More actions

  August 10, 2009 at 1:24 am

  #209433

  Hi,

  I am facing problem while inserting records to a table.

  The insertion for the table is very high (around 2000 per min) and selection for a record set is normal(around 5 to 10 times)

  Here some records are not getting inserted.

  Table structure

  ---------------

  UserResponseIDbigint (primary key)

  ScheduleUserIDbigint (non clustered index)

  QuestionGUIDvarchar(50)

  UserResponsexml (small xml data of about 5 lines)

  Date datetime

  One more thing to add is the application and database is deployed on a cloud server.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  August 10, 2009 at 4:16 am

  #1036660

  Your post does not contain any information that could allow anybody to help you.

  I suggest you take a look at this article and add some more info on your post.

  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  Regards

  Gianluca

  -- Gianluca Sartori