Also you dont have to reindex and update the statistics for all your tables daily.

You should check at the end of the days the fragmentation status of each of your...

I agree with cmille.

Actually the performance gain of the 64 bit processor is for memory intensive applications (over 4 GB). The pure processor speed is not enormously higher then the...

Just an answer to Rémi's comment:

SQLserver will still use the index if you have this kind of query:

declare @v-2 varchar(50)

set @v-2 = 'E'

select * from dbo.T_CUS_customer

where cus_code_char like @v-2 +...

AFAIK SQLServer 64 bit edition is running exclusively on Itanium II .

So if you are planning to use some cheaper CPU (As I would...

declare @d datetime

set @d = '20050918'

select convert(datetime,

  cast(datepart(mm, @d) as varchar) +

  '/1/' +

  cast(datepart(yy, @d) as varchar), 101)

Yes I can, (this was the first thing I've tried out when I've seen the problem) but not with the REPAIR_FAST option because it requires the database to be in...

I do not really see any performance issues (AVG % disk time is less then 5%, AVG disk queue is a bit high (AVG 3-5) but not too dramatical). Also I...

Also, how can I stop a checkpoint process?

I can select from that table, but I cann't reindex neither that table nor the other tables in that database, and I cannot backup the database.

The problem with a restart is that...

This is the entry of the error log (And of cours this entry repeats itself hundreds of time

2005-05-05 16:32:24.67 spid7     Time out occurred while waiting for buffer latch type...

Just to have a different opinion in a 100% MS world

I'm using Delphi for the Windows development, because it is very fast in...

I'm a very different opinion

I'm using for the Windows development Delphi which is reliably and fast in development and execution time, working extremly...

And my 2 cents:

Don't forget: a char(n) is represented internally as an array of n bytes.

So to make a comparison SQLServer has to do a loop and compare every bytes...

Shure!

You can check the access plan within your Query Analyzer.

So you can see whether it is using an index or a table scan

Shure.

The rowcnt column is valid for the entire table.

For a query with a where clause only the count(*) can work