 |
Random Sampling in T-SQL
|
| Total Hit (784) |
Imagine a company with a data warehouse that contains tens of millions of records on individuals. The analysts want to use it to do statistical analysis or data mining. Because it can be time-consuming to work with such a large number of records, analysts often select a small, random subset of recor
....Read More |
Rating
 |
|
|
|
Brief Tutorial on Text, Ntext, and Image
|
| Total Hit (1129) |
Databases are growing in size and complexity, in part because today's hardware and software allow us to store mind-boggling amounts of data—including multimedia and document data. JPG, PNG, MP3, DOC/RTF, HTML, Unicode, and XML data can all be stored as image, text, or ntext in SQL Server databases.
....Read More |
| Rating
|
|
 |
Bind Datagrid to Datareader
|
| Total Hit (1508) |
Most of times we see Datagrid Bound with Dataset but here is easy approach using Datareader
|
| Rating
|
|
 |
Data Binding in Visual Basic .NET
|
| Total Hit (1755) |
You might wonder why I didn't bind directly to the untyped DataSet. Well, the typed DataSet provides features such as early binding of fields. This enables you to use .CustomerName as a member of the DataSet instead of referencing the Items collection with the value "CustomerName," making the proces
....Read More |
| Rating
|
|
|
|
Fun With DrawImage
|
| Total Hit (1253) |
If you've ever tried to rotate an image in VB6, you know how tedious it can be. Sure, given plenty of time for trial and error, combined with some reasonably tricky mathematics and a little patience, you can figure out how to map pixels from the source image into the rotated destination image. Enter
....Read More |
| Rating
|
|
|
|
Data Extraction, Transformation, and Loading Techniques
|
| Total Hit (2291) |
Chapter 17, "Data Warehouse Design Considerations," discussed the use of dimensional modeling to design databases for data warehousing. In contrast to the complex, highly normalized, entity-relationship schemas of online transaction processing (OLTP) databases, data warehouse schemas are simple and
....Read More |
| Rating
|
|
|
|
Business Case Solutions Using MDX
|
| Total Hit (866) |
The purpose of the Multidimensional Expressions (MDX) language is to make access to multidimensional data more concise and efficient. However, because MDX reflects the natural complexity of multidimensional data structures, simple business questions may sometimes require complex MDX solutions.
....Read More |
| Rating
|
|
|
|
Log Shipping
|
| Total Hit (702) |
It is 2 PM on a record business day. The Microsoft® SQL Server™ 2000 server housing your mission-critical customer database experiences a disk failure. What do you do? When was the last known good backup? Is there another server available to restore the backup onto? Is SQL Server even on that server
....Read More |
| Rating
|
|
|
|
Failover Clustering
|
| Total Hit (746) |
Continuous uptime in a production environment, whether it is a database powering a mission-critical client/server application or an e-commerce Web site, is becoming a common businesses requirement. This chapter describes Microsoft® SQL Server™ 2000 failover clustering, one method of creating high av
....Read More |
| Rating
|
|
|
|
Replication and Microsoft SQL Server 2000
|
| Total Hit (1927) |
Data Replication is a powerful feature of SQL Server. SQL Server 7.0 provided many improvements from previous versions, and SQL Server 2000 builds on those features and adds more to increase the reliability, ease of use, and management of replication.
....Read More |
| Rating
|
|
|
|
ADO like Cursor operations using T-SQL
|
| Total Hit (1763) |
This article shows how to use SQL cursor to perform MoveFirst, MoveLast, MoveNext, MovePrev and MoveAbsolute operations using T-SQL's SCROLL CURSOR
|
| Rating
|
|
|
|
|
|
|
|
|
|
 |
HOWTO: Navigate Excel Objects from Visual Basic
|
| Total Hit (2181) |
This article explains three methods you can use to navigate and access Microsoft Excel Application objects:
«LI»Using longhand and default properties
«LI»Using aliasing
«LI»Using the Parent and Application methods of Microsoft Excel version 5.0 objects to access any Microsoft Excel object
....Read More |
| Rating
|
|
|
|
Fill in Word Forms Using Information Stored in Access
|
| Total Hit (969) |
Although Access reports are flexible and relatively easy to create, they're not always suitable for every task. For example, your company may internally use manual forms that can easily be filled with data from an existing Access database. Your natural reaction is probably to create an Access report
....Read More |
| Rating
|
|
|
|
|
|
Search Engine Optimization Tutorial
|
| Total Hit (1478) |
A few years ago, it was for the most part sufficient to incorporate a well optimized title tag and have a few relevant search terms (aka keywords) in the meta tags to get a top 10 ranking. Those days are long gone, and yet in my estimation, over 75% of webmasters still hold on to the notion that sea
....Read More |
| Rating
|
|
|
|
|
|
Data Transformation Services (DTS) in Microsoft SQL Server 2000
|
| Total Hit (676) |
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 (1085) |
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 (943) |
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
|
|
|
|
|
|
Managed UDTs Let You Extend the SQL Server Type System
|
| Total Hit (1007) |
The next version of SQL Server, code-named "Yukon," will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UDTs you can more precise
....Read More |
| Rating
|
|
|
|
XML, T-SQL, and the CLR Create a New World of Database Programming
|
| Total Hit (974) |
The next version of SQL Server, code-named "Yukon," includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined functions, stored
....Read More |
| Rating
|
|
|
|
New Version Showcases Native XML Type and Advanced Data Handling
|
| Total Hit (1169) |
The next version of Microsoft SQL Server, code-named "Yukon," represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging industry standard XQ
....Read More |
| Rating
|
|
|
|
Microsoft TerraServer
|
| Total Hit (745) |
The Microsoft® TerraServer stores aerial and satellite images of the earth in a Microsoft SQL Server™ database served to the public through the Internet. It is the world's largest atlas, combining five terabytes of image data from the United States Geodetic Survey, SOVINFORMSPUTNIK, and Encarta®
....Read More |
| Rating
|
|