And what about replacing IN by CTE or temporary table?

for example:

WITH CTE_Code(Code) AS

(

SELECT 21 , 66 , 34 , 36 , 37 , 35 , 33 , 38...

Indexed view is stored in database like normal table so I would not expect any performance problems.

Hi

Michal

Dynamic index is the last thing I would think about. There is a lot of possible problems. Can you send code example from your procedure? Is there any cursor? Have...

You should post the view definition here...Don't you have SELECT * inside the view?

Yes, I have the same situation on my PC for testing purposes. I have not noticed any problem with this configuration.

Thanks Greg. I tried to rebuild indexes of one table before but nothing changed. But this was probably because of too little data in this table. I have tried it now...

I know these methods to find unused indexes. I have no problem with choosing indexes to delete, but I have expected reducing DB size.

Recovery model is Simple.

OK, that is not problem for me, I have just experimented with new features of SQL2005. Some of them (eg. CTE) improved performance of our system and I was dealing...

It is clear that standard isolation level is defined for whole database. But sometimes it is good to change this level for some group of transactions. And my question was...

Sorry, I am asking about SQL2005, I have just post it to the right forum