View Complete Post
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.
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
i have one problem in my server.
it's trial version is expired.
Initially we deploy a trial version of moss 2007 enterprise edition.
Now i have moss 2007 standard edition with key, but it's not work on server.
Kindly suggest how to activate standard edition.
and i want to switch SQL server to another server which is presently on same server.
Please response asap.
I have installed MOSS 2007 sp2 and would like to know when we install the SP2 will it make any changes to standard layouts folder (changes in any files).
Referring to this tutorial: http://www.asp.net/webmatrix/tutorials/download-and-install-an-asp-net-application
I selected umbraco cms and got this wizard:
I already have Standard Sql Server 2005 on my machine which I wanted to us for above DB and not SqlExpress.
I did not remember "sa" account pwd nor I use explicitly any account to connect to my Sqlserver. I use Windows Authentication account i.e implicit authentication. So I created new account and gave all rights and used it in the above wizard and was able to install the database after some struggle.
My question is: What if I want to use my Windows Account to install the database above? Why the wizard don't have any option to use Windows Integrated Authentication?
Note: I can create the DB with external user I created, just looking specifics for using Windows Authentication for above installation.