(Kevin Kline and Claudia Fernandez) This paper covers the basic techniques used to tune SELECT statements on Microsoft’s SQL Server 2000 relational database management system. We discuss the techniques available using Microsoft’s graphical user interfaces provided in Microsoft SQL Enterprise Manage

(Leo Peysakhovich) One of our clients gave us requirements that an XML file was supposed to be FTP’d to the client when a new record appeared or an old one is changed in a table. This is simple process, nothing new. The business front end application was created, tested, and distributed to p

(S.A. Miller) If you’re like me, you’ve probably spent a lot of time developing your code in Query Analyzer. Once you’re happy with the code, you run an ad hoc test or two on a test database on a development server. If that looks okay, you put the code into production. If it’s a critical piece o

(William Pearson) As we discuss in my article MDX Essentials: Logical Functions: The IsEmpty() Function in working with multidimensional data sets, we are often confronted with empty cells – data is often sparse in these sets by their very physical nature. Because, as a simple example, every product

(Tony Patton) Maintaining data between server calls is a common dilemma in Web development. You may need to maintain information for the application or for particular user sessions. Storing such data is called state management, and ASP.NET provides the means to accomplish the task via various av

(Mike Pearson) SSW SQL Auditor is an extremely useful tool which allows developers to generate reports on design issues and areas where SQL performance could be improved. It does this by checking the database design against common SQL Server design rules and report on the elements that do not confor

(Muthusamy Anantha Kumar) In part I of this article, we discussed how to compare the query results executed on two different servers. In part II, we are going to discuss how to compare results of the same query on the same or different server but on different databases. This article takes advant

DB Best provided AIM Healthcare with the DB Best SQL Converter plus critical consulting services to quickly and cost-effectively migrate their claims-processing database from Oracle to Microsoft SQL Server. This enabled AIM Healthcare to significantly increase the capacity of their claims proces

(William E. Pearson, III) Because a significant part of my practice consists of being called upon to tune MSAS implementations performed by others, I come across the less-than-optimal use of calculated members quite often. As most of us know, calculated members are dimensions or measures (depending

(Subhan P. Munshi) This sp can compare two tables with the same structure. (script)