(Dan Sawyer) Integration testing your T-SQL stored procedures saves debugging time and makes database programs more reliable and easier to reuse and maintain. In these respects, integration testing has many of the same benefits as unit testing individual procedures. The big difference between th

The SQL Server 2000 Report Pack for Microsoft Exchange is a set of 13 Microsoft SQL Server 2000 Reporting Services reports that work with a Microsoft Exchange sample reporting database. With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designi

Microsoft SQL Server 2000 may commit more memory than is physically available on a computer that is running Microsoft Windows XP. This problem only occurs for instances of SQL Server 2000 Service Pack 3 (SP3) or later versions. This problem may cause paging on the computer and lead to poor or slow p

(Brian Kelley) SQL Server has several methods of auditing logins and the simplest among these is to change the audit level within SQL Server. Using traces through Profiler or the set of trace stored procedures is another method, but most folks gets started by configuring auditing in Enterprise Manag

(Marcin Policht) In articles of this series, we have been so far providing recommendations regarding security-related configuration settings of SQL Server 2000 from the point of view of a database administrator. We have presented a set of guidelines that apply to any generic installation of SQL Serv

When you use the NSControl Update command to try to update an instance of Microsoft SQL Server 2000 Notification Services and the application databases for an existing instance of Notification Services, the update operations may not be completed successfully.

(Philip Miseldine) One of the biggest strengths of SQL Server is its powerful support for the definition of logic inside the database through stored procedures, user-functions, and triggers. This allows developers to create well-recognised and adaptable interfaces from their business logic layers to

(Alexander Kozak) SQL Server developers often use either the IDENTITY column or the MAX() function (for example, MAX(id) + 1) to create unique identifiers for a table. I personally like the identities. In my opinion, they’re convenient and flexible. One of the things that I don’t like about them, th

(Hilary Cotter) Indexing performance has always been the Achilles’ heel of SQL Server’s full-text feature. Although the search performance itself is fast (very few customers complain about the search speed), users do complain (often loudly and frequently) about how slow the indexing process is–espec

(Derek Wilson) Performing routine database maintenance such as reindexing is important for keeping your databases running at peak performance. When you use INSERT, UPDATE, and DELETE statements to modify table data, indexes can become fragmented. Index fragmentation can happen when the logical s