Hello,

I would encapsulate the union to a table.

The issue is that the variable can only have one value, and sql server can't decide if the values comes from the second,......

Also check available memory and other applications running on the server.

Anything special in the logs? (sql, windows)

Try to run the stored procedure sp_who2 to find out which connections are actually running/sleeping/locked.

DBCC INPUTBUFFER (SPID) gives you the command text.

In addition you could start a sql trace with...

You can create an index on computed columns with certain connection settings. The index will store the computed values on disk.

Check "Creating Indexes on Computed Columns" in the books online

1) Have a backup of the existing udf's,stored procs

2)

You could create a script and execute it on the other server

Enterprise manger->rightclick database->generate sqlscript

->select the udf's/stored procedures

->choose your options (be careful...

It probably has to do something with the application roles:

Application roles bypass standard permissions.

When an application role is activated for a connection by the application, the connection permanently loses...

Have a look at

http://www.mcse.ms/message985011.html

Have you contacted Microsoft about the issue?

We had it very often but now at rare moments. Suspects: some backup/replication software keeping the filesystem too busy causing a short network timeout.

Changes made from often to rare:

Updated windows...

Sql server,most other databases and recently Vista keep data in cache (empty memory=wasted memory) to operate faster by avoiding disk access. Thats why its memory usage continues to grow (in...

Depending on frequency, you can create a linked server for it. The msaccess subforum probably holds the answer.

Dynamic queries good/bad : it depends.

Usually they give the same performance than stored procedures but lack some encapsulation. (since sql server will try to cache the plan)

For this goal, dynamic...

What is the serverpack level of win2000? Most recent windowsupdates installed?

Because the client usually dictates what the sorting will be (for a proper seperation of the data and its presentation). No need to sort it twice.

select ...

from myview

where ...

order by...

I got my replication issues fixed by reducing the batchsize from 500 to 100.

It is usually done by implementing/using a ntp-service (network time protocol)