Sql

03/18/19

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?

03/02/15

SQL database

 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

03/02/15

SQL database

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

03/02/15

SQL database

 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

03/02/15

SQL database

 Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row into the Products table. This stored procedure should accept five parameters. One parameter for... more

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.