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)

Database Mirroring Automating Failover for Multiple SQL Server Databases With No Witness     
Total Hits: 134  |  Today: 0Author: Edwin Sarmiento      Rating:  
Read Reviews | Write Review |  Your Rating: 

In a previous tip on Database Mirroring Automating Failover for Multiple SQL Server Databases, you've seen how you can failover all of the databases in a mirroring session if one database fails over. However, what happens if you don't have a witness server and your principal server goes, how do you make your mirror server the principal and bring all your databases online?...

Setting Date Format in SQL Server     
Total Hits: 132  |  Today: 0Author: sri sri      Rating:  
Read Reviews | Write Review |  Your Rating: 

Try the below SQL command to find the default language setting and date format used. select name ,alias, dateformat from syslanguages where langid = (select value from master..sysconfigures where comment = 'default language') the Result will be as name alias dateformat ----------- ----------- ---------- us_english English mdy...

Methods for Moving a Database     
Total Hits: 319  |  Today: 0Author: Ron Talmage      Rating:  
Read Reviews | Write Review |  Your Rating: 

Moving a SQL Server database from one server to another is simple-initially. But there are various methods for moving a database, and some have more advantages than others. Investigating the types of moves ahead of time can make planning for a database migration easier.

It takes essentially three steps to move a database from one server to another: take the database out of production, copy it to another server, and then bring the copy back into production. While you can choose from many m...

Bitmaps in Microsoft SQL Server 2000     
Total Hits: 96  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server has been using bitmaps internally to speed up query execution since version 7.0. With the introduction of new operators in SQL Server 2000, further bitmap filtering techniques can now be applied for even faster query results from large data sets....

Diagnosing and Troubleshooting Slow Partitioned Merge Processes     
Total Hits: 84  |  Today: 0Author: Dean Kalanquin      Rating:  
Read Reviews | Write Review |  Your Rating: 

Learn how to achieve scalable, high-performance merge replication applications.
A merge replication application must not only provide the functionality required by the business rules of the application, but also complete its operations in a timely manner, even if the volume of data and the number of users increase over time.
Because merge replication is implemented through tables and queries in Microsoft® SQL Server™ 2000, performance depends on how efficiently SQL Server handles the proc...

Improving Performance with SQL Server 2000 Indexed Views     
Total Hits: 92  |  Today: 0Author: Gail Erickson      Rating:  
Read Reviews | Write Review |  Your Rating: 

This document describes the new indexed views capability of SQL Server 2000 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.For many years, Microsoft® SQL Server™ has supported the ability to create virtual tables known as views. Historically, these views served two main purposes:
To provide a security mechanism that restricts users to a certain subset of data in one or more base tables.
To provide a ...

Use data cubes for efficient data warehousing in SQL Server 2000     
Total Hits: 830  |  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: 626  |  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...

Eliminate the Use of Temporary Tables For HUGE Performance Gain     
Total Hits: 262  |  Today: 0Author: Justin Gunther      Rating:  
Read Reviews | Write Review |  Your Rating: 

As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM clause of a SELECT statement. By using derived tables instead of temporary tables, we can boost our application's performance....

How to Perform a SQL Server Performance Audit      
Total Hits: 684  |  Today: 0Author: Brad M. McGehee      Rating:  
Read Reviews | Write Review |  Your Rating: 

Quantitative models for the SQL Server internal query cost formulas and the true measured query costs for basic SQL operations are presented. The internal cost formulas are used by SQL Server's Query Optimizer to determine the execution plan based on existing indexes and statistical information on the distribution of data....

SQL Server database coding conventions, programming guidelines and best practices     
Total Hits: 634  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article helps ASP and database developers write top-notch T-SQL code for building robust SQL Server based applications...

Data Mining For Database Developers - 1Rule     
Total Hits: 927  |  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....

SQL Injection Attacks: Are You Safe?     
Total Hits: 520  |  Today: 0Author: Mitchell Harper      Rating:  
Read Reviews | Write Review |  Your Rating: 

Is your database safe from SQL injection attacks? In this article Mitchell tells us exactly what they are and shows us how to prevent them from occuring....

HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object (Q258038)     
Total Hits: 4400  |  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...

Total Hits: 274  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This procedure will Analyze & Estimate Statistics for all tables in the users schema. Only takes 3-10 minutes to run. It can easily be edited to Compute Statistics or specific number of rows in each table....

SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK     
Total Hits: 634  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Relational databases like Microsoft's SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data and relinquishes the lock. There are exceptions, but let's not go there....

UUse SET STATISTICS IO and SET STATISTICS TIME to Help Tune Your SQL Server Queries     
Total Hits: 616  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is not an article on how to tune queries (that subject would take a book), but an article on how to use the often overlooked Transact-SQL SET STATISTICS IO and the SET STATISTICS TIME commands to help us tune our queries.

The Data Mining Cluster Analysis Algorithm     
Total Hits: 1008  |  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: 1407  |  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: 697  |  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