When encountering the error "cannot resolve the collation conflict between latin1_general_ci_as and sql_latin1_general_cp1_ci_as in the equal to operation" in SQL Server, what is a common way to resolve the conflict?
A) Change the database engine
B) Modify the SQL query to use the COLLATE keyword
C) Restart the SQL Server service
D) Increase the server's memory allocation