I found an interesting problem on a customer server.
This server has 2 CPU with HyperThreading.
Server is WIN2000 SP4, SQL 2000 SP3a with 3 instances.
All MDF and LDF files are on the same drive (not optimal, but the customer

Does anyone have experience running 64bit versions of SQL Server on systems
with HyperMemory?
Let me be more specific, I have a laptop for development. HP Compaq nx6325
(AMD Turion64 X2), 4 GB RAM, Vista Ultimate x64 and the x64 Developer Edition

If two tables are joined using a hash join, SQL server forgets the sort order
of the second table. SQL server adds an expensive sort operation to resort
the result while it was allready in the right order. I've seen many cases
where the execution could be much faster if the sort ...

We have a problem with performance on our MSSQL2000 server
Every once in a while the CPU's go to 100% and there are many locks on the
database (so I'm told), new queries are not run (maybe blocked) in this
interval. There are no deadlocks or lock timeouts (again so I'm told).

We are currently looking at ways in which we can improve the peformance of
our database to give our customers a faster response when using our website.
This has become a priority as our application has started to issue timeouts.
We are running SQL2000 Enterprise SP4 on a dual Xeon ...

During a performance troubleshooting using Profiler, I saw a lot of system
SPs related to cursor, such as sp_cursorfetch, sp_cursorclose,
sp_curosrunprepare... What's going on with these SPs and what do they mean?
Thanks.

First of all, my apologies for any mis-termonologies in this post, I'm a C#
developer turning my hand to SQL Server 2000.
We have a DB that I don't believe is tuned to it's best. For example, 1
stored procedure that we have, returns 10 records but takes a mighty 11

Can anyone point me to howto documentation on how to do performance counters
and send the results to one SQL database table?  I have about 15 databases
that I need this into one database.  I'e got one model setup and working, but
it creates 3 tables and this won't work for what I ...

switching a database to read only improve the performance (specially in a DW
environment)
in my case I have few tables where I have to write and all other can be read
only.

Greetings all, good day to you!
We are currently planning a SQL 2005 Standard deployment with SSAS on a
single server and are weighing various options.
We know obviously which are better, but does anyone have any specs or %

I have a performance problem using ignore_dup_key='on' on SQL Server 2005
(with or without SP2).
The scenario is that we are collecting high volume real time data that
contains duplicate data.