Wow GSquared, thank you so much for taking your time and putting this together, i do appreciate it very much 🙂 so basically all i need is to create a...

hey guys, hope you all had a great easter weekend. i wanted to see if you had any chance to think of a better way to do this, i am...

i tried creating clustered index and it complains that it cannot be done because it contains UNION, any suggestions?

CREATE UNIQUE CLUSTERED INDEX IDX_Friends ON dbo.friends (user_id, friend_id)

thanks guys, my main concern is performance i dont really care about space. this table will be heavily used (inserts and selects). if i go with the indexed view that...

thanks for your response Barry.

so there are no other alternitives to go about? somehow i think there is gotta be an easier way, but maybe not...