by Susan Sales Harkins and Arthur Fuller – SQL Server can do all the work of tracking database modifications by responding to changes with predefined tasks.
Tag: sql server
SQL Server Agent – Creating an Alert for ‘Could Not Allocate Space’ 1105 Errors
Alexzander Nepomnjashiy continues his new series that focuses on SQL Server alerts and errors with a look into creating a specific alert for ‘Could Not Allocate Space’ 1105 errors.
The comparison of SQL Server 6.5 with SQL Server 7.0
by: Sergey Vartanyan – In this article, Sergey Vartanyan shows you the core differences between SQL Server 6.5 and 7.0.
SQL Server 2000 Enterprise Edition Benefits
SQL Server 2000 Enterprise Edition offers several unique features, including the ability to access more than 2GB of memory, support for failover clustering, and distributed partitioned views (aka federated database servers). However, even if you don’t need any of these features, some performance opt
SQL Server: Common Problems, Tested Solutions
Book by Neil Pike – The book includes over 500 questions and answers for all versions of SQL Server 6.5, 7.0 and 2000. For the most part, the topics covered are commonly asked questions about SQL Server that were not adequately documented in the documentation provided by Microsoft. Neil Pike is a Mi
INF: Common SQL Mail Problems
This article uses a question and answer format to identify common problems you may encounter when you work with SQL Mail and provides you with some tips on how to correct or troubleshoot these problems. The vast majority of SQL Mail related problems are due to an improper configuration.
Setting Up Full Text Search: A Step-by-step Guide
Alexander Chigrik explains SQL Server full-text search concepts in extensive detail, complete with a step-by-step example for getting up and running with a full-text search index.
MySQL Takes On Enterprise Databases
By Richard Karpinski – Does an open-source database provider really have a prayer against Oracle, IBM, and Microsoft? Believe it.
Yukon Ho! SQL Server v.Next
Mary Chipman and Andy Baron – Find out how the next version of SQL Server (code named “Yukon”) will affect the way you write code.
Two Backup Windows
By Michael Otey – How do you deal with a backup time window that’s closing—whether you want it to or not—and a backup security window that you need to keep closed at all times?
