|
|
 |
Finding gaps in sequential numbers.
|
| Total Hit (2819) |
A simple JOIN that will determine gaps in a set of sequential values. This query will basically give the sequence number after which a gap is present.
|
Rating
 |
|
|
|
|
|
|
|
|
|
How to implement simple transaction in SQL Server
|
| Total Hit (2157) |
Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks in the group successfully complete. If any of the tasks fails, the transaction fails. Therefore, a transaction has only two results: success or failure. Incomplete
....Read More |
| Rating
|
|
|
|
How to enable SSL encryption for SQL Server 2000
|
| Total Hit (2591) |
This step-by-step article demonstrates how to install a certificate on a computer that is running SQL Server 2000 by using Microsoft Management Console (MMC) and describes how to enable SSL Encryption at the server, or for specific clients.
«a href='http://support.microsoft.com/?id=316898'»http:/
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
Skip the execution of an individual Task
|
| Total Hit (672) |
It is easy to build a nice linear workflow path using the DTS designer, but unfortunately our processes are not always that simple. In certain circumstances you may wish to skip a task. This is where the power of workflow can be used, but unfortunately it is not available graphically through the des
....Read More |
| Rating
|
|
|
|
Read DTS and SSIS Packages Programatically.
|
| Total Hit (1375) |
Reading a DTS/SSIS programmatically helps a lot in doing impact analysis. Consider a scenario in which all the packages containing a particular table or stored procedure need to identified. Let me give another usage scenario for this. The sql native clinet provider SQLNCLI.1 is no longer supported i
....Read More |
| Rating
|
|
|
|
|
|
XML and SQL 2000 (Part 6)
|
| Total Hit (1199) |
In the previous article, I explained the meaning of the "Allow posted updategrams" and "Allow template queries" options on the Settings tab of the Virtual Directory Properties dialog box in IIS Virtual Directory Management for SQL Server tool. I also presented examples of taking advantage of these o
....Read More |
| Rating
|
|
|
|
Bulk Export Task
|
| Total Hit (675) |
The DTS Bulk Export Task was originally conceived in response to a problem with the OLE-DB provider for text files. For more details see DataPump truncates delimited fields to 255 characters. Whilst this problem can be fixed quite easily the Bulk Export Task still offers some benefits over the DataP
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 3 - DTS Designer Connections
|
| Total Hit (1959) |
In our previous article of this series, we presented a way of creating DTS packages with wizards. Despite its simplicity, this approach has some limitations, which you can overcome in two ways - by using DTS Designer or by manipulating DTS object model with programming languages, such as Visual Basi
....Read More |
| Rating
|
|
|
|
Creating packages in code – Execute SQL Task
|
| Total Hit (1656) |
The Execute SQL Task is for obvious reasons very well used, so I thought if you are building packages in code the chances are you will be using it. Using the task basic features of the task are quite straightforward, add the task and set some properties, just like any other. When you start interacti
....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
|
|
|
|
Single Database or Multiple Databases
|
| Total Hit (1334) |
Which is the way to better performance with Microsoft SQL Server 7.0: using a single database with lots and lots of tables or logically grouping data into multiple databases each with a significantly fewer number of tables? The system is comprised of one server with two hard drives that are mirrored
....Read More |
| Rating
|
|
|
|
|
|
|
|
Storage Engine Capacity Planning Tips
|
| Total Hit (1749) |
The I/O subsystem (storage engine) is a key component of any relational database management system (RDBMS). A successful RDBMS implementation requires careful planning at the early stages of the project. The storage engine comprises much of this planning, including what hardware to purchase, how to
....Read More |
| Rating
|
|
|
|
Benchmarking Performance of a Query - Part 2 CPU and I/O
|
| Total Hit (2100) |
This is the second article in a series discussing benchmarking T-SQL query performance. The first article in this series discussed different methods of capturing the elapsed time of a T-SQL batch, pieces of a batch, or a single T-SQL statement. This article will discuss how to determine the amount o
....Read More |
| Rating
|
|
|
|
Reducing SQL Server Index Fragmentation
|
| Total Hit (2678) |
When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information in the index can get scattered in the database. Fragmented data can cause
....Read More |
| Rating
|
|
|
|
|
|
|
|
Managed UDTs Let You Extend the SQL Server Type System
|
| Total Hit (1006) |
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
|
|
|
|
Open File Dialog Custom Task
|
| Total Hit (1137) |
If you run packages manually and want the ability to select a file through a GUI, this is for you. This is a simple custom task that pops up a standard windows open file dialog box when executed. It assigns the chosen filename to a global variable for use within the package.
....Read More |
| Rating
|
|
|
|