![SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/ignoredup1.jpg)
SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave
![SQL SERVER – How to create a nonclustered index within the create table statement | SQL Server Portal SQL SERVER – How to create a nonclustered index within the create table statement | SQL Server Portal](https://raresql.files.wordpress.com/2015/01/how-to-create-a-nonclustered-index-within-the-create-table-1-1.png)
SQL SERVER – How to create a nonclustered index within the create table statement | SQL Server Portal
![SQL SERVER - Introduction to Filtered Index - Improve performance with Filtered Index - SQL Authority with Pinal Dave SQL SERVER - Introduction to Filtered Index - Improve performance with Filtered Index - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/1_Index.gif)
SQL SERVER - Introduction to Filtered Index - Improve performance with Filtered Index - SQL Authority with Pinal Dave
![SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - A Transactional Behavior - SQL Authority with Pinal Dave SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - A Transactional Behavior - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/duptr1.jpg)
SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - A Transactional Behavior - SQL Authority with Pinal Dave
![SQL Server: Clustered and Nonclustered indexes - TechNet Articles - United States (English) - TechNet Wiki SQL Server: Clustered and Nonclustered indexes - TechNet Articles - United States (English) - TechNet Wiki](http://i.stack.imgur.com/QF8d7.gif)