NonClustered Indexes Creating Issues RSS

• • Reply
  

  veerbala82

  0 Points

  3 Posts

  NonClustered Indexes Creating Issues

  Nov 05, 2012 02:39 AM|LINK

  Hi Folks,

  How to troubleshoot NonClustered Indexes on tables creating locking/blocking during query execution?

  Thanks

  Balaji.V

• • Reply
  

  Amy Peng - M...

  Star

  11649 Points

  1082 Posts

  Microsoft

  Re: NonClustered Indexes Creating Issues

  Nov 06, 2012 01:21 AM|LINK

  Hi veerbala82,

  Creating a nonclustered index locks out all updates until it is created, hope this article can be helpful to you: http://www.mssqltips.com/sqlservertip/2517/using-a-clustered-index-to-solve-a-sql-server-deadlock-issue/ .

  Regards,
  Amy Peng

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
• • Reply
  

  veerbala82

  0 Points

  3 Posts

  Re: NonClustered Indexes Creating Issues

  Nov 06, 2012 02:12 AM|LINK

  Hi Amy,

  Thanks for the link. I cannot create a Clustered Index for this situation. I face this problem once a month when the volume of qualifying records is high.

  Thanks

  BV

• • Reply
  

  Amy Peng - M...

  Star

  11649 Points

  1082 Posts

  Microsoft

  Re: NonClustered Indexes Creating Issues

  Nov 12, 2012 04:09 AM|LINK

  veerbala82

  Hi Amy,

  Thanks for the link. I cannot create a Clustered Index for this situation. I face this problem once a month when the volume of qualifying records is high.

  Thanks

  BV

  Hi veerbala82

  I am sorry for my later reply, could you please tell me what do you mean? you can not create cluster index for which situation?

  Thanks,
  Amy Peng

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store