PinPoint is a SharePoint Administration tool which you can download for free.

Example of features:

<Quote>

• Locate most active sites
• Identify documents and pages that have most activity
• Find largest sites and largest items in SharePoint

</Quote>

You can download here

** Do note that I am not advocating or promoting the product, nor in anyway I am affiliated to Axceler.

Quite often we will be writing custom XSL to customize the display of a Content Query Web Part (CQWP) and at times we would want to get the current page URL where the CQWP web part lives.  For example, providing a link to a custom page to display your item as shown below, where the “Details” link is pointing to a custom page.

However, you would like to be able to get back to the origin page where the link is clicked.  You could achieve this by doing the following in your custom XSL:

Step 1:  Add the following namespace to your custom XSL:

xmlns:ddwrt=”http://schemas.microsoft.com/WebParts/v2/DataView/runtime

Step 2:  Add a parameter name “PageUrl” right after XSL Stylesheet declaration:

<xsl:param name=”PageUrl” />

Step 3:  Add a query string to the link:

Step 4:  Add a link or button on your custom page and the following OnClick event:

As you probably have read regarding the SharePoint SP2 bug which reverts your license to the trial license which would expire after 180 days, and causes your existing license to expire in 180 days after the upgrade.  You could have fixes the problem by re-entering your license key into the system.

Microsoft has released a fix for this, this could be applied before or after the SP2 upgrade.

The 32-bit version can be downloaded here.

The 64-bit version is here.

For more information, you can read the kb article here:  http://support.microsoft.com/kb/971620