from the name of the table, I guess there is a considerable amount of records in it.

It looks like it, unneccessarily, computes the dateadd function for each row.

you might store the value in a variable

declare @yesterday smalldatetime = dateadd("d", -1, getdate())

and use it like

...

and date > @yesterday