One restriction that you might have faced at times with SQL Server is that the maximum size for an index can only be up-to 900 bytes. It is important to note that it is 900 bytes and not 900 characters.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help