.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Indexed Views are supported by SqlServer Standard Edition - why do all feature lists state the oppos

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server
 

Hi there,

years ago I had already wanted to apply indexed views for a certain query tuning problem, but read that they are only supported in SqlServer Enterprise Edition. I came back to that topic recently, and again all the official documentation I found confirms that assumption (e.g. http://msdn.microsoft.com/en-us/library/cc645993.aspx).

I gave it a try anyway, and could easily create indexed views on Standard Edition. I checked the execution plans, and the view's indizes were applied. The only small restriction I encountered was, that I had to supply a "with (noexpand)" query hint in the from clause. It even works on SqlServer 2000 Standard Edition.

This is such a valuable feature, probably seldomly applied, because articles and postings everywhere imply that Enterprise Edition is a requirement. I suppose it would be a good idea to correct Microsoft's documentation on that topic. Thank you!

Kind regards, Arno




View Complete Post


More Related Resource Links

In windows server 2008 standard edition feature Failover clustering is not looking

  
In windows server 2008 standard edition feature Failover clustering is not looking.Yet microsoft is telling that we give 2 node cluster support on 2008 server standard edition.Therefore I have suggested the company to buy it and now I am fixed due to this.  Please Help  "SQLSERVER DBA" "INDIA"

The 'Measure expressions' feature is not included in the 'Standard Edition' SKU

  

I'm following the project in Analysis Services Step by Step and have this trouble when I'm trying to deploy My First Cube in Chap 03. I'm not using Standard Edition. I'm using Developer Edition. What do I have to do to be able to continue?

Regards,
Yvonne


How do I change the default HTML code for a collection of lists and views

  

I have modified the html display code of some lists and content query web parts in SharePoint designer.  This works well when modifying a few lists, but I have many lists and different views with these many lists.

Is there a way to modify the template code for a site so that all my lists, views and CQWPs display identically with my modified code?  Managing these individually is not practical.


can MOSS Standard intergrate with ms sqlserver?

  
can MOSS 2007 standard call database ms sqlserver?

Content migration from MOSS Enterprise edition to MOSS Standard edition

  
Hi,     I have developed a web application using MOSS 2007 enterprise edition. I have customized the site using custom ASPX pages, custom Webpart and custom features. Also I referred http://blog.brianfarnhill.com/2009/03/19/changing-list-forms-through-code/ for updating the contents of list forms. I have configured SQL-Form based Authentication for this site. Now I have a need to migrate this site to an environment which has MOSS 2007 standard edition and use a Active Directory Authentication instead of SQL-Form based Authentication. So can anyone guide me wether this scenario is possible or it will create any compatibility issue?      Which are the precautions I need to consider for performing this task? I would appreciate any help on this. Thanks, Patav

Please Advice SQL 2008 Standard Edition

  
·         I have a issue with subscriptions since we have SQL 2008 Standard edition and i found out that Data Driven Subscription are disabled. We have about 100 reports subscribed by our internal & external customers. I have a DB "Prices" In that we have 4 Tables, Analysts,Users,SalesReps & Sub Sales rep the subscriptions are by anyone and everyone from these 4 tables.... we have a Project thats in Build in sql server 2008, which is a repository for all our 100 reports....basically what we are trying to do is based on Relationship, security level and user hierarchy they can access the reports... Any ideas will help ???????????FM

Upgrade SQL 2005 standard Runtime edition to SQL 2005 standard edition full version

  
We have a MS SQL 2005 standard edition runtime license. The SQL Server Runtime license is a license that lets an independent software vendor (ISV) embed the complete SQL Server code into a solution for use only by the ISV application. The customers of the ISV cannot use this SQL Server product to run other applications or to develop new applications, databases, or tables. Now we want to add a new database to the SQL. We know that we have to buy a full version of SQL 2008 standard edition. But the question is: How can we add a new database to the existing SQL. Do we have to uninstall SQL runtime license and install the full version and migrate the existing databse or can we change the key and add new databases to the SQL server?

SQL Server Standard Edition and Servers with more than 4 CPUs:

  
Hi, We are planning configure a SQL Server 2008 R2 Standard Edition on a server with 8 CPUs - two quad core with hyper threading. The server also runs many SSIS packages and SSRS reports. We would like to assign the highest priority to SQL database engine. Considering the fact that SQL Standard does not leverage more than 4 CPUs, what would be the best way to dedicate most of CPU power to SQL Server database engine? I already found that I can’t dedicate SPUs to SQL Server through this post: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/3b797fc8-3bea-422d-b172-7d1a93195c69 I am a bit concern that manipulating the default settings for Affinity and SQL Server priority might cause harm. That is why I am asking for a good practice for specific circumstance explained here. Any help would be appreciated, Max

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

  
Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Upgrade Desktop Engine (MSDE 2000) to standard Edition 2000

  
Hi All,   I need to upgrade from MSDE to SQL server 2000 Standard Edition how can we proceed with this. I am new to this and any help will highly appreciated. What are the things i should take care before going to this version up gradation ?

Your upgrade is blocked.. when adding components to SQL 2005 Standard Edition SP1

  
Name: Microsoft SQL Server 2005 Tools Hello, I am having a problem when trying to add the Client Components to an existing installation of SQL 2005 Standard Edition SP1 running on Windows 2003 Standard. The server was originally built with SQL 2005 Standard Edition and had SP1 installed at a later date. I am using the CD that SQL was originally installed with which is not a service packed copy of SQL. The reason given when clicking the details button is as follows: Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Build version check: Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove. Any help would be greatly appreciated. Regards Steve

Is peer-2peer replication going to be part of Standard Edition?

  
We currently use merge replication and have had numerous issues with it.  Primarily that there is a single point of failure. We are looking at moving to peer-2-peer transactional replication but we are currently running standard edition and have no plans/budget to upgrade. Will peer-2-peer be available in standard edition in the near future?   Thanks, Paul

Replication option SQL 2005 Standard Edition

  
Hi, We are using SQL 2005 Standard Edition.  We would like to use Replication for one of our database. I would like to know answers for the questions. 1. Can we use Replication features with SQL 2005 Standard Edition 2. Can we use DR site with replication for the reporting purpose?  Is there any risks associated with option? 3. Do we still need to take transaction log backup on the production server if we use replication.   Thanks.      

SQLServer Express 2008 R2 - Cannot connect Error: 18456, Severity: 14, State: 11.

  
I have just installed  running MSSQL Server 2008 R2 (Express), along with Visual Web Developer 2010 Express In SQL Server Configuration Manager I can see the SQL Server Service running (SQLEXPRESS) and the SQL Server Browser service running. On running SQL Server Management Studio when trying to log on I get the message Login failed for user Phil-PC`Phil (Microsoft SQL Server, Error: 18456) In the SQL Server Error log I see this error 2010-09-16 10:24:16.07 Logon       Error: 18456, Severity: 14, State: 11. 2010-09-16 10:24:16.07 Logon       Login failed for user 'Phil-PC\Phil'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>] I have been unable to find anything useful on Google on how to resolve this problem. I have tried running the command line utility sqlcmd -L and this lists the following Servers:     Phil-PC     Phil-PC\SQLEXPRESS   In my list of Installed programs in Control Panel I see both MS SQL Server 2008 & MS SQL Server 2008 R2, is that correct?

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

  
Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

SQL Server 2005 standard Edition to SQL Server 2005 enterprise edition

  

Hi,

My current version of SQL server is Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I want to upgrade this to Enterprise edition. I would like to know the below information please

  • step by step instructions on how to perform this upgrade
  • I have databases & replications setup on this server. Will the upgrade have any adverse effects on the current replication setup?

Any help and guidance is truly appericiated. Thanks.


SQL Server 2005 Standard edition install fails; An instance with the same name.../

  

Good Morning

I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled.

I have selected the default instance and everything I try results in the error:

An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

Log file says;

--------------------------------------------------------------------------------
Machine         : ISAINTERNET
Product         : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_ISAINTERNET_SQL.log
Last Action     : DetectInstanceClash
Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number    : 28086
--------------------------------------------------------------------------------

Ian Smith


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend