Here is an article 'How to Identify Non-Active SQL Server Indexes'.

using Profiler and the Index Tuning Wizard with recommendations on Profiler settings, as you requested;

http://www.sqlnewsgroups.net/link.aspx?url=http://www.sql-server-performance.com/lm_index_elimination_english.asp

It looks tedious...

Thought I'd mention a sidebar issue related to this...

Be sure to EXEC sp_spaceused @updateusage = 'TRUE' for each DB sometime soon before you collect your data. Without the...

Savass -

I feel your pain. Since you have done all the standard things to remedy this, here's the short version of what you need to know:

I assume your DB...

DTS is also a multi-threaded native SQL Server 2000 component.

DTS Packages can be written to execute many tasks simultanaously rather than serially. For example, you can define multiple connections...

Hi James -

This is Cognos Planning, isn't it?

I recall the installation team/developers installing and leaving, then me checking disk about 3 months later and seeing the media set...

Tejwant -

This article by Brian is a good functional description of Cluster configuration;

http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine__2.aspI

I have only done Active/Passive Failover clustering on a shared SAN.

I encourage you to check out the following two articles;

For more detail on SQL Server/SAN configuration specifics;

http://www.sqlservercentral.com/columnists/hscott/asanprimer.asp

For your Clustering questions;

http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

I completely agree that you need to be planning...

Mike -

I gather since you shrunk the Transaction Logs (*.ldf) to gain some space that they are on the same storage array as Data files (*.mdf). That's not the...

Security Options/Interactive Logon: Number of previous logons to cache (in case domain controller is not available).

When going LIVE with a domainless standalone SQL Server, one Local Windows account User/SID...

Thanks for clarifying this for me, David. Much appreciated!

See what happens when you toggle the Query Analyzer Connection option 'Use regional settings when outputting currency, number, dates, and times'

Apologies if you've already gone through this litany of questions, Mordechai. Just doing a little fishing...

I see this is not Linked Server or Distributed Query. Both SQL Server 2000/same SP?

Using...

Do both servers have the same OS level Regional Settings?

Are there NULLs in the Resultset of the failing query?

Bryan -

Some of my work is in a Domainless World, and we have a number of external web applications (outside our Domain) that access our SQL Server 2000 instance using Integrated...

Steve, I couldn't agree more about the Conference attendance being part vacation/part intensive training. if you're lucky enough to work someplace where that is recognized as a good thing, it's...