Hi,

That article doesnt explain how the actual data is stored. I just need to know if using this type of index uses a large amount of disk space?

Thanks.

Can you tell me how Full Text Indexes are stored please? I know how clustered indexes are stored. How are Full Text Indexes stored in comparison?

Thanks

Thanks for your reply.

Thank you.

Could you confirm if selecting data from a view would automatically cause a recompilation? Or would it depened on the tables which the view references?

Ok thanks,

is there any reason why a sample scan would be performed instead of a full scan?

Sorry,

Ignore this, I just read your reply.

Thanks.

Ok thanks,

I have an issue where I have a good performing query. I then run a data import. The next query generates a new plan and performance after this point...

If a data import has caused a plan to re-compile - would this not improve performance,as the engine will now be aware of the extra data?

I'm seeing a recompile...

Ok, thanks for your help with this.

I'll read over the article in the link.

Assuming that my plan_handle is the same, I'm now happy that it has been recompiled not compiled.

Thanks.

Is there a way that I can determine if a whole Plan has been re-compiled or just a single statement.

I have a query which breaks the plan up into...

Thanks for the reply.

Can I just confirm the following please:

1. Single queries within a plan can be recompiled, and the Plan_Handle remains the same.

2. If the amount of data has...

Thats what I needed. Thanks.

Thank you both for your help.

Thanks for the reply. Please can you answer the following if possible:

1. Start SQL Server 2005

2. Connect to Server (Instance)

3. Open 3 'New Query' windows

4. Run the sys.dm_exec_sessions, and sys.dm_exec_connections

5....

OK. Thanks for your help.