In Microsoft SQL Server 2000, when you run a query that generates many floating point exception errors, you may experience slow performance and query timeouts when you run other queries. This problem typically occurs when more than 1,000 floating point exceptions are generated.

(Preethiviraj Kulasingham) Have you ever tried to use parameter validation within a SQL Server stored procedure using an OR clause? At times, it can cause performance problems. I found this recently when I was asked to fine tune a stored procedure. The procedure had two parameters, and either of the

(Michael Jones) Many major product releases have a dizzyingly long list of new features and enhancements—often introduced atop a product that is in many cases so complex and feature-ridden that it’s already difficult to keep up with the breadth of the product. However, the wide feature sets also mea

When you repeatedly create and destroy out-of-process Microsoft Component Object Model (COM) objects within the same batch or stored procedure in Microsoft SQL Server 2000, the memory used may grow continuously until the batch or the stored procedure has completed. The MemToLeave memory region may b

(Kirk Haselden) I’ve never seen a good definition for what validation in IS is supposed to be or what it’s supposed to do anywhere. There is a lot of discussion about what components do when validating, but before launching into a discussion about it, I thought it would be helpful to give a little h

(Stephen Swoyer) Skeptics who question Microsoft’s decision to integrate its .NET CLR with SQL Server 2005 tend to use the language of doomsayers such as Jeremiah or Cassandra to make their points. They believe in-process CLR is an insanely bad idea that could jeopardize the scalability and reliabil

(Laurence Moroney) Starting with SQL Server 2000, Microsoft added the concept of notification services to their flagship database engine. SQL Server Notification Services lets you generate and send notifications whenever some criterion is met. Generally, you use notifications to alert or update data

(Adam Machanic) Microsoft SQL Server DBAs, think fast! Without using any documentation, write a query that pulls a list of indexes from the SQL Server 2000 system tables, enumerating each index’s columns and whether the columns are sorted ascending or descending. You have two minutes. Go! (R)

(Kevin Saitta) Have you ever came across a situation where someone has entered duplicate data into a database table and now the queries that you have written is bringing back bad data!

When you try to install Microsoft SQL Server 2000 hotfix build 8.00.977, the installation may fail and the following messages are written to the Replsys.out file: [DBNETLIB]Specified SQL server not found. [DBNETLIB]ConnectionOpen (Connect()).