Skip to content

Instantly share code, notes, and snippets.

@philip-paolo
philip-paolo / 1.txt
Last active July 20, 2022 10:31
Performance tuning
-- Dropping PK and creating new PK with CompanyID, ID to align with policy
ALTER TABLE [dbo].[ContactLists] DROP CONSTRAINT [PK_ContactLists] WITH ( ONLINE = OFF )
GO
ALTER TABLE [dbo].[ContactLists] ADD CONSTRAINT PK_ContactLists PRIMARY KEY CLUSTERED ([CompanyID] ASC, [ID] ASC)
GO

Keybase proof

I hereby claim:

  • I am philip-paolo on github.
  • I am philippaolo (https://keybase.io/philippaolo) on keybase.
  • I have a public key ASBd3yOnM0dp7Kpdql8oUpxulfKNugilTx0zQpKcu9e7EQo

To claim this, I am signing this object: