(Sujith K.) CLUSTERING technology, which allows multiple stand-alone computing systems to function as a single virtual machine, has become a powerful ally in the fight for e-commerce application scalability and availability. In a nutshell, clustering boosts performance through better load balancing,

(William Pearson) In this article, we will examine Actions, a powerful feature in MSAS that allows information consumers to go beyond the robust OLAP perspective offered by the application, and to “step outside” for related information, or to generate commands or initialize programs, without leaving

(William E. Pearson III) This is the third article of the series, Optimizing MSSQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of

(Muthusamy Anantha Kumar) In a typical IT environment, it is often necessary to import flat files to SQL Server tables. Sometimes it is necessary to import many files at the same time, from the same or different folders. In this article, I am going to discuss how to import all of the files from a pa

(Christoffer Hedgate) When Andy recently added his latest piece in the Worst Practices series, about adding a column without thinking, it made me think about a worst practice I have been trying to combat for a long time. Maybe not as specific as most other worst practices, but one of the worst pract

(Joe Chang) The articles in the Quantitative Performance Analysis series examined the internal cost formulas used by the SQL Server query optimizer in determining the execution plan and the actual query costs for in-memory configurations. The previous articles restricted the actual query cost analys

(Amol Kulkarni) Error handling plays a vital role when writing stored procedures or scripts. In this article I will discuss error handling in SQL Server 2000 and SQL Server Yukon. Before starting the discussion of the error handling part, I will take you through the different components of an error

(Marcin Policht) It is finally time to complete our coverage of DTS tasks – the only remaining one that we have not presented yet is the Message Queue task. However, before we describe its features and provide an example demonstrating their use, let’s first spend some time discussing the concept of

This article describes how to upgrade a Microsoft Internet Information Services (IIS) server after the installation of Microsoft SQL Server 2000 Service Pack 3 (SP3) or Microsoft SQL Server 2000 Service Pack 3a (SP3a).

Find the tools and resources you need to achieve the highest levels of scalability using SQL Server.