Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
SQL Server

FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home >Search > SQL
What's New - What's Hot
Listings for Applications Applications (161)
Listings for Articles & Samples Articles & Samples (5027)
Listings for Bugs and Fixes Bugs and Fixes (94)
Listings for Developer Sites Developer Sites (13)
Listings for Downloads Downloads (54)
Listings for Introduction Introduction (29)
Listings for Knowledge Base Knowledge Base (289)
Listings for Sample Chapters Sample Chapters (24)
Listings for Training Training (23)
Listings for WebCasts WebCasts (21)

Microsoft's Contribution to the Data Warehousing Industry     
Total Hits: 137  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Data warehousing has become one of the most dynamic, interesting, and fast-growing segments of the information technology industry. Microsoft Corporation is contributing to the rapid growth of data warehousing for decision support. A combination of products from Microsoft, and from an alliance of independent software and service providers, enables customers to operate powerful, yet affordable, data warehouse systems. Microsoft® SQL Server™ database, implemented as a data warehouse storage engine...

The Microsoft Data Warehousing Strategy     
Total Hits: 136  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Making better business decisions quickly is the key to succeeding in today's competitive marketplace. Understandably, organizations seeking to improve their decision-making can be overwhelmed by the sheer volume and complexity of data available from their varied operational and production systems. Making this data available to a wide audience of business users is one of the most significant challenges for today's information technology professionals. In response, many organizations choose to bui...

Database Storage with SQL Server – Part I     
Total Hits: 240  |  Today: 0Author: extremeexperts      Rating:  
Read Reviews | Write Review |  Your Rating: 

Database storage is one of the primary failure point in the database environment. Hence, making the storage architecture consistent and at the same time giving it maximum redundancy must be embedded within the design itself. When I call redundancy, I don’t specifically say implementing anything specific to RAID or SAN or other mechanisms. Redundancy must be achieved given your hardware and budget currently in hand – if it even means making just multiple backup copies at the simplest level....

MySQL Data Loading with Lookup Tables     
Total Hits: 180  |  Today: 0Author: Ernest Bonat      Rating:  
Read Reviews | Write Review |  Your Rating: 

Lookup tables contain, in general, a fixed list of data. This data doesn’t change very often in database business applications. Examples of this data could be a product list, category type, supplier list, state name, zip code, phone area code, etc. In Windows and Internet web business applications, most of these lookup tables are graphically implemented by using ComboBox, ListBox or CheckListBox read-only controls. These controls are loaded with data using two main columns, ID and Name. For exam...

Automating Database maintenance in SQL 2005 Express Edition Part I     
Total Hits: 233  |  Today: 0Author: Jasper Smith      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this series of articles, I'll demonstrate a couple of different approaches to writing a maintenance utility that mimics some of the behavior of the sqlmaint utility that is included with SQL Server 2000. SQL Server 2005 Express Edition does not include such a utility, so these articles will show how we can easily create one ourselves using either TSQL or SMO (SQL Management Objects - the successor to SQL-DMO). Rather than dive into the code, these articles will demonstrate how to use these ut...

Database Restore Verification     
Total Hits: 427  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have over night processes on a few different SQL Servers in my environment that are backup and restore related. I have used the scripts on to check if the SQL Server Agent Jobs\Job Steps have run as well as the backup verification code. Some of the backup and restore processes I have written and others I have inherited. Some of the processes seem to be very reliable and others are not. I need a way to validate the restore processes have completed properly just like the SQL Se...

Use data cubes for efficient data warehousing in SQL Server 2000     
Total Hits: 825  |  Today: 0Author: Scott Robinson      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the first part of this data warehousing series, I noted the structure of database storage for a data warehouse is very different from that of a conventional online transaction processing system (OLTP). The reason? OLTPs have many users and typically handle distinct data objects in any given session, whereas online analytical processing systems (OLAP) have fewer users pulling in much larger amounts of data. Therefore, from a design standpoint, it’s important to create structures that put relat...

Dimensional Databases: Building A Data Warehouse     
Total Hits: 621  |  Today: 0Author: Baya Pavliashvili.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Building a data warehouse involves several complicated steps (some of which I described in my previous articles for InformIT). After the data warehousing architect locates all data elements necessary to support the data warehouse, it is time to build a dimensional model. As data change in transactional systems, the data warehouse needs to have a way of tracking and reflecting such changes. Populating fact and dimension tables can take considerable amount of time if the population routines aren't...

Exploring Yukon T-SQL - Top Option     
Total Hits: 209  |  Today: 0Author:      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are tons of new features that are getting introduced in the next version of SQL Server codenamed Yukon. And this is the first in the series of articles, I would explore T-SQL enhancements we are presented with this new version. In this article we will explore how the TOP operator on SQL Server has been enhanced. There are significant enhancements we can observe while using this operator....

User-Defined string Functions Transact-SQL     
Total Hits: 398  |  Today: 0Author: Igor Nikiforov      Rating:  
Read Reviews | Write Review |  Your Rating: 

In my humble opinion, it will be convinient to apply such functions for writing of stored procedures and User-Defined Functions on Transact-SQL....

Take Advantage of New T-SQL Features     
Total Hits: 261  |  Today: 0Author: Roger Jennings      Rating:  
Read Reviews | Write Review |  Your Rating: 

New T-SQL keywords implement TRY...CATCH error handling, pivot aggregate values to create crosstab tables, rank and partition rowsets, generate temporary in-memory tables with common table expressions, and more....

Easy SQL Help (Update)     
Total Hits: 1302  |  Today: 0Author: LoudASP      Rating:  
Read Reviews | Write Review |  Your Rating: 

A down to earth easy to understand way on how to use and create an SQL update statment. This doc was written for the novice and advance programmer....

Using SQL To Query And Return Search Results     
Total Hits: 2416  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When the form is sent (to the same page actually), we open a Recordset using SQL to select the record whose values in the lookup fields (UserEmail and Password) equally match the given strings....

Inserting Text in Sql Server     
Total Hits: 967  |  Today: 0Author: Robbe & Melisa Morris      Rating:  
Read Reviews | Write Review |  Your Rating: 

Problem occurs when you try to insert something like this " hello world's ". Because you are trying to insert (') in the string, because sql server interpret it as a termination of string. Try to insert "hello's world's" ,you won't be having any problem....

Transact-SQL Optimization Tips      
Total Hits: 1728  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Here are fourteen little known tips that you can use to ensure your Transact-SQL queries are performing in the most efficient manner possible....

Data Mining For Database Developers - 1Rule     
Total Hits: 922  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A Data Mining application for Relational Databases (RDBMS) including Microsoft® Access®, Microsoft SQL Server® , Oracle® and Sybase ® databases. The attached articles in HTML and Microsoft Word gives a detailed step by step guide to the development of a Data Mining application....

HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object (Q258038)     
Total Hits: 4395  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This arti...

The Data Mining Cluster Analysis Algorithm     
Total Hits: 1002  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The goal of clustering is to divide the data set in predetermined ("K") number of clusters around the average locations ("means"), so the algorithm is also known as the K-Means algorithm. Like other techniques it is applied mostly on people, to discover hidden grouping that can't be noticed at the first glimpse....

OLAP Services: Managing Slowly Changing Dimensions     
Total Hits: 1401  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article outlines several main types of slowly changing dimensions. After showing how an online analytical processing (OLAP) server operates when reading dimension members, the article then offers ways to handle these and other real-world scenarios using Microsoft® SQL Server™ OLAP Services....

Implementing Data Quality Through Meta Data     
Total Hits: 691  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Data Quality is as important as data integrity for most every application. This article examines how data quality can be improved in a data warehouse through the use of Meta Data.

Disclaimer - Privacy
© 2002-2014