Avoid using Emulated function:
When the migration of objects by
Using SSMA, emulated functions would have created in SYSDB by SSMA
and those functions will be referred to replace the SQL Server system
functions in the database objects. These emulated functions, may
affect the performance of the query.
To avoid the performance impact,
should use the below changes. Emulated function call has been
replaced with actual statement change using case statement (Like If
@start <0 for substring) or by making necessary platform specific
parameter alteration (Like Proper SQL server specific datepart
).
Please click here to know about sybase to sql server migration issues
No comments:
Post a Comment