I was talking about MSSQL2000 also.

And if your table has a clustered index on and the size is over 1 extent (8 pages) then the dbcc dbreindex must compact the...

Do your table has a clustered index on?

Because table pages are rearranged only if a clustered index is on that table

Some time ago we have got some performance issues with our big SAP running SQLServer.

The indexes have been mainly OK.

Finallyi t turned out that the problem was with the satistics...

Just some additional information of the sysindex table:

indid column (ID of index):

1 = Clustered index. (equivalent to (status & 16) = 0)

>1 = Nonclustered.

255 = Entry for tables that have...

Antares,

Somewhere I have read that EXISTS perform better then IN because the optimiser stops serching at the first occurance when using EXISTS but searches for each cases listed in the...

What I see as problem is a fundemental one.

First from you are making a range selection from your Weblog table and also your WHERE clasue is using the logWritten and the...

Tempdb is not as big. It is just 9,5GB but of course it is located on a different physical drive

That's why you have module experts.

For example a CO or FI module expert knows his few dozens of tables, a PM module expert the other tables and so one.

An empty...

I'm running it for 5 years already and still below 0.5 sec/average transaction with 800-1000 concurrents users and 50 GB daily growth.

We have some issues with the reindexing (SQL2K) as...

What you have is not as big.

Actually we are running SAP systems where the biggest is 30 000 tables and the size is over 1,6 TB within one database.

If you...

If you are old enough then having more servers then teeth could mean that you have 2 or 3 servers which is not too much.

If by chance you have more...

If you have enough space you can consider the following:

Separate the biggest (or most accessed) tables into separate filegroups. Best is if thoses filegroupes are located on differents physical disks....

Actually we are running a quite large database (over 1,4 TB) and still growing. We are expecting 2 TB by the end of this year. This is an SAP system...

Quick and dirty solution:

Select "Result to text" (Ctrl+T)

Select the menu Tools|Options.. then select the Result tab and select in the "Results output format" to "Tab delimited"

That's it. No you can copy...

If you want to have the top 5 biggest table (by szize and not by the number of rows) then you can use this one:

select  top 5

 O.name,

 Pages = reserved,

 KB_used =...