Thanks

so if i am doing select * from (indexed_view) does it touches the base tables to retrieve the data.?

Thanks.

I have seen the difference between materialized view and Views. and i have question in it.?

Materialized views are disk based and update periodically base upon the query definition, Views are...

Thanks for the reply..

Hi ..check your AD acccount it may be locked.

Thanks.

Hi thanks for your reply. i am using SQL server 2000 and dbcc reindex is running from the sql-DMo application.

Hi

thanks for this information. actually i will give a example

Table name : table1

Columnname: status, accountno,number,ordername

index created:

Index_nameType Fields

A1 Clustered...

Hi

thanks for this information. actually i will give a example

Table name : table1

Columnname: status, accountno,number,ordername

index created:

Index_nameType Fields

A1 Clustered...

Thanks Gila. but i just want to know how the question will be.

Hi I am Planning to write 70-443 this week . does anybody have dump on this. if u have please send it to karthikeyan_thangaraju@ymail.com.

Thanks in advance.

is the set "SET CPU_ UTILISATION LOW" is the query to set the cpu utilisation low..

can u help me..?

when we are taking the backup of sql server database the cpu...