Tar's Arena

Introduction The following Tips and Guidelines are very important from the performance perspective of your SQL Server development or production database. The best way to achieve optimum performance benefits is to experiment with the following guidelines while using/viewing a query execution plan, both with and without implementing the respective tip/guideline. Tips and Guidelines • As a common practice, every table should have a clustered index. Generally, but not always, the clustered index should be on a column that monotonically increases, such as an identity column or some other column where the value is unique. In many cases, the primary key is the ideal column for a clustered index. • Indexes should be measured on all columns that are frequently used in WHERE , ORDER BY , GROUP BY , TOP and DISTINCT clauses. • Do not automatically add indexes on a table because it seems like the right thing to do. Only add indexes if you know that they will be used by the querie...

Are you worried about looking like a hunchback? Here’s a pain free and effective method for safely assuming a ‘correct’ posture and improving muscle tone. As a great side benefit, it would improve your self esteem and attitude! You will appear and feel more confident which improves your attitude and mood! Know what good posture is believed to be. Most people think that to “stand up straight” means tensing your back to heave your chest ‘in and up’, and pulling your head back in to your chest. This is not so. The spine has two natural curves that you need to maintain called the ‘double C’ or ‘S’ curves, these are the curves found from the base of your head to your shoulders and the curve from the upper back to the base of the spine. When standing straight up, make sure that your weight is evenly distributed on your feet. You might feel like you are leaning forward, and look stupid, but you don’t. [This needs an image] Using a mirror, align your ears, shoulders, and hips. [This needs an i...

Everyone can take steps to improve their memory, and with time and practice most people can gain the ability to memorize seemingly impossible amounts of information. Whether you want to win the World Memory Championships, ace your history test, or simply remember where you put your keys, this article can get you started. Scientists believe that exercising your brain can create a ‘cognitive reserve’ that will help you stay sharp as you age. 1. Convince yourself that you do have a good memory that will improve. Too many people get stuck here and convince themselves that their memory is bad, that they are just not good with names, that numbers just slip out of their minds for some reason. Erase those thoughts and vow to improve your memory. Commit yourself to the task and bask in your achievements — it’s hard to keep motivated if you beat yourself down every time you make a little bit of progress. 2. Keep your brain active. The brain is not a muscle, but regularly “exercising” the brain a...

1. Chewing on gum while cutting onions can help a Person from stop producing tears. Try it next time you chop onions!!!!!!!!!! 2. Until babies are six months old, they can breathe and swallow at the same time. Indeed convenient! 3. Offered a new pen to write with, 97% of all people will write their own name. 4. Male mosquitoes are vegetarians. Only females bite. 5. The average person's field of vision encompasses a 200-degree wide angle. 6. To find out if a watermelon is ripe, knock it, and if it sounds hollow Then it is ripe. 7. Canadians can send letters with personalized postage stamps showing their own photos on each stamp. 8. Babies' eyes do not produce tears until the baby is approximately six to eight weeks old. 9. It snowed in the Sahara Desert in February of 1979. 10. Plants watered with warm water grow larger and more quickly than plants watered with cold water. 11. Wearing headphones for just an hour will increase the bacteria in your ear by 700 times. 12. Grapes exp...