title: What is the purpose of PAD_INDEX in this SQL Server constraint?
body: <p>I have the following constraint being applied to one of my tables, but I don't know what PAD_INDEX means.</p>
  
  <p>Can someone enlighten me?</p>
  
  <pre><code>CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED 
  (
      [EmployeeId] ASC
  ) WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
          ^--------------^
           this part here
  </code></pre>