When you use a loopback linked server to run a distributed query in Microsoft SQL Server 2000, you may receive error messages that are similar to the following: Server: Msg 8651, Level 17, State 1, Line 1 Could not perform the requested operation because the minimum query memory is not available.

(William Pearson) As I have shown in many past articles, the Microsoft Integrated BI Solution, consisting of the MSSQL Server 2005 Database Engine, Analysis Services 2005 and Reporting Services 2005, provides unprecedented flexibility in helping implementers and developers to meet client and employe

(Scott Lowe) Monitoring your servers and network can run from cheap to way-too-expensive-to-bother, and it can run from simple to way-too-hard-to-care. Unfortunately, as the profile of Information Technology is raised and systems become more integrated, it’s critical to be able to provide some sembl

(John Fuex) Something you see in a lot of database access code is a select statement that looks something like this: SELECT * FROM TableName WHERE …

(Yashwant Shukla) I was working on a Web Application in which client requested to keep backup of the Application DataBase in the Form of Access data in a MDB file for that i tried DTS package but the Database Server for application was kept on remote server where the host was not ready to provide ri

(Srinivas Sampath) Service Broker is the new kid in the block in SQL Server 2005. Before we actually delve into the features of Service Broker and write our first program, let us first imagine a scenario where we would want to fit Service Broker and then work off that.

(Erland Sommarskog) When designing an application for SQL Server, you rarely want users to have full permissions to access the tables in the database. Many applications are designed to perform all database access through stored procedures, and it is through the stored procedures users can access and

This topic describes the changes in behavior of some Database Engine features in Microsoft SQL Server 2005 from their behavior in earlier versions of SQL Server.

Nagendra Rao) Data Mining is an analytic process designed to explore data (usually large amounts of data – typically business or market related) in search of consistent patterns and/or systematic relationships between variables, and then to validate the findings by applying the detected patterns to

(Baya Pavliashvili) The first article in this series introduced you to steps involved in building a data warehouse. It also presented an example scenario of solving business problems with a data warehouse. This article continues exploring challenges involved in building and maintaining a warehousing