Quick question on indexed views

Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
of an indexed-view affect the indexed view at all?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
I feel it won't affect much
lutzdw wrote:
>Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
>of an indexed-view affect the indexed view at all?
Message posted via http://www.droptable.com

Quick question on indexed views

Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
of an indexed-view affect the indexed view at all?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1I feel it won't affect much
lutzdw wrote:
>Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
>of an indexed-view affect the indexed view at all?
--
Message posted via http://www.sqlmonster.com

Quick question on indexed views

Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
of an indexed-view affect the indexed view at all?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1I feel it won't affect much
lutzdw wrote:
>Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
>of an indexed-view affect the indexed view at all?
Message posted via http://www.droptable.com

Quick method to determine relative position of the index entry

I have a large table with some indexes.
And I have a value for an indexed field. So I'd like to get the order of the first entry of this value in a specified index.

I'd like to write a stored procedure, which returns such number for given value and index name.

How can I do it?I have found a quik decision!

select count(distinct indexed_col_name)
from Table
where index_col_name < value

Other ideas (with Cursor , for example) are slower.