When you run a Multidimensional Expressions (MDX) query that uses formulas or recursions, a memory leak may occur. The memory leak may occur in the handle thread in the Msolap80.dll component file or in the Microsoft SQL Server 2000 Analysis Services Msmdsrv.exe process. The memory leak may use all
Author: SSWUG Research
MS SQL Server script validation with NAnt Task
(Stefan Fork) The ScriptValidatorTask is a NAnt task to validate Microsoft SQL Server scripts like procedures, functions, simple statements, and views. It uses the NOEXEC option of the SQL Server to validate the scripts.
Optimize string manipulation performance with VB.NET’s StringBuilder
(Irina Medvinskaya) There are a number of string manipulation techniques that let you optimize code for better performance. StringBuilder allows you to perform repeated string manipulation, resulting in better performance than manual manipulation. In this tip, I look at utilizing StringBuilder in VB
Multithreading made easy in .NET 2.0
(Alex Lehmberg) The code in this article demonstrates an alternative way to do multithreaded programming using .NET 2.0 and a freely available library called CSP.NET. The application presented is meant to introduce the programmer to the most basic elements of CSP.NET. It is a console application tha
ASP.NET 2.0: Is It Really This Easy?
(Alex Homer and David Sussman) To give you a feel for the way all the new features of ASP.NET 2.0 combine to provide the overall development experience, this chapter presents a scenario-based demonstration focused on a day in the life of a developer who is in the process of fulfilling the requiremen
What’s New for Developers in Visio 2007 (Part 1 of 2)
(Saul Candib) This article introduces new features of interest to developers in Microsoft Office Visio 2007 and explains how to use them. What’s New for Developers in Visio 2007 (Part 2 of 2) describes all the new objects and members of the Visio VBA object model, and newly deprecated existing membe
Mini-tip #7: Quick Access to Oracle Documentation
(Lewis R Cunningham) Have you ever needed to lookup something for Oracle 8.1.7 and couldn’t find the documentation? Ever want to compare features between two Oracle versions? Go to Tahiti!
The ultimate mashup — Web services and the semantic Web, Part 2: Manage a mashup data cache
(Nicholas Chase and Tracy Peterson) The many massive applications that you use day to day for search, online shopping or to find your way around town provide data for your use in a completely new application. Enterprising application developers have created many mashup applications to coax a specifi
Working with MySQL Result Sets and the Decorator Pattern in PHP
(Alejandro Gervasio) If you’re one of those avid PHP developers who wants to learn how to apply the decorator design pattern within your Web applications, then this group of articles might be quite appealing to you. Welcome to the second part of the series “Using the Decorator pattern with PHP.” Com
Siebel users rate year under Oracle
(Arif Mohamed) Most Siebel users in the UK have seen no difference in the level of service they have received since the CRM supplier was acquired by Oracle a year ago. However, 17% have reported a decline in service levels.