http://www.philosophicalgeek.com/2008/04/01/10-ways-to-learn-new-things-in-development/
Tuesday, April 22, 2008
SQL SERVER - 15 Best Practices for Better Database Performance
Read the below 14 best practices and let me know what is as per your opinion should be the 15 best practice
1. Store relevant and necessary information in the database instead of application structure or array.
2. Use normalized tables in the database. Small multiple tables are usually better than one large table.
3. If you use any enumerated field create look up for it in the database itself to maintain database integrity.
4. Keep primary key of lesser chars or integer. It is easier to process small width keys.
5. Store image paths or URLs in database instead of images. It has less overhead.
6. Use proper database types for the fields. If StartDate is database filed use datetime as datatypes instead of VARCHAR(20).
7. Specify column names instead of using * in SELECT statement.
8. Use LIKE clause properly. If you are looking for exact match use “=” instead.
9. Write SQL keyword in capital letters for readability purpose.
10. Using JOIN is better for performance then using sub queries or nested queries.
11. Use stored procedures. They are faster and help in maintainability as well security of the database.
12. Use comments for readability as well guidelines for next developer who comes to modify the same code. Proper documentation of application will also aid help too.
13. Proper indexing will improve the speed of operations in the database.
14. Make sure to test it any of the database programming as well administrative changes.
Thursday, April 3, 2008
Yahoo maps
With an Intelligent Search & Landmark Based driving directions, Finding Places, Businesses and Directions in India has never been easier before.
www.in.maps.yahoo.com/
Tuesday, April 1, 2008
http://www.formassembly.com/time-tracker/
http://www.formassembly.com/time-tracker/
Time Tracker is a simple tool to keep track of the time you spend on any task. Think of it as a to-do-list with a clock. And yes, it's free.
http://virtual-whiteboard.co.uk/home.asp
http://virtual-whiteboard.co.uk/home.asp
Whiteboards are created using elements like notes, text, symbols, and images. Once an element has been included by a participating user, the whiteboards of all users are automatically updated to reflect the change. Elements can be positioned (and notes resized) simply by dragging them with a mouse. Updating the text in a note is as simple as double-clicking with the mouse. There is even a text chat window provided for you to exchange instant messages with other users, as well as other facilities like easily being able to send an alert message to the browser of all participating whiteboard users.
Subscribe to:
Posts (Atom)
Posts
