Posted by ihafidh on March 9, 2006
The Microsoft SQL Server Advisory Team has a good article on indexes:
http://blogs.msdn.com/sqlcat/archive/2005/12/12/502735.aspx
They include very useful performance tuning queries. SQL Server 2005 has what they call DMV (Dynamic Management Views) that lets you do diagnostics and tuning. This was not available in SQL 2000. This article answers the following questions:
(1) How can I find out whether my indexes are useful? How are they used?
(2) Do I have any tables or indexes that are not used (or rarely)
(3) What is the cost of index maintenance vs. its benefit?
(4) Do I have hot spots & index contention?
(5) Could I benefit from more (or less) indexes?
Worth a bookmark.
Posted in AS2005 | Leave a Comment »
Posted by ihafidh on March 9, 2006
Download the SQL Server 2005 System Views here.
Use it to get familiar with internal workings of SQL Server 2005.
Found this from SQL-Server-Performance.com.
Posted in AS2005 | Leave a Comment »
Posted by ihafidh on March 9, 2006
NetZero Voice-over-Internet Protocol (VoIP) Service for Dial-Up and Broadband lets you call Anyone, Anywhere in the world, Anytime for Free.
Setup an account with Netzero and you can make calls in the US and Canada for free. They also give you a local US number. So international users can call you for free. i.e. PC to Phone!
Thanks to my friend Sabir for this link.
Posted in deals | Leave a Comment »
