When you run a query in Microsoft SQL Server 2000, you may intermittently experience an access violation error in the CQList::Remove function.

(Gregory A. Larsen) How much of your time is spent dealing with disk space management issues on your SQL Server machine? What methods do you use to identify which SQL Server databases contain lots of unused space? Do you have the space usage statistics necessary to allow you to accurately forecast t

(Baya Pavliashvili) In this new series of articles on functions, I will discuss built-in and user-defined functions in SQL Server 2000. Built-in functions provide a way to check system information and metadata or enhance the functionality of your code by manipulating the data in system and user data

RAISERROR is used to return messages back to applications using the same format as a system error or warning message generated by the SQL Server Database Engine.

(Alf Pedersen) In the day-to-day operations of running a business, employees can get caught up in more than one project, as is often the case.

When you install Microsoft SQL Server 2000 Analysis Services 32-bit on a 64-bit version of Microsoft Windows, you can take advantage of the 4 gigabyte (GB) memory space that is available in the Windows on Windows 64 (WOW64) environment.

(Nancy Michell) Is it true that once mirroring becomes available, there is no reason to use log shipping anymore? It seems that mirroring is less functional than log shipping if you want to use the mirrored database for reporting. It also seems that mirroring only allows you to query against a datab

(Jeremy Kadlec) SQL Server 2005 Profiler allows you to associate Profiler data and Performance Monitor metrics in one interface. Profiler is the native SQL Server tool used to capture SQL Server transaction performance metrics. Performance Monitor is the native tool to capture macro-level SQL Server

(Alex Kozak) Processing text or long strings in SQL has never been an easy task. SQL is a powerful language for performing fast operations on data sets, but when it comes to processing text or long strings, it’s usually reduced to a prosaic procedural language. This article shows a few techniques fo

(Teo Lachev) Since its first release, Microsoft SQL Server Reporting Services (SSRS) has supported a plethora of data sources. Out of the box, its data modules, called data extensions, allow you to build reports from SQL Server and Oracle database, as well as any other database that comes with an OL