You can use LIMIT and OFFSET to write a SELECT statement that brings back rows referenced by "index" from the start of a table easily, but I'm looking for a way to insert/update rows by index ...

Learn how to drop an index in SQL Server using T-SQL or SSMS, what to consider before dropping an index, and how to monitor the effects on your database.