Ok thanks for confirming this. I didn't think so but many of the rows seemed to have redundant, overwritten data. I just did a restore, merged in the...

Thanks for clarifying. I must have done something really wrong here because now the target column doesn't appear to be showing the correct data. It looks like a...

I went ahead and ran that statement to create the index with the fill factor. I read online that when the rows for a clustered index are not unique...

Thanks. So I'll need to run the following before creating the index, right?

Use IISLogs;

GO

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'fill factor', 100;

GO

RECONFIGURE;

GO

Thank you both for the super quick responses!

Yes, I'm not necessarily after a primary key here - I mainly want to ensure quick searches. I will try and create...