NEWID

FIRST_VALUE and LAST_VALUE functions

About window functions

Random sampling of rows from a table in SQL Server

Typical problems