DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

shruti Subscribe to this feed
shruti
Profile Kicked Submitted Comments Tags Friends Kicked By Friends Submitted By Friends


Comments:
SQL SERVER - 15 Best Practices for Better Database Performance

First of all good one Pinal,

I can think of following few points to add as 15th.

1. if using idexed, look closely at your where statement to make sure columns in where clause are properly ordered.
2. Work with Linked servers whenever possible.
3. If working with large databses use NOLOCK in queries.
4. Use of Begin Tran and Commit Tran would help in large updates on production database.

Pinal,
Please let me know if any one of above points seems incorrect.

Thanks,
Shruti
posted by shruti 7 months, 8 days ago
  

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge