Fast query, but slow from Stored Procedure / Function- How query optimizer can screw your day
How parameter sniffing can destroy your query performance
sql
Setting Firing Order Of SQL Triggers
At times there is a need to control order of execution of triggers. This could be due to business requirement but also as a way to control history of a record I usually don’ t see people put any way to prevent trigger nesting, example update trigger updating same records would fire the trigger again.
SQL Rounding Error when calculating percentages
For cross compatability between sql and mysql servers when we do a division on a aggregated variable like count we need to promote the INT to a DOUBLE type by multiplying it by 1.00 otherwise our results will loose precision Examples 1/2=0 Incorrect Results 1.00/2=.5 or 1.00/2.00=.5 Good For sake of consistency both variables have …