Hi,

After rebuild indexes you don't need to update statistics.

Also you don't need to rebuild index every night, read in BOL about fillfactor.

Best regards,

Hi,

You have some open transaction on database.

Check it with DBCC OPENTRAN

Of course that he must shrink it after truncation. I wrote that to him. I still disagree that.

There is situation which I think that he has

1. I don't perform...

Are you sure that problem is in Sql server?

Do you have any other applications on that server?

You can set minimum server memory to 2 GB but I am not...

Maybe is only different count because of null values.

Can you check it?

I understand both of you and you have right. Only thing which I want to tell him is that is that he must start to work transactional log backup's or...

It seems that You didn't understand my post.

You can't perform point in time backup without transactional log backup and if you don't have transactional log backup then you don't...

Hi,

Please explain me which log chain will he break if he don't work transactional log backups?

Also this query will show you CPU pressure:

SELECT TOP 50 (a.total_worker_time/a.execution_count) as [Avg_CPU_Time],

Convert(Varchar,Last_Execution_Time) as 'Last_execution_Time',

Total_Physical_Reads,

...

Do you have any open transaction?

Try with DBCC OPENTRAN.

Hi,

Use BOL and try to find something about sys.dm_exec_query_stats

Hi,

I suppose that you don't perform transactional log backup's 😉

That is reason why is your log file so big.

You need to do this:

Execute:

BACKUP LOG DatabaseName with truncate_only

DBCC SHRINKFILE...

First step is that you find query/procedure which is executing in report (look at dataset).

After that you should analyze execution plan.

thx toni i know for that, but i dont know may i do that in report with some expression or something... thx anyway