Browse by Tags
All Tags »
update (RSS)
Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as
Read More...
Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required
Read More...
As we blogged much on Books Online importance and recent changes to availablility of updated books online for SQL Server 2005 under BOL-Sep2007-MSDN-Technet the same update is available to download. Do not forget to update your local copies as it will
Read More...
Since the release of SQL Server 2005 Service Pack 2, Microsoft development team has released various builds that are classed as Cumulative Updates. Also we blogged on this site - CumulativeUpdate4 & http://sqlserver-qa.net/blogs/tools/archive/2007/10/16/keep-your-eyes-open-for-cumulative-update-4-for-sql-server-2005-service-pack-2.aspx
Read More...
August 19 2007: As per the KBA-BlogPost on Cumulative Update 4 for SQL 2005 SP2, Microsoft confirms that this cumulative update package will be released in the October 2007 timeframe. The information that is presented here is subject to change at any
Read More...
Well this is confusing me, this DownloadLink refers SQL Server 2005 Books Online as May 2007 update that can be installed on the machine. But when you search for any content on MSDN library for SQL Server it refers " SQL Server 2005 Books Online (September
Read More...
During a user group meeting one of the user asked that If we were to migrate our databases over to the evaluation edition of SQL Server 2005, is there a way of upgrading to the purchased (licensed) version (before the 180 day expires) without uninstalling
Read More...
Yet another information on cumulative update for SQL Server 2005 Service Pack 2 installations and make are note of the following: This cumulative update package will be released in August 2007. The information that is presented here is subject to change
Read More...
Yet another update to SQL Server 2005 Books Online, though it states May 2007 update that was released on June 06th 2007! During February 2007 with the release of Service pack 2 Microsoft has updated the BOL content to reflect the changes with SP2. For
Read More...
You might have come across this instance of error within your environment: Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' The above error used to drive me nuts when the users complained by specifying
Read More...
Updates to system catalogs are not allowed - a big subject and nothing but opening door to trouble by allowing direct updates or modifications to system tables in SQL Server 2005. If I remember correctly since the days of SQL 6.5 version Microsoft has
Read More...
You may be aware about SQL Server 2005 Express edition is a free and simple to manage edition in 2005 version. It has an integratin with Visual Studio 2005 to make it easier to develop data driven applications with a redistributable option, well I'm not
Read More...
On SSP forums I have looked at the question about Update Statistics and AUTO UPDATE STATISTICS option available on a SQL server database; 1> When i say Auto create statistics, what are the columns for which statistics are collected? Are these all columns
Read More...