 |
Export SQL data to XML File (3 different ways)
|
| Total Hit (13370) |
Many times we need to export sql server data to some form of XML. As we know that SQL Server can output data in XML format when you use "FOR XML" clause. You can use ADO and MSXML along with "FOR XML" sql query to generate XML files from SQL Server data. The following script is pure VB Script so if
....Read More |
Rating
 |
|
|
|
|
|
Cursors: An Overview
|
| Total Hit (1125) |
We'll talk about the basics of cursors. These let you move through records one at a time and perform processing on each record.
|
Rating
 |
|
|
|
Data Warehousing for Cavemen
|
| Total Hit (2012) |
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 (1902) |
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 (1907) |
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 (794) |
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 (1615) |
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 (1749) |
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 (2621) |
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 (1386) |
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 (1768) |
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 (1708) |
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 (1626) |
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
|
|
|
|
|
|
|
|
Data Transformation Services (DTS) in Microsoft SQL Server 2000
|
| Total Hit (675) |
Database administrators often import, export, and transform data in support of tasks such as data consolidation, archiving, and analysis; for application development purposes; and for database or server upgrades. Data Transformation Services (DTS) in SQL Server 2000 provides a set of graphical tools
....Read More |
| Rating
|
|
|
|
Overview of Native XML Web Services for Microsoft SQL Server 2005
|
| Total Hit (1083) |
Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.
....Read More |
| Rating
|
|
|
|
|
|
|
|
SQL Server "Yukon" Beta 1 Transact-SQL Enhancements
|
| Total Hit (940) |
This white paper introduces several of the new enhancements to Transact-SQL in Microsoft SQL Server "Yukon" Beta 1. These new features can increase your expressive power, the performance of your queries, and your error management capabilities. This paper focuses mainly on relational enhancements tha
....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
|
|
|
|
|
|
|
|
|
|
SQL Server API Server Cursors
|
| Total Hit (815) |
Defines the attributes of an API server cursor, such as its scrolling behavior and the statement used to build the result set on which the cursor operates, then populates the cursor. The statement can contain embedded parameters.
|
| Rating
|
|
|
|
Importing XML into SQL Server 2000
|
| Total Hit (2359) |
One of the frequently asked questions on SQL Server newsgroups is "How to import XML data into SQL Server 2000?" There are various ways in which XML data can be imported into SQL Server 2000 database tables. In this article, we'll look at some of these options. More specifically, we'll explore the f
....Read More |
| Rating
|
|
|
|
Exporting SQL Data as XML
|
| Total Hit (3228) |
In my last article, Importing XML into SQL Server 2000, we looked at various techniques to import the XML data into SQL Server. To complement that, this article will focus on some of the methods that you can use to export relational SQL data to the XML format.
More specifically, we'll explore th
....Read More |
| Rating
|
|