To Index or Not To Index or How To Index
Hello, I was wondering if someone knows a better way to explain how different indexes work. Such as, is it better to have an index with int type or char or varchar etc? Is it better to have composite indexes or indexes with individual columns? How does optimizer handle different indexes and what can we do help it? Indexes are very efficient most of the time but they can be quite detrimental to server's performance, if abused. Perhaps you know of a good article about indexing that you could share with us. Or, perhaps Mr. Rob Verschoor would like to issue an article in his very usefu...

index server not indexing
Ok, so I want to add a catalog to the index server. I can add the new catalog, I then add a directory to this catalog. I restart the index server, and merge the index. If I click the index server, in mmc, it shows 0 documents for everything. Everything meaning documents to index, total docs, docs defered for indexing and so on.  I've tried this on vista as well as on win2003 and the same result is obtained, no documents are indexed. In win2003 I can index document, but ONLY the ones in the default catalog, if I paste some documents there they get indexed. So, what have I don...

Clustered Index on Indexed View from ADO.NET
I have a clustered index on an indexed view in sql server 2000. When I do a simple select in query anaylser from this view I can see from the execution plan in profiler that the clustered index was used to return the data, hence improving performance of the underlying select(this is why I am using the indexed view). However, if I run the query from an asp.net page using the sql provider I can see the call in profiler but the clustered index is not used, hence reducing the performance of the call considerably.If anyone has experienced this please let me know.Cheers Niall Views are...

Index server, indexing but not returning results (vista)
I've indexed some documents in index server. I specify the catalog and folder in my query, see below. My problem is that the query never returns any result. I've indexed a lot of different folder och even indexed c in my despair:.On a total I have 85289 docs indexed if I look in the Mmc, but can't get one single document returned. One funny thing is that I can't set the index to inherit the settings from the webserver, if I choose properties. I can select it and save it, but when I go back, everything is set as before. I'm guessing this has something to do with...

To Index or not to Index (that is the question...)
I'd like to clear up an assumption I have. If I have a Primary Key Constraint on a Table I assume that I will not need to create an Index on the field(s) of the constraint as the action of creating the primary key constraint produces what is the equivalent of an Index (be the constraint clustered or not). Is this the case? Also I'm looking to Pivot some data, are there any SQL tricks etc. I should be aware of to be able to do this (I've searched the Newsgroups for 'Pivot' but don't understand any of the answers posted - some SQL examples would be gr...

Index Server setup
I used to code in classic ASP and it was quite easy to set up a catalog and then re-use my previous paging code to point to the new catalog.  I could have keyword search using Index Server set up and running in about one hour tops.  With ASP.NET, I'm not involved in setting up keyword search, but my team of developers routinely take anywhere from 4-10 hours to set up Index Server.  It seems there has to be a better way.  They indicate it is due to the master pages and configuration.  But seriously...isn't ASP.NET suppsoed to make things easier?  Why wou...

Getting the contents of index.cgi instead of executed index.cgi
Hi, I trying to rebuild a failed server that was running Bugzilla 4.2.5. (I have DB backups from 4.2.5). I have installed everything and when I hit the main page I'm getting the contents of index.cgi instead of executed index.cgi. This is a Windows installation and I added the registry entry for .cgi but for some reason it will not execute it but instead displays the content of the index.cgi file. How can I debug this? Thanks for any help. Pat ...

PLEASE HELP! w/Index Server, Indexing service query
Hello, I have set up indexing service via Index Server on my local machine. I have successfully created the catalog, set up the document directory and indexed the documents within my directory. I am having problems with the query not returning the document properties that I would like to see (such as DocTitle, DocAuthor, etc.) Everything works fine, except for the fact that the result set is not returning the data fields that I need. The search works great (as far as I can tell). I also installed the adobe ifilter so that index server can also search pdf files and that seems to w...

How make a query in terms of File Index value in Index Server ?
I'm writing a Search Query in Index Server SQL language. but not able to get the index value of any document in the Index Server. As this code            strQuery = "Select Filename,PATH from Scope() where FREETEXT('" +strsearchstrings+ "')";             string connstring = "Provider=MSIDXS.1;Integrated Security .='';Data Source="+strCatalog; as shown in the example above i want make a query in in terms of Index of the doc file stored in the Index Server.Is it possible? I tried but its not working out I dont know where the probl...

what is the Included no-index-key index column in SQL Server 2005?
is it the same performance and functions between index-key index column and Included no-index-key index column when queried by WHERE conditions and ORDER BY conditions?Parco LeeOwner + Webmaster + System Engineer + Professional ProgrammerSoftDweller Lab (a software laboratory)http://www.softdweller.comA professional laboratory for new technology softwares developing by .NET.http://www.nowlover.com Index column include is a fancy composite key, one of the key features of SQL Server 2005, it should be faster with the WHERE Clause but I cannot say about the ORDER BY because ANSI SQL puri...

Basic Index question :- nonclusted indexes which are a subset of a clustered index
Can anyone suggest why I would have the following set of indices upon a table: index1 clustered, unique field1,field,field3,fiel4 index2 nonclustered field2,field3, field4 index3 nonclustered field,field2,field4 The table is one into which a lot of inserts are done, so I would have thought that index2 & 3 would be unncessary since they're (1) already in the clustered index and (2) any inserts would triple the amount of index updates that are required... Are these assumptions correct ? Thanks in advance, Steve Hi, if you have a...

Error:Visual Studio .NET cannot create or open the application. The likeliest problem is that required components are not installed on the local Web server. Run Visual Studio .NET setup and add the We
Hi, I installed the IIS 5.0 after VS.Net 2003 (1.1). after that I did run the aspnet_regiis -i at the visual studio command prompt. I am able to run local web application created on my PC. But when I tried to copy an web application created at shared PC into the wwwroot folder, I get the following error while trying to open the project in VS.Net. I've created the virtual directory for the project and also set the integrated windows authentication under the directory security tab in the IIS. Please help me resolving the problem. Thank You.   Do you have FrontPage Server Ext...

Mapping HTML meta-tags to index server/indexing services variables
The HTML metatags “keywords” and “description” map very nicely to the Index Server variables “Characterization” and “DocKeywords”. So I can easily query the content of these meta tags in my web site search function: <meta name="keywords" content=" "> = Index Server: Characterization <meta name="description" content=" "> = Index Server: DocKeywords I’m looking for some more place to store information in HTML-pages that can be retrieved by Index Server. Are there any other HTML tags that are indexed by Index Server? For instance wha...

Visual Studio .NET cannot create or open the application. The likeliest problem is that required components are not installed on the local Web server. Run Visual Studio .NET setup and add the Web Deve
I installed Visual Studio .NET 2003 on Windows Vista Home Premuim, but I'm unable to select "Web Development" item from "Server Components" during the installation. I installed all the pre-requisits but I can not see Front Page Server Extention in the programs. I can see also the IIS. Appreciate if any one can guide me with the solution.   Thanks.   FPSE is not included with Vista, it's a separate download.  See www.iis.net for this. JeffPlease: Don't forget to click "Mark as Answer" on the post that helped you. Tha...