This Category deals traditionally with SQL 2000 Server Technologies
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, ......
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 ......
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 ......
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 ......