This comes up regularly. Ive tested most scenarios in the past and datediff/dateadd always comes out the fastest - often by a good margin. It also has the advantage of being locale-independent (doesnt matter whether your dates are ddmmyyy or mmddyyyy or whatever).