To Index or Not To Index or How To Index
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...Need help running query on Indexing Server in VB.NET with VS2005
In a web project I am trying to run a simple query on a catalog off of our Microsoft Indexing server. I'm having a couple of problems.
#1 - The tutorials keep refering to a view inside the catalog, but my server admin doesn't know what that means. How do we find the view name?
#2 - The line: Return oCommand.ExecuteReader() returns this error;Incorrect syntax near '-1.'. Expected end-of-file, ';', AS, CREATE, DOT, DOTDOT, DOTDOT_SCOPE, DOTDOTDOT, DOTDOTDOT_SCOPE, DROP, ORDER_BY, SELECT, SET, WHERE. SQLSTATE=42000The query being executed is: SELECT ...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...HighLight on Index Server... Help Please :-)
I have an index server already setup, and it performs nicely.. well above what i thought it would be able to do.. but now i need the option to highlight the document text. (ex. if i have a huge document and im looking for a word in the document, and index server comes back with 30 hits in that document, i would then like the code to highlight each occerence of that word in the text.) Does any one know how to do this.. or have any good links??...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...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...index server/indexing service win2003 or Vista no search result, possible solution
So, I've set up a new indexing solution for a client. I've hade some major issues getting this setup to work, but this morning finally got it to work.
Assuming the account that's running your indexing service has access to the files and everything else is set up correctly, and you cannot get a search result returned, try going to the folder and check "index this folder for faster..." In "good old" NT you didn't have to check this option, as it didn't exist....
I could see the files getting indexed in the MMC, but on some catalogs the result wasn'...PLEASE HELP! Microsoft Indexing Services/Master Page Content.
I am using Microsoft Indexing Services to index my web site. The problem is that all my .aspx pages use Master Pages. It appears that the content is not properly indexed.
How can I get my Content placeholder code to be properly indexed? Do I have to write my own .aspx mapper for IIS ?
I just came accross your post four months after you wrote it. Did you ever figure this out? I am stuck with the exact same problem. I implemented a hundred page website with master pages, and when I went to implement the search functionality, I found that I can&...Management Studio - How to index tables based on query
We are using SQL2005.
I have a stored proc that runs a Select query based on a complex view.
The sproc has two input date parameters (StartDate and EndDate).
We are experiencing SQL timeout problems when the sproc is run with certain Start and End Dates.
We have run the SQL Profiler and created a trace (trc) file (We've used the 'Default' trace configuration).
We have used the trace file in SQL Server Management Studio to try and automatically create indexes on some of our tables.
Unfortunatly SQL Server Management does not make any index recommendations.
I think we are not capturing ...Using Indexing Service Catalog Without Indexing Service Running
I am developing an application where I need to allow users to search through a bunch of HTML files. I know this is easy using Indexing Service, but I will not have access to the Web Server in order to set up an Indexing Service Catalog there. Is it possible for me to create the Indexing Service Catalog on my local machine and then use the catalog on the Web Server without needing to set it up on Indexing Server? I basically want to move the catalog I created locally to the web server and query it without Indexing Service running. Is this possible?
No. I don'...Indexing server and hiding content when indexing?
I'm now struggeling a bit to long with this problem and I really hope that somebody can help me. When indexing server indexes pages it reads from the top, which means that the only thing that shows in the search result is the navigation rather then the unique content of the page.
I know that by adding meta description to the pages that indexing server will show this description in the result. However this will not solve the problem with all the pages I now need to index.
Most search engines I know works with <noindex>-tags. Something like that ...indexing server query
I would like to group by with an indexing service query. I keep getting syntax errors. I need to group on the Year(write) and Month(write). I understand the date format of the write field is different so how can i convert the write format to a format the Year() function can process and can I do this anyway?
string mysearch = "select Year(write) as Yr, Month(write) as Mth, filename, Directory, HitCount from SCOPE('\"" + mypath + "\"') GROUP BY Yr, Mth ";
You have to group by all of the fields in the select ...Please help me: DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of
I'm using Dotnetnuke v3.2, when add 1 module, I got this error "Error: Edit is currently
Object reference not set to an instance of an object. --->
System.NullReferenceException: Object reference not set to an instance of an
object. at DanPhong.DNN.Modules.DDTS.DDTSEdit.btnAddNew_Click(Object sender,
EventArgs e) in d:\dnn3\desktopmodules\ddts\ddtsedit.ascx.cs:line 95 --- End of
inner exception stack trace ---"Please help....How will I fix this error? Thanx!
Looking at the error y...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...