Search results for ""

Create SQL Trigger

General A trigger is a stored procedure that automatically executes when an event occurs in the database server.Triggers execute when users try to modify something or behind an event that generate changes on the data base.There are three kind of triggers: for insert , update , and delete.The most important events correspond to Transact-SQL CREATE, ...

How to make a database faster?

The big pain Did you ever tried to work with some databases that contain big tables? And by BIG I mean one table at least that has more than 1 million records. No matter you are using MySql, SqlServer, Oracle or other DBMS, the problem is same: finding informations in that table ( records as we all know them) is very very slow. Can take minutes if the ...