Best Practice in SQL Server Performance Tuning

Comment

Comment by Barry on March 31, 2009 at 9:19am

Here's an interesting article from Mr.Bool that's worth a look entitled "10 Tips about SQL Server that every Developer should know".

Barry

Comment by Barry on March 19, 2009 at 11:51pm

Here's a good web site to keep up with SQL Server :-
http://www.sqlservercentral.com/

HTH

Barry

Comment by Srikanth on January 21, 2009 at 10:00am

Use the Truncate Table
Always use a truncate table command for deleting all the rows in a table (for cleanup purposes), never use the delete statement; the following are the advantages:
1. Less transaction log space is used.
2. The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row.
3. Fewer locks are typically used.
When the DELETE statement is executed using a row lock, each row in the table is locked for deletion. TRUNCATE TABLE always locks the table and page but not each row.
4. Zero pages are left in the table