--Setup, actual queries after the space
--create table fltrind (a integer,b integer)
truncate table fltrind
DROP INDEX fltrind.nf
DROP INDEX fltrind.f
DECLARE @i integer
In a previous question of mine, Is it a good idea to disable lock escalation while adding new calculated columns to a table?, I am creating a computed column:
ALTER TABLE dbo.tblBGiftVoucherItem
There is a similar question, but it is not the same:
The query processor could not produce a query plan
I have the following query, and the following filtered index, and I cannot see any reason why ...
I have recently created a filtered index in one of my databases but it would neither be used nor accepted in an index hint in any query unless I added the option(recompile) hint in it.
it turned out ...