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.

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/

Online file sharing and storage - 5 GB free web space.

http://www.4shared.com/

Articles of ASP.NET, C#, SQL Server, Timesaver Tools

http://chiragrdarji.wordpress.com/

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.

Watch Online Telugu Movies

http://aakasavani.com/category/telugu-movies/

Englsih - Telugu (Search word)

http://www.aksharamala.com/telugu/e2t/search.php

Telugu -English Dictionary

http://www.websters-online-dictionary.org/translation/Telugu/

Learn English Online

http://www.britishcouncil.org/kids.htm

Here is the link to send free SMS to any mobile in India

http://www.indyarocks.com/register_step1.php?invitor=NTM4MDAy&emailencryp=Y2huYWdlbmRyYXByYXNhZEBnbWFpbC5jb20=

Best New Free Computer IT Training Tutorial Resources

http://www.intelligentedu.com/blogs/post/date/2008/03

The important transitions in the ASP.NET 3.5 Framework

Microsoft LINQ to SQL is a new query language that enables you to access a database without writing any SQL.

Two new data access controls introduced with the ASP.NET 3.5 Framework: the ListView and DataPager controls to display, page, sort and edit a set of or single database record at a time.

Various navigation controls included in the ASP.NET Framework, such as the TreeView and Menu controls. You can use these controls with a Site Map in order to allow users to easily navigate web site.

The Microsoft AJAX Extensions for ASP.NET are integrated into the ASP.NET 3.5 Framework. AJAX represents a transition from using server-side technologies to using client-side technologies when building web applications.

AJAX – Highly responsive and interactive web applications that behave more like desktop applications.

For uploading music/video

http://www.imeem.com/

Link to Listen Jalsa Audio Songs with high quality

http://chnagendra.page.tl/Jalsa-Audio-Songs.htm

Frequently asked Generic Interview Questions

Tell me about yourself. [about myself means about my introduction i.e. my name , which place i belong to about my family background ,about my career about my achievements about my strengh and weakness and about my hobby and interest in an specific feild .]
What experience do you have in this field? How many years of experience do you have in area you are applying for?
Why did you leave your last job? Why are you planning to leave your current job? [There isn’t room for growth with my current employer . I have set some career goals for myself, and I know that I cannot achieve them at my current company. My goal is to work for a larger company with a possible career path.
Found myself bored with the work and looking for more new challenges]
What do you know about this organization? [According to me this is one of the best company. It has a good Environment, We feel good working in companies, which hasgood growth in the IT Industries. This Organization has allthe qualities like good growth, good Environment,maintaining a best level in the IT Industries, etc.]
Why do you want to work for this organization? [It values people,gives better package,latest technologies etc]
How would you describe your ideal job? [a job that is motivational,the one that deives me to work harder ]
How long would you expect to work for us if hired? ["I'd like it to be a long time." or"As long as we both feel I'm doing a good job."]
What have you done to improve your knowledge recently?
What do co-workers say about you? [My co-workers always admit that I am good team player by providing suitable advices at the right time.]
What irritates you about co-workers? What kind of person would you not work with?
Do you know anyone who works for us? (Relatives/Friends?)
What is your salary expectation?
Are you a team player or independent contributor?
What is your philosophy / ethics towards work?
Tell me about a problem you had with a supervisor?
How do you handle conflict at work?
How do you handle heavy stress at work?
What has motivated you to do your best on the job?.
What has disappointed you about a job?
What is your greatest strength? What is your weakest point?
How would you know you were successful on this job?
Would you be willing to relocate if required?
What have you learned from mistakes on the job?
If you were hiring a person for this job, what would you look for?
What has been your biggest professional disappointment or failure?
Do you think you are overqualified for this position?
How will you compensate for your lack of experience?
What do you see yourself doing five years from now?
What major problem have you had to deal with recently and how did you overcome?
Why should we hire you?
Do you have any questions for me?

Telugu Chating

http://computerera.co.in/chat/

Telugu blogs anf telugu sites

http://etelugu.org
http://telugublog.blogspot.com
http://te.wikipedia.org
http://koodali.org/

Telugu transliteration softwares

http://baraha.com/BarahaIME.htm
http://groups.google.com/group/aksharamala

Telugu transliteration sites

http://google.com/transliterate/indic/telugu
http://lekhini.org/
http://swecha.org/
http://quillpad.com/telugu/

Singer Sunitha official web site

http://www.bitra.com/www/sunita/

Collection of portals

http://www.bitranet.org/html/portfolio_viewall.asp

What is the advantage of putting the SQL statements inside a procedure?

Speed, security, modularity, consistency and reduced network congestion

What is difference between char(1999) and varchar2 (1999)

CHAR is always 1999 characters long physically AND logically. But the varchar is physically 1999 bytes but logically can be any size in between 0 and 1999. The char is always blank padded, not so for the varchar.

Own a Free Website Now!

http://littlewriter.page.tl/Own-a-Free-Website-Now-ar-.htm