There is nothing specific .. table would be created with required columns and a guid column. This guid column would be a clustered index on the table. At the end...

In General, assume i'm doing a search transaction where system would fetch data based on multiple filter criteria. Our core design would be to populate all the records matching key...

But my question is do we have a better approach to avoid deadlocks? Instead of GUID do we have any better suggestion for clustered index ? Is it a good...