The Database Answers Community

For people interested in Databases

Barry Williams

Best Practice in SQL Server Performance Tuning

Information

Best Practice in SQL Server Performance Tuning

Look here for advice, tips and hints when your Database is running slowly.

Members: 20
Latest Activity: Nov. 9, 2009

Discussion Forum

MR. BOOL

This web site can help you!!!

Started by MR. BOOL Apr. 15, 2009.

Comment Wall

Comment

You need to be a member of Best Practice in SQL Server Performance Tuning to add comments!

Barry 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
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
Srikanth 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
 

Members (19)

MR. BOOL Barry Williams sbr ALEXANDRA GUTIERREZ GRANADOS G Bryant McClellan Kishore Geoff Kenia Sandoval Higareda Peter Samson Srikanth Adeel Arshad Barry Leah Foster Karel Vandenhove Thananjeyan Vellaisamy Ayoub Bouddount Jeff Caskey Patrick Wood ahmed mohamed geaissa
 
 

Badge

Loading…
 

© 2010   Created by Barry Williams on Ning.   Create a Ning Network!

Badges  |  Report an Issue  |  Privacy  |  Terms of Service