SQL Server 2000 Articles

SQLUSA

Microsoft SQL Server 2000

Articles

Updated Weekly. Submit your article for publication to Support.


Microsoft SQL Server 2000 Index Defragmentation Best Practices
How to Backup, Move Full-text Catalogs
Improving Performance with SQL Server 2000 Indexed Views
Importing XML Data into SQL Server 2000
Crosstab Report Creation Using CASE
Exporting Data into a Web Template
Sequence Generation on the Fly
Complex SELECTs
Column Update Triggers
Transactional Replication Performance Tuning and Optimization
SELECT from SELECT
The Magic of SQL Profiler
International Features in SQL Server 2000
Audit Trail Trigger for INSERT, DELETE and UPDATE
How to Achieve High Performance with Linked Servers
DTSRUN for Export, Import Automation
How to Pin a Table into Memory
SQL Server 2000 Pricing and Licensing
DBCC SHOWCONTIG and INDEXDEFRAG
Timestamp(rowversion) Data Type
Security Auditing the SQL Server Operational Environment
How to Create a SQL Profiler Trace from a Stored Procedure
How Can You Use Terminal Services
How to Avoid Hard-wiring Literals into Queries and Stored Procedures
Microsoft SQL Server 2000 for the ORACLE Professional
How to Achieve Good Relational Database Design
How to move SQL Server 2005 System Databases
Triggers: The Silent Workhorses
Job to Monitor SQL Server 2000 Performance and Activity
Choosing an Edition of SQL Server 2000
Standby Server Setup
Preserving Client-Server Data Integrity with Unicode and Microsoft SQL Server 2000
Microsoft SQL Server 2000 English Query
Globally Unique Identifier

SQLUSA.com Home Page

The future is just a click away! Your future!



Copyright 2003-2004, SMI Corp. All Rights Reserved.

Microsoft is a trademark of Microsoft Corporation. SQL Server 2000 is a program product of Microsoft Corporation.