(Muthusamy Anantha Kumar) This article illustrates how to monitor the CPU load on SQL Server and Windows machines using Windows Management Instrumentation and VBScript to collect data in the Round Robin database and then produce graphs using the Round Robin Tool.

Consider the following scenario. You are running a 32-bit version of Microsoft SQL Server 2000 Service Pack 4 on an x86-based computer or on an x64-based computer. If Address Windowing Extensions (AWE) support is enabled, SQL Server 2000 can only use a maximum of 50 percent of the physical memory th

(Serdar Yegulalp) At some point, almost every SQL Server administrator faces the prospect of copying or moving a database from one instance of SQL Server to another. Usually this scenario comes about because of an upgrade; for instance, maybe a new installation of SQL Server 2000 has been designed t

When you use either of the following utilities, duplicate aggregations may be created for a partition: • The Partition Aggregation. The Partition Aggregation utility is included with Microsoft SQL Server Accelerator for Business Intelligence (SQL Server Accelerator for BI). • The Partition Manag

(Kurt Survance) This article is written for someone with a working knowledge of information technology, but with little specific SQL Server expertise. The typical reader would be an IT manager or executive who needs background information to properly evaluate all the performance tuning suggestions b

The Distribution Agent may skip all the transactions in a batch and all the commands that correspond to the transaction if all the following conditions are true: • A subscription to a transactional publication contains articles that have user-defined triggers. These triggers are defined at the su

(Ashvini Sharma) There’re two properties on the Data Flow task that have piqued enough interest to cause this post. Note that while I’m describing numbers below, the SSIS team reserves the right to change them in response to our performance testing. There’re no secrets here, most of this information

(Serdar Yegulalp) Data integrity in SQL Server is one of those things that doesn’t seem like an obvious topic for an administrator to address directly. After all, doesn’t SQL Server automatically ensure the integrity of your data? Well, yes, but only up to a point. SQL Server itself won’t protect yo

(William Pearson) In this article, I will present a “combined approach” for the support of a top- or bottom- count picklist in the reporting environment. This option will enable an information consumer to decide, on the fly, whether a “top” or “bottom” query is more appropriate, as well as to input

(Pankaj A. Chitriv) When I started working on database clustering, there were lots of questions in my mind like – “Do I need to have multiple databases?”, “How and who will take care of data synchronization between different databases?”, “How will the client communicate with the DB server in a clust