Definition Indexes are one of the biggest determinate of database performance. Indexes allow you to speed query performance on commonly used columns and improve the overall processing speed of your database. Types Microsoft SQL Server […]
TRUNCATE is a DDL command whereas DELETE is a DML command. TRUNCATE is much faster than DELETE. When you type DELETE. All the data get copied into the Rollback Tablespace first. Then delete operation get performed. That’s […]
Choose the Appropriate Data Types Use Triggers Cautiously Use views and stored procedures instead of heavy queries. It reduces network traffic, because client will send to server only stored procedure or view name (in certain […]
