Re: Can I install SQL Server Enterprise on Windows 2000 SBS
From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 05/07/04
- Next message: Luis Garcia: "Re: Can I manage Diagrams if my OS is Windows XP Home Edition?"
- Previous message: Andrew John: "Re: help in database updations."
- In reply to: Wayne Wilson: "Re: Can I install SQL Server Enterprise on Windows 2000 SBS"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 May 2004 10:42:34 +0100
Hi Wayne,
I don't think you can create indexes on views via Enterprise Manager, or at
least not in Standard Edition.
You can create them with T-SQL though, for example::
USE Northwind
CREATE VIEW dbo.vw_employees
WITH SCHEMABINDING
AS
SELECT EmployeeID
FROM dbo.Employees
CREATE UNIQUE CLUSTERED INDEX ix_vw_employee ON vw_employees (employeeid)
There are a rather large number of restrictions on indexed views, see the
topic "Creating an indexed view" in SQL Server Books Online. The most
obvious ones are:
- The view must be created WITH SCHEMABINDING
- All tables must be referenced by owner, e.g. dbo.Employees
- SELECT * is not allowed
-- Jacco Schalkwijk SQL Server MVP "Wayne Wilson" <anonymous@discussions.microsoft.com> wrote in message news:0cbe01c433f9$0e2cd930$7d02280a@phx.gbl... > Hi > Thankyou for your help... your right i have confirmed on > a microsoft SQL Page that all editions of SQL Server > support Indexed views. > > However I Must be missing something > > I create a view in SQL Server (Standard edition in my SBS) > View is created with the SQL Server Enterprise Manager > tool > THen i right click the view and the "Manage Indexes" > option is greyed out. > > How exactly do I create the Indexed View? I want to do > this so a complex query across tables will be kept up to > date in real time and i can do a select on the view with > much more performance than on a regular select that joins > the tables. > > Thankyou so much for your help. > > Regards Wayne > >-----Original Message----- > >You can create indexed views in SQL Server Standard > Edition. They won't be > >considered for usage automatically by the Query > Optimizer though, although > >you can force the use when you reference the views > directly with the > >NOEXPAND clause. You can still use indexed views in > standard edition to > >enforce more complicated integrity constraints if that > is what you are > >after. I don't think upgrading to Enterprise Edition > just for the > >performance benefit of indexed views is worth the cost > really. > > > >-- > >Jacco Schalkwijk > >SQL Server MVP > > > > > >"Wayne Wilson" <wilsonw@pnc.com.au> wrote in message > >news:8f6901c43313$7eb78c90$a501280a@phx.gbl... > >> Hi. > >> > >> We have Windows 2000 Small Business Server > >> > >> In control panel/System the operating system is > identified > >> as Windows 2000 server service pack 4 > >> > >> Microsoft pages on System requirements for SQL Server > >> Enterprise edition says requires Windows 2000 Server > >> > >> The operating system I have seems to be Windows 2000 > >> Server even though it has some junk in it making it > >> Windows 2000 Small Business Server. > >> > >> Question can i Install SQL Server 2000 Enterprise? > >> > >> I need this because i need to use Indexed Views which > do > >> not exist in Sql Server standard edition. > >> > >> The answer varies depending on whome i ask at > Microsoft. > >> > >> Apreciate any advice. > >> > >> > >> > > > > > >. > >
- Next message: Luis Garcia: "Re: Can I manage Diagrams if my OS is Windows XP Home Edition?"
- Previous message: Andrew John: "Re: help in database updations."
- In reply to: Wayne Wilson: "Re: Can I install SQL Server Enterprise on Windows 2000 SBS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
