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. For this reason, each database table may have only one … Continue reading SQL SERVER INDEXES

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 you from the Rollback Tablespace). All this process takes time. But … Continue reading Difference between TRUNCATE and DELETE commands in SQL-Server

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 as you can restrict user access to table columns. Use … Continue reading Some SQL-Server Performance Enhancement Tips