Timestamp in SQL Server is not equivalent to the ANSI type timestamp. Timestamp in SQL Server can also be called by it's synonym, rowversion. In fact you should only use...

Uhm, you are running SQL Server 7 SP4.

That depends on how the table is used. If an index becomes fragmented then it shuold be defragmented, for instance by using reindex. But there arealso other ways, such as...

Scenario: The company owners are facing a tough decision. If the company has shipped more than X items today they will sell the company, otherwise not. They look at the...

In any case I would not let ITW make any modifications to the database directly. Script the actions ITW suggests and decide yourself whether or not to implement them.

Change the network packet size. The default is 4096 bytes, and the max batch string length is 65536 * network packet size. Note that changing this might have performance implications,...

SQL Server 2005 Beta 2 does not play well with SQL Server 2000 and is not recommended to be installed side-by-side. You should however be able to install the latest...

This is one of the reasons why using bitmasks coded in ints is not really a good thing in SQL Server. I would probably store the flags in a separate...

>My colleagues now want to add WITH (NOLOCK) to every SELECT statement. Is this wise?

Why does your colleagues want to use an RDBMS, or even a transaction-management system, at all?...

What kind of application(s) are you running against this database? How do the applications connect to the server? Are you sure that you are protected against SQL Injection for instance?

Hm, I hadn't seen your last post when I wrote mine. But I will let it stay if it is still valid.

As Kenneth hints, I would assume that there are actually differences in the parameters that are used for the differing executions. If so, then the problem is most probably skewed...

Inside the SQL Server 2000 User Mode Scheduler

The above article describes this in very good detail.

If you are asking if it is possible to give one session higher priority than another, then no that is not possible in SQL Server.

From how you have described your process, you should use SCOPE_IDENTITY to get the number.

A number assigned by an identity property is always used regardless of whether or not the...