 |
Locking in SQL Server 7.0
|
| Total Hit (1818) |
In this article, I want to tell you about general details of SQL Server 7.0 locking, about Transaction Isolation Levels, what kind of Transaction Isolation Level exists, and how you can set the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hints, about Lock Escalati
....Read More |
Rating
 |
|
|
|
|
|
Introduction to Database Replication
|
| Total Hit (746) |
As it relates to SQL Server, replication is a way of keeping data synchronized in multiple databases. Implementing and maintaining replication might not be a simple proposition: If you have numerous database servers that need to be involved in various types of replication, a simple task can quickly
....Read More |
| Rating
|
|
|
|
|
|
Setting Up Snapshot Replication: A Step-by-step Guide
|
| Total Hit (740) |
In this article, I want to tell you about some general Microsoft SQL Server replication topics: replication topologies, replication types, and replication agents. I will also discuss Snapshot replication: how to check necessary conditions for this type of replication and how to backup and restore th
....Read More |
| Rating
|
|
|
|
Setting Up Snapshot Replication: A Step-by-step Guide
|
| Total Hit (657) |
In this article, I want to tell you about some general Microsoft SQL Server replication topics: replication topologies, replication types, and replication agents. I will also discuss Snapshot replication: how to check necessary conditions for this type of replication and how to backup and restore th
....Read More |
| Rating
|
|
|
|
Setting Up Merge Replication: A Step-by-step Guide
|
| Total Hit (730) |
In this article, I want to tell you about some general Microsoft SQL Server replication's topics: replication topologies, replication types, and replication agents. I will also discuss Merge replication: how to check necessary conditions for this type of replication and how to backup and restore the
....Read More |
| Rating
|
|
|
|
Data Validation for Merge Replication
|
| Total Hit (624) |
Microsoft SQL Server 7.0/2000 allows you to validate data for merge replication. You can specify rowcount only validation or rowcount and checksum validation of the article's data.
When you choose rowcount only validation, then SQL Server calculates a rowcount at the publisher level, then compares
....Read More |
| Rating
|
|
|
|
Working with COM Objects from within T-SQL
|
| Total Hit (2218) |
In this article I want to tell you about how you can work with COM objects from within Transact SQL. You can use OLE Automation Stored Procedures (extended stored procedures with sp_OA prefix) to create a COM object in T-SQL and use that object's methods and properties.
Introduction
General co
....Read More |
| Rating
|
|
|
|
Divide and Conquer - Batching Part 1
|
| Total Hit (670) |
There are many queries and processes that a DBA may perform on an SQL Server that run quickly and efficiently with small amounts of data, but do not scale up when run on large sets of data. The power behind a RDBMS and SQL Server come from the extremely efficient and rapid processing of sets of data
....Read More |
| Rating
|
|
|
|
Dealing with a SQL Server Cluster Failover
|
| Total Hit (539) |
I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived about 30 minutes earlier
....Read More |
| Rating
|
|
|
|
Linking SQL Server to Heterogeneous Systems
|
| Total Hit (1971) |
The ability to link SQL Server to heterogeneous systems such as Oracle, DB2, Sybase, etc., is imminent. This article provides the basic and most important information required to make a linked server connection to heterogeneous systems from SQL Server. We are going to deal with three different RBBMS
....Read More |
| Rating
|
|
|
|
Using DTS to Detect and Process a File
|
| Total Hit (1072) |
There is nothing better than when a new technology lends itself to solving an old problem; well, there may be some things better, but this will have to do for now. One of the classic problems in computing -- classic being defined as a problem I have seen before -- is processing files that were uploa
....Read More |
| Rating
|
|
|
|
Linked Servers : An overview
|
| Total Hit (1948) |
Linked servers provide connectivity to external data sources, allowing you to access data and run procedures in SQL Server other than the one you are currently running on.
|
| Rating
|
|
|
|
|
|
|
|
Using SQL Server Cursors
|
| Total Hit (936) |
In this article, I want to tell you how to create and use server side cursors and how you can optimize a cursor performance.
Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in t
....Read More |
| Rating
|
|
|
|
|
|
OLAP and Data Warehousing - Data in Jail
|
| Total Hit (1618) |
Please find below the follow-up to the first part in my OLAP and Data Warehousing (The Problem and Solution) series, a series dedicated to the discussion of OLAP and Data Warehousing technologies.
A lack of world economic stabilization over the last few years has resulted in a growth of competit
....Read More |
| Rating
|
|
|
|
|
|
|
|
Using a Script to Kill Processes in SQL
|
| Total Hit (1111) |
Backing up and restoring databases is part of every administrator's job. While performing backups, a number of methods can be used to save time. If a database needs to be moved from one server to another, a backup on one server and a restore on another server is a great method. Some projects require
....Read More |
| Rating
|
|
|
|
Disabling or Enabling All Constraints of a Table or Database
|
| Total Hit (1188) |
These procedures are very important to use when you need to load a bulk of data that you know is correct but when you do not need the foreign keys and check constraints to interfere while you are loading the data. This is also the case when you want to change key values and don't want the constraint
....Read More |
| Rating
|
|
|
|
|
|
Setting Up Full Text Search: A Step-by-step Guide
|
| Total Hit (1835) |
In this article, I want to tell you about some general full-text search concepts, including software requirements, the Microsoft Search Service, maintaining full-text indexes, the comparison of full-text indexes with regular SQL indexes, and how to set up full-text search step by step.
....Read More |
| Rating
|
|
|
|
|
|
MDX at First Glance: Introduction to SQL Server MDX Essentials
|
| Total Hit (1374) |
To get the most out of the MDX Essentials series, we need to have installed at least the Analysis Services component of MSSQL Server 2000. While the full installation of SQL Server 2000 allows for virtually any exercise we might undertake, the majority of our sessions center on Analysis Services, th
....Read More |
| Rating
|
|
|
|
Using and Building Query Analyzer Templates
|
| Total Hit (703) |
The Query Analyzer (QA) in SQL Server 2000 is greatly enhanced over the QA in SQL Server 7.0. One of the enhancements, QA templates, can increase your productivity in developing code.
QA comes with over fifty canned templates that you can use. Although these templates are useful as they are insta
....Read More |
| Rating
|
|
|
|
MDX Essentials: Structure of the MDX Data Model
|
| Total Hit (652) |
This is the second article of the series, MDX Essentials. The primary focus of this series will be an introduction to the MDX language. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively addi
....Read More |
| Rating
|
|
|
|
Introducing the SQL Server 'MDX in Analysis Services' Series
|
| Total Hit (625) |
This is the first tutorial of a new series, MDX in Analysis Services, that I hope will help new users get up to speed quickly with multidimensional expressions (MDX). The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis
....Read More |
| Rating
|
|