Please don't double post. It splits answers and wastes time

Continue thread here please

Sure. I was pointing out that the optimiser doesn't (and can't) always ignore the column specified. Your reply seemed to say that count(*) and count(column) are equivalent, which they aren't'...

Not quite.

Count(*) or count(1) or similar will give you the number of rows in the table. Count(ColumnName) will give you the number of rows where that column is not null.

If...

I would think that the strength of the forum is all the volunteers who frequent the board, rather than the people running it.

If you want to avoid unnecessary rebuilds, you can check the fragmentation of the table and decide based on that whether or not to rebuild.

SELECT * from sys.dm_exec_physical_stats([db_id], [schema_id], [table_id],[index_id],[mode])

It's...

This is in the SQL 2005 forum and I stated that the solution was for SQL 2005.

Of course it won't work on SQL 2000 or SQL 7. The post was...

There are 2 exams for the ITP dev. Which are you writing? Or are you doing them both the same day?

70-441: Designing database solutions

70-442: Designing and optimising data access.

(70-431 is...

But that means that the order of statements in the where clause now becomes important. That will absolutely cripple the optimiser as it will not be allowed to look for...

Explanations don't help much when debugging code. That's why I kept asking for the code of the trigger and view.

I had an idea what might be wrong, but without seeing...

Why do you want to know?

You can filter on the Database ID column and exclude the ids of databases that you don't want to see.

Better to filter on ID than name, as not all...

Probably not. What errors are you getting when trying to select from the tables?

If it were a corrupt DB, there might be a chance or reading the pages raw and...

Go into the job step and set it to log output to a text file (I don't remember where this is in SQL 2000)

With that, you'll see the full output...

Is that on SQL 2000 or SQL 2005?

What's the state of the database? (suspect, recovering, offline, ...?)

There may be a way, but just so that you can copy the data...

How do you know the server's slowed down?

More CPU usage?

Queries in general slower?

Some queries slower?

Something else?