 |
Locking in SQL Server 7.0
|
| Total Hit (1881) |
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 (770) |
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 (772) |
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 (682) |
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 (758) |
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 (648) |
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 (2290) |
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 (697) |
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
|
|
|
|
DTS How to...Skip Rows during Import
|
| Total Hit (890) |
Firstly you can skip header rows by using the First Row property of the DataPump Task, see Advanced properties sheet. The Text File Connection also has a Skip Rows property, see file Properties of the Connection.
|
| Rating
|
|
|
|
|
|
DTS How to...Transfer Packages between Servers
|
| Total Hit (1103) |
There are two ways to transfer packages between servers. The simple method is to save packages as COM Structured Storage Files, copy them to the new location, then open and save them to the new server. Whilst this works, it is very tedious when you have a lot of packages. You can automate much of th
....Read More |
| Rating
|
|
|
|
DTS Errors
|
| Total Hit (1079) |
«LI»"Could not create component categories manager" Or "Could not create an instance of the DTS package"
«LI»"DTS WIZARD ERROR: CoCreateInstance - Class not Registered"
«LI»"The parameter is incorrect" Or "Invalid class string" Or "The system cannot find the file specified"
«LI»"The license fo
....Read More |
| Rating
|
|
|
|
|
|
|
|
Using SQL Server Cursors
|
| Total Hit (961) |
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 (1659) |
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 (1150) |
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 (1249) |
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 (1892) |
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 (1425) |
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 (726) |
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 (688) |
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 (658) |
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
|
|