Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

179 Items

Sort by Date | Title

SQL Server: Optimizing Database Performance Through Indexes
Aug 2, 2002
Want to improve your database query performance 10, 100, or possibly even 1,000 fold? Discover how to effectively incorporate indexes into your tables.
SQL Server: Tuning Database Design
Jul 26, 2002
Build tables, plunk in your data, you're done, right? Wrong. A poorly structured database can be a huge drain on your resources. Learn how to fix the problems.
SQL Server Tuning: Database Maintenance
Jul 19, 2002
The database administrator works like a doctor, keeping databases healthy. Learn the routine maintenance tasks that can help your databases live a long and active life.
Application Performance Tuning
Jul 12, 2002
In this intro to their series on SQL Server database tuning, Baya Pavliashvili and Kevin Kline point out some of the larger-scale problems that can affect application performance.
SQL Server: Recovering the Master Database
Jul 5, 2002
Having a carefully documented and tested recovery plan enables easy restoration of a server after a comprehensive failure. Run through a typical recovery situation step-by-step, plus review specific critical issues such as restoring logins and organizing restored user accounts.
The Battle of the RDBMSs: SQL Server 2000 Versus Oracle 9i (Part 2)
Jun 28, 2002

Database expert Rob Hawthorne explores the beginnings of both Microsoft and the SQL Server database as part of his series comparing SQL Server with Oracle 9i.

The Battle of the RDBMSs: SQL Server 2000 Versus Oracle 9i (Part 1)
Jun 21, 2002
Database expert Rob Hawthorne explores the Oracle Corporation and Oracle RDBMSs, peeping into the beginnings of both the company and the very popular Oracle database. See how the RDBMS sprang from the CIA!
VB.NET and SQL Server 2000: One Controlling Part of a Transaction
Jun 14, 2002
If you follow the recommendation to use local transactions when you only have one Resource Manager, but want to prepare for a possible future change to distributed transactions and have as few programming changes as possible, there are a couple of issues to consider. Jimmy Nilsson describes useful ways to attack the issue of having only have one controlling part for the transaction.
Options Affecting SQL Server Locking Behavior
May 31, 2002
If you need to alter SQL Server's default locking behavior, learn about the query hints and SET options that can also be used to alter the way SQL Server locks resources.
SQL Server: Blocking Problems
May 24, 2002
If your users complain about applications being slow, you may have blocking problems. This article shows you how to determine the causes of the blocking and how to resolve them.
Getting Started with MSDE and VB .NET
May 17, 2002
How can you build small multiuser applications inexpensively while preparing to scale up if your database needs increased performance? This article shows you how to use MSDE for these tasks.
SQL Server: Details of Locking
May 17, 2002
Understanding SQL Server’s locking architecture and lock types should get you on your way to writing scalable applications.
SQL Server: Transaction and Locking Architecture
May 10, 2002
Why are transactions important in Microsoft SQL Server, and how are they implemented? This first article in the transactions and locking series gives you a general overview.
SQL Server and OPENXML
May 1, 2002
Going through thousands of lines of XML can quickly degrade performance. That’s why it is nice to have the OPENXML function, which does the parsing work for you fairly efficiently.
DTS Tips and Tricks
Mar 8, 2002
In this third article of their three-part DTS series, Baya Pavliashvili and Dan Lampkin share the DTS tips that one can learn only through a hands-on experience with DTS packages and components.
The DTS Object Model
Mar 1, 2002
This second article in the three-part DTS series by Baya Pavliashvili and Dan Lampkin introduces you to the main objects and properties of the DTS object model.
What's New in SQL Server 2000
Mar 1, 2002
This sample chapter explores the new features provided in SQL Server 2000, as well as many of the enhancements to previously available features.
Introduction to Data Transformation Services (DTS)
Feb 22, 2002
In this first article in their three-part DTS series, Baya Pavliashvili and Dan Lampkin introduce you to one of the most powerful data transfer tools available: the Data Transformation Services of SQL Server.
SQL Server Stored Procedure Basics
Feb 8, 2002
Learn the basics of writing stored procedures, monitor stored procedure activity using the Profiler utility, and learn from several real-world stored procedure programming issues.
SureSync Part 2: Installing and Configuring SureSync to Run As a Service
Feb 8, 2002
Do you want SureSync to run as a service? In this second of a three-part series, Rob Hawthorne discusses its installation and configuration.

<< < Prev Page 5 6 7 8 9 Next >