Favourite performance tuning tricks?
When you have a query or stored procedure that needs performance tuning, what are some of the first things you try?
Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table. This trigger should raise an appropriate error if the discount percent is... more
Create a trigger named Products_INSERT that sets DateAdded column of the Products table to current date if the value for that column is null. Test this trigger with the following INSERT INTO... more
Write a script that creates and calls a stored procedure named spUpdateProductDiscount that updates the DiscountPercent column in the Products table. This procedure should have one parameter for... more