webrunner (11/14/2007)

---

Hello,

1. If I turn off Auto Shrink where I see it on - and I have already found a few cases - do I also need to add a...

h.schlais (11/26/2007)

---

......omitted stuff

cast(Bal_No as integer) as Bal_No ...

Eduardo Olivera (11/26/2007)

---

Hi Brian,

We are currently in the planning stages of a comprehensive set of tests that would allow us to determine which indexes are no longer, or never...

n 2005, you can see which queries are in the plan cache, along with the time the plan was put into the cache and the last time it was executed....

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...