|
|
SQL Server Replication from 6.5 to 2000
These are the steps needed to successfully establish transactional replication from SQL Server 6.5 to 2000. They has been tested and are known to successfully work. This article assumes you have some previous experience with SQL Server replication |
| http://www.sql-server-performance.com/tp_replication.asp |
 |
 |
Hits:30 |
Building a Mail Queue System
This article demonstrates an email queue system using SQL Server and VB Script. This overcomes the limitations of the Sending SMTP Mail using a Stored Procedure method |
| http://www.sqlteam.com/item.asp?ItemID=5908 |
|
|
Hits:29 |
Finding Similar Sounding Names using SOUNDEX
The situation: you've got a database containing information about each employee in your company. You decide to provide a search interface, allowing fellow employees to search for information on their coworkers by their last or first names. The only probl.. |
| http://www.4guysfromrolla.com/webtech/tips/t103101-1.shtml |
|
|
Hits:28 |
|
|
How to Perform a SQL Server Performance Audit
This lengthy article written by Brad, explains how to check the performance of your SQL Server |
| http://www.devarticles.com/art/1/489 |
|
|
Hits:28 |
Performance Tuning for SQL Server Developers
Don't think that performance tuning your SQL Server applications is regulated to the end of the development process. If you want your SQL Server-based applications to scale and run at their full potential, you must begin considering scalability and perfo.. |
| http://www.sql-server-performance.com/developers_tuning_tutorial.asp |
|
|
Hits:28 |
Scalability and high availability of Microsoft SQL Server 2000 INSERT INTO `sites` VALUES(Part 1)
Marcin Policht presents a number of solutions that provide high availability and load balancing of Microsoft SQL Server 2000, focusing on solutions available natively in the SQL Server 2000 and Windows 2000 |
| http://databasejournal.com/features/mssql/article.php/1583581 |
|
|
Hits:28 |
SQL Server 2000 Undocumented System Tables
In this article, Alexander Chigrik reveals numerous undocumented system tables shipped with SQL Server 2000. These tables are used by some system stored procedures and stored in the master database |
| http://www.swynk.com/friends/achigrik/UndocSQL2000Tbl.asp |
|
|
Hits:28 |
|
|
Take a bite out of your workload with SQL Server 2000 user-defined functions, part 2
User-defined functions INSERT INTO `sites` VALUES(UDFs) add new functionality to custom SQL Server 2000 applications. UDFs are similar to built-in functions, but you create them to perform specific tasks unique to an application, and you can modify them as needed. UDFs provide fa.. |
| http://builder.com.com/article.jhtml;jsessionid=M2X0PJYSRSXYAQD23VUCFEY?id=u0032 |
|
|
Hits:28 |
Using Triggers to Track Database Action History
Have you ever need to record each and every database insert and update statement for accounting purposes? This article, by Tal Kelley, examines how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular data.. |
| http://www.4guysfromrolla.com/webtech/091901-1.shtml |
|
|
Hits:28 |
Replicating SQL Server 2000 across Heterogeneous Databases
Replication enables data and database objects to be copied and modified from one database to another across different networks and platforms |
| http://www.sqlteam.com/item.asp?ItemID=14443 |
|
|
Hits:27 |
Page:1 2 3 4 5 6 7 |
Home
