(Paresh Goyal) A Key ShortCut for ‘SELECT * FROM’ for tables and to see text of the stored procedures.

When you run a query or a stored procedure in SQL Server 2000, you may receive an error message that resembles the following: Server: Msg 8624, Level 16, State 1, Line 1 Internal SQL Server error

(William Pearson) The advent of MSSQL Server Analysis Services 2005 witnessed the introduction of many new concepts within a dramatically more sophisticated design environment. Measure Groups represent one of myriad enhancements that we encounter early in exploring and implementing Analysis Services

(Greg Robidoux) The name of the game is I/O throughput. Running backup and restore sessions is one of the most I/O intensive activities you will perform on your SQL Server. That’s because when you run a backup and/or restore you are reading the entire contents of the database and then writing the en

When you run a complex query against Microsoft SQL Server 2000, the SQL Server database crashes. Additionally, you receive an error message that resembles the following: Date Time server Error: 17883 Severity: 1, State: 0 Date Time server Process 52:0 (94c) UMS Context 0x121A9C98 appears to be n

Address Windowing Extensions (AWE) allow 32-bit operating systems to access large amounts of memory. AWE is exposed by the operating system, and is implemented with slight differences in Microsoft Windows 2000 Server and Windows Server 2003. AWE is enabled using the awe enabled Option.

(Marcin Policht) In our previous article of this series, we discussed transactional support in SQL Server 2005 Integration Services. Such support is critical in order to ensure that arbitrarily designated Control Flow tasks are executed as a single logical unit, which either completes successfully o

This HP white paper describes the evolution of data warehousing systems and explains how standards-based, object-oriented programming has improved the newest generation of Business Intelligence (BI) software. The paper outlines key differences between components-based and integrated approaches to BI

CASE statements are very useful for categorizing data in SQL Server queries.

(Sivakumar Mahalingam) Most of the time, it is acceptable for customers to deploy reports manually via the Visual Studio Report Manager. But sometimes, there may be a hard rule that “anything deployable, for instance, WinForms apps, WebForms apps, or SSRS reports, etc. has to be deployed via MSI.