A deadlock is an inevitable situation in the RDBMS architecture and very common in high-volume OLTP environments. A deadlock situation is when at least two transactions are waiting for each other to complete. The Common Language Runtime (CLR) of .NET lets SQL Server 2005 provide developers with the

When you use the OLE DB for OLAP provider in Microsoft SQL Server 2000 Analysis Services, physical memory usage increases for multithreaded applications. Physical memory usage increases as the number of threads that are using the provider increases.

(Steve Manik) A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is stored in the database. It is a query stored as an object. Hence, a view is an object that derives its data from one or more tables. These tables are referred to as base […]

(Allan Mitchell and Darren Green) Determining how you will upgrade your DTS packages to SQL Server Integration Services (SSIS) is the first step in creating a DTS-to-SSIS migration strategy.

Best-practices architecture and operational techniques can help IT administrators respond to emerging business opportunities with speed and agility while helping to reduce data center complexity and cost. This special clustering section explores a wide range of high-availability and high-performance

(Brian Walker) This tip continues the system stored procedure series with a routine to create a comma-delimited file containing data from several columns. (R)

This whitepaper discusses how MIS DecisionWare and the Microsoft platform work together to improve data quality, simplify information access and streamline business processes. Microsoft customers can use MIS to optimize corporate performance in a quick, affordable manner. (R)

(Muthusamy Anantha Kumar) Part I of this article illustrated how to monitor CPU usage of running processes on a local machine or from a remote machine. This article illustrates how to monitor the CPU usage of different running processes on different machines and collect the information in a database

(Serdar Yegulalp) SQL Server’s Data Description Language (DDL) allows you to write scripts that define data and data relationships in a database. It’s used to load data into a database rather than create the database itself. So, if you’re testing SQL Server, DDL scripts will quickly repopulate a dat

(Shushmul Maheshwari) The ultimate utility of a database lies in presenting the data in different formats to fulfill the information requirements of various users. Microsoft SQL Server 2005 Reporting Services (SSRS) gives nontechnical end users and programmers a server-based reporting platform that