August 2005 - Posts

• Statistics Update Date

  In order to determine t h e datetime that the statistics of an index where last updated the STATS_DATE function can be used. Below is an exam p le to de termine when the statistics were last updated for the Primary Key (PK_Orders) on the Orders Table. Read More... Posted Sunday, August 21, 2005 7:26 PM by peter@wardyit.com | 0 Comments

• Microsoft Business Score Card Manager

  If you are are using or looking to use SQL Server Analysis Services to measure Key Perfromance Indicators then Microsoft Business Score Card Manager may be worth a look. "Microsoft Business Score Card Manager is a new server-based business performance Read More... Posted Sunday, August 21, 2005 2:01 PM by peter@wardyit.com | 0 Comments

• Microsoft SQL Server 2005 Upgrade Advisor

  The Microsoft SQL Server 2005 Upgrade Advisor is a tool that can be used to analyze a SQL Server 7.0 or 2000 database servers in preparation for upgrading to SQL Server 2005. The Upgrade Advisor analyzes the configurations providing reports that identify Read More... Posted Sunday, August 07, 2005 4:44 PM by peter@wardyit.com | 0 Comments

• SQL Server User Group Meetings

  If you have been unable to attend one the Australian SQL Server User Group m eetings, or are interested in on e of the topics that have been presented in another state then the PowerPoint decks can be downloaded for each state from the following link Read More... Posted Sunday, August 07, 2005 4:38 PM by peter@wardyit.com | 0 Comments