Category Archives: Database
SQL SERVER INDEXES
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 supports two types of indexes: Clustered indexes define the physical sorting of a database table’s rows in the storage media. […]
Difference between TRUNCATE and DELETE commands in 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 why when you type ROLLBACK after deleting a table; you can get back the data (The system gets it for […]
Some SQL-Server Performance Enhancement Tips
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 cases heavy-duty queries might degrade performance up to 70%) instead of large heavy-duty queries text. This also facilitates permission management […]