 |
ASP Including Files
|
| Total Hit (1089) |
You can insert the content of one ASP file into another ASP file before the server executes it, with the #include directive. The #include directive is used to create functions, headers, footers, or elements that will be reused on multiple pages.
|
Rating
 |
|
 |
Data Warehousing for Cavemen
|
| Total Hit (2013) |
This document is intended to make you buzzword-compliant with the MIS world. In terms simple enough even for an MIT computer science Ph.D. to understand, I'm going to explain OLTP, data warehousing, and OLAP. Kiss that ghetto post-doc goodbye and watch big companies line up to pay you $300/hour to r
....Read More |
| Rating
|
|
|
|
Textual Searches on Database Data
|
| Total Hit (1904) |
This chapter describes support for textual queries against data within SQL Server tables. The full-text search concepts are introduced, followed by the form that a full-text search takes and the information that can be retrieved by means of such queries. The internal design and architecture of the f
....Read More |
| Rating
|
|
|
|
Textual Searches on File Data
|
| Total Hit (1908) |
This chapter introduces the types of textual searches supported by SQL Server and illustrates the roles performed by both the IIS and Index Services technologies. It also introduces SQL Server distributed queries and describes their use in the processing of textual searches. It then addresses the qu
....Read More |
| Rating
|
|
|
|
Developing with English Query
|
| Total Hit (796) |
It is easy enough to build a query form that allows users to search based on one or two fields, but it is much more difficult to build form-based Web pages that allow searches across multiple tables and multiple fields. A more flexible search is difficult to implement (there are many problems beyond
....Read More |
| Rating
|
|
|
|
Data Warehousing Framework
|
| Total Hit (1617) |
Making better business decisions quickly is the key to succeeding in today's competitive marketplace. Organizations seeking to improve their decision-making ability can be overwhelmed by the sheer volume and complexity of data available from their varied operational and production systems. In respon
....Read More |
| Rating
|
|
|
|
Storage Engine Capacity Planning Tips
|
| Total Hit (1750) |
The I/O subsystem (storage engine) is a key component of any relational database management system (RDBMS). A successful RDBMS implementation requires careful planning at the early stages of the project. The storage engine comprises much of this planning, including what hardware to purchase, how to
....Read More |
| Rating
|
|
|
|
Backup and Recovery
|
| Total Hit (2623) |
You should back up your databases and transaction logs on a regular basis. In case of system problems, you can restore the backed up files and return to work more quickly than if you had neglected to back up your database. Additionally, every time Microsoft SQL Server starts, recovery is performed o
....Read More |
| Rating
|
|
|
|
MDX Sets
|
| Total Hit (1387) |
In this chapter, you’ll learn MDX query terminology and how to
«LI»Use the MDX Sample application to enter queries.
«LI»Use set functions.
«LI»Create sets by using member constants.
«LI»Create calculated members that aggregate sets of values.
....Read More |
| Rating
|
|
|
|
RDBMS Performance Tuning Guide for Data Warehousing
|
| Total Hit (1769) |
This performance tuning guide is designed to help database administrators and developers configure Microsoft® SQL Server™ 2000 for maximum performance and to assist in determining causes of poor performance of relational databases, including those used in data warehousing. It also provides guideline
....Read More |
| Rating
|
|
|
|
Cubes in the Real World
|
| Total Hit (1709) |
Microsoft® SQL Server™ 2000 Analysis Services offers myriad options for creating cubes, and the flexibility and power to support almost any business case. This chapter presents practical guidelines for designing cubes and dimensions, design fundamentals, and other considerations
....Read More |
| Rating
|
|
|
|
Using Partitions in a SQL Server 2000 Data Warehouse
|
| Total Hit (1629) |
This chapter discusses the role of partitioning data in the data warehouse. The relational data warehouse and Microsoft® SQL Server™ 2000 Analysis Services cubes both support the partitioning of data. The logical concept behind partitioning is the same in both engines of SQL Server: to horizontally
....Read More |
| Rating
|
|
|
|
Introduction to Data Mining with SQL Server
|
| Total Hit (2766) |
In order to fully comprehend, much less implement enhanced Decision Support Systems in an organization, it is necessary to understand the basic precepts behind the requirements, methodologies and business drive to obtain information. Information about an organization gathered from various sources an
....Read More |
| Rating
|
|
|
|
Data Warehouse Design Considerations - 1
|
| Total Hit (1441) |
Data warehousing is one of the more powerful tools available to support a business enterprise. Learn how to design and implement a data warehouse database with Microsoft SQL Server 2000.
|
| Rating
|
|
|
|
|
|
 |
Using Session and Application Objects in ASP .NET
|
| Total Hit (798) |
The Web Forms model is the Web adaptation of the traditional Visual Basic® form-based interaction model. In this model, user activity produces input for processing modules that can reside either locally or remotely. In Visual Basic-based applications, the input is processed synchronously and with fu
....Read More |
| Rating
|
|
|
|
 |
Safe, Simple Multithreading in Windows Forms, Part 1
|
| Total Hit (1062) |
It all started innocently enough. I found myself needing to calculate the area of a circle for the first time in .NET. This called, of course, for an accurate representation of pi. System.Math.PI is handy, but since it only provides 20 digits of precision, I was worried about the accuracy of my calc
....Read More |
| Rating
|
|
|
|
Safe, Simple Multithreading in Windows Forms, Part 2
|
| Total Hit (1086) |
Explores how to leverage multiple threads to split the user interface (UI) from a long-running operation while communicating further user input to the worker thread to adjust its behavior, thus allowing a message-passing scheme for robust, correct multithreaded processing.
....Read More |
| Rating
|
|
|
|
Powerful New T-SQL Syntax Gives SQL Server a Programmability Boost
|
| Total Hit (2382) |
The T-SQL language in the upcoming version of SQL Server will provide more power and flexibility than previous versions. Additions and enhancements include error handling with the TRY/CATCH construct, SNAPSHOT isolation, and WAITFOR enhancements. Also important are the BULK rowset provider, common t
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|