Browse by Tags

All Tags » SQL 2005 (RSS)
07 November 2009 17:55

New version of Expressmaint now available (2.0.0.0)

A new version of the Expressmaint database maintenance utility is now available for download. This version adds the ability to specify a custom backup file name format. Please note there are specific version for SQL 2005 (2.0.0.0) and SQL 2008 (2.0.0...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
21 October 2009 18:08

Restoring an Expressmaint backup using SQL Server Management Studio Express

This post describes step by step how to restore a full database backup taken with Expressmaint (or by any other means) using SQL 2005 Management Studio Express (SSMS). The same steps apply to SQL 2008. To download this free tool for SQL Server Express...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
13 September 2009 21:20

New version of Expressmaint now available (1.9.0.0)

A new version of the Expressmaint database maintenance utility is now available for download. This version fixes an issue with the timeout parameter (-TO) being treated as seconds instead of minutes for the REORG task. Please note there are specific version...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
29 July 2009 16:03

Keeping up with SQL Server KB articles

One of the most useful tools for anyone involved in day to day support of SQL Servers is being able to keep up with the latest Microsoft Knowledge Base articles for the products you support. There are RSS feeds available for each of the currently supported...
Posted by sqldbatips | 1 comment(s)
Filed under: , , ,
12 May 2009 16:44

Disk Partition Alignment Best Practices for SQL Server whitepaper

This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis...
Posted by sqldbatips | with no comments
Filed under: , , ,
07 April 2009 21:39

Updated build of ExpressMaint now available (1.8.0.0)

An updated build of the ExpressMaint utility for SQL 2005/2008 is now available. This release contains the following changes Added support for SQL Authentication Fixed an issue with databases that have not started being filtered out in Express Edition...
Posted by sqldbatips | with no comments
Filed under: , ,
07 March 2009 17:47

Updated build of ExpressMaint utility is now available (1.7.0.0)

An updated version (1.7.0.0) of the ExpressMaint utility for automating database maintenance operations for SQL 2005/2008 Express Edition is now available. This new version includes the following fix Fixed error when backing up instance with user instances...
Posted by sqldbatips | with no comments
Filed under: , ,
04 November 2008 18:17

Updated build of ExpressMaint utility is now available

An updated version (1.6.0.0) of the ExpressMaint utility for automating database maintenance operations for SQL 2005/2008 Express Edition is now available. This new version includes the following fixes Fixed error when database name contains an apostrophe...
Posted by sqldbatips | with no comments
Filed under: , ,
29 October 2008 12:43

SQL 2005 Service Pack 3 Beta now available

SQL 2005 Service Pack 3 Beta is now available for testing. Remember this is a beta for testing purposes only, do not deploy to production servers Download SQL 2005 SP3 Beta View what's new in SP3
Posted by sqldbatips | with no comments
Filed under: ,
20 October 2008 20:01

View plus Synonym plus Linked Server plus Table equals Trouble

Whilst synonyms can be a very useful tool for abstraction I am a firm believer that they shouldn't change the behaviour of queries that use them, they should simply be alternative names for objects (local or remote). Recently I came across an issue...
Posted by sqldbatips | 2 comment(s)
Filed under: , ,