Re: Indexed Views

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 14:41:54 -0500

I did. What's your point? Ron cited the BOL and the citation is simply
incorrect. The fact remains that you can create an indexed view in a
version other than EE or Dev. It will be materialized - run sp_spaceused to
prove it to yourself. What won't happen with the non EE or Dev versions is
implicit use of the view, nor will it use the explicit indexed view's data
without the NOEXPAND hint. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Steve Z" <SteveZ@discussions.microsoft.com> wrote in message
news:B5B7BBFC-408A-4864-962A-B9D77DC2A4FA@microsoft.com...
Did you not see any of my posts?
"Tom Moreau" wrote:
> Then that's a doc bug.  I just ran the following successfully in Northwind
> on SQL Server Personal Edition:
>
> create view v
> with schemabinding
> as
>  select
>   CustomerID
>  , CompanyName
>  from
>   dbo.Customers
> go
>
> create unique clustered index idx on v (CustomerID)
> go
>
> drop view v
>
>
> -- 
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
>
> "Ron" <anonymous@discussions.microsoft.com> wrote in message
> news:0b0401c4eea2$7bc16100$a601280a@phx.gbl...
> This quote is straight from BOL:
>
>
> "Note  You can create indexed views only if you install
> Microsoft SQL Server 2000 Enterprise Edition or Microsoft
> SQL Server 2000 Developer Edition."
>
>
>
>
> >-----Original Message-----
> >Where in BOL?
> >
> >You can create indexed views with any edition, but they
> will not be
> >considered automatically by the query optimizer unless
> you're using
> >Enterprise or Developer edition.
> >
> >-- 
> >Adam Machanic
> >SQL Server MVP
> >http://www.sqljunkies.com/weblog/amachanic
> >--
> >
> >
> >"Ron" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:08d501c4ee9f$94a57a60$a401280a@phx.gbl...
> >> According to:
> >> http://msdn.microsoft.com/library/default.asp?
> >> url=/library/en-us/dnsql2k/html/indexedviews1.asp?
> >> frame=true
> >>
> >> "Indexed views can be created in any edition of SQL
> Server
> >> 2000" (Read the Note on the page) and According to BOL:
> >>
> >> "You can create indexed views only if you install
> >> Microsoft SQL Server 2000 Enterprise Edition or
> Microsoft
> >> SQL Server 2000 Developer Edition".
> >>
> >> Am I Missing something ?. Is this functionality came
> with
> >> one of the service packs ?
> >>
> >>
> >>
> >>
> >
> >
> >.
> >
>
>

Relevant Pages

  • Re: XPe Database Question
    ... The retail price for Microsoft SQL Server 2005 Developer Edition is ... Can MSDE be placed on a server or is this a local installation only? ...
    (microsoft.public.windowsxp.embedded)
  • Re: Wartungsplan schlägt teilweise fehl
    ... aus BOL SIMPLE is the default setting for SQL Server Personal Edition ... Die master-DB hat immer simple. ... Sicherung der Datenbank und alle Sicherungen der Tranaktionslogs. ... Lesestoff dazu im "SQL Server 2000 Operations Guide": ...
    (microsoft.public.de.sqlserver)
  • Re: Indexed Views
    ... >> wrong or the functionality was added with the SP's) ... The BOL information was wrong in the RTM version. ... SQL Server Documentation Team ... > "Tom Moreau" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Indexed Views
    ... Where in BOL? ... Enterprise or Developer edition. ... > "Indexed views can be created in any edition of SQL Server ... > Microsoft SQL Server 2000 Enterprise Edition or Microsoft ...
    (microsoft.public.sqlserver.server)
  • Re: More Questions on Permission
    ... BOL = Books OnLine, which is the documentation for SQL Server. ... "Greg Chang" wrote in message ... >>> Subject: Re: Questions about syspermissions ...
    (microsoft.public.sqlserver.msde)