Why aren't there any more SQL jokes in this thread?

Because:SELECT JokeText
FROM SQLJokes.dbo.JokesTable AS JT
    INNER JOIN SQLJokes.dbo.LaughterQuality AS LQ
        ON JT.LaughterQualityID = LQ.LaughterQualityID

Creating more available space in the database file is what you accomplished when you got rid of tables.   Shrinking that space out of the file is not necessarily a good...

Without the table structure and the two queries, along with a much more detailed description of what the records in the table represent, it is impractical to offer much advice,...

This seems to work as well:CREATE TABLE #SampleData (
    DayOne varchar(9) NOT NULL,
    DayTwo varchar(9) NOT NULL
);
CREATE CLUSTERED INDEX NDX_TEMP_SampleData_DayTwo_DayOne_ ON #SampleData
    (
    DayTwo ASC,
    DayOne ASC
    );