What impact can different cursor options have? I talk about the default cursor options in SQL Server and why you may want to override them.