SQL 2000

This Category deals traditionally with SQL 2000 Server Technologies

Understanding UpdateStats

Well all of us in DBA world know to use UPDATE STATISTICS and its significance in keeping or SQL Space Ship updated with current index pattern and it is further usage by optimizer to process our queries at escape Velocity. As per SQLBOL Query optimization depends on the accuracy of the distribution steps: If there is significant change in the key values in the index, rerun UPDATE STATISTICS on that index. If a large amount of data in an indexed column has been added, changed, or removed (that is,...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Monday, August 15, 2005 9:05 AM | Feedback (1)

Test the IO of the SQL Server Upfront {the SQLIOStress utility}

Before you use it please make sure ... not to use in running Production Environment You can use this utility to perform stress tests on disk subsystems to simulate Microsoft SQL Server 2000 and Microsoft SQL Server 7.0 read, write, checkpoint, backup, sort, and read ahead activities. This article provides the download location to an updated version of the SQLIOStress utility. For more information on this update, see the Readme file that is provided in the package. The following file is available...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Tuesday, August 02, 2005 7:51 AM | Feedback (1)

Tape Backups

Actually I was working on this issues from last few days but got busy and couldnt update I suppose a user is facing these issues. 1. Ur 3 DB size is 60 , 10 and 102. Your Tape Drive has just 24 GB space and they are DLttapes 3. you want tapes to synchronously ask for replacement So here we go ..first read this small sumamry and then I ahve kept the link to the document that ia hve uplaodedfor using tape Drive... I am not using any third party , No Script, only SQL ENTERPRISE MANAGER Backup Media...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Monday, July 25, 2005 11:53 AM | Feedback (0)

SQL SERVICE BROKER

From past so many days I am trying to write something or the other..Bt some how started on this fundamental first DBA topic of YUKON SQL SERVICE BROKER Is it like internal MSMQ of SQL ???Or a Messaging service between various SQL Components what happened with the proliferation of web and Non Web applications was that it created a need for increased process management across database applications. All SQL 2005 papers give example of Order entry System for positioning this Service Broker.But I feel...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Tuesday, October 19, 2004 10:49 PM | Feedback (7)