Questions tagged [indexing]

94 questions
0
votes
1 answer

Creating a HTML index of documents (PDF,PS) for a knowledge base

I've been looking for a command line / Linux-friendly "index" generator. I want to load PDF, PS, DOC and other documents and generate a static (X)HTML frame-based interface, as a knowledge base of sorts. Essentially I will rely on the individual…
soze
  • 101
  • 2
0
votes
1 answer

Add index to very large SQL Server table

I've got a table with 9 million rows (just received it from our underwriting provider). 4 columns -- leadid (guid), RawLeadXML (nvarchar(max) that contain an xml doc in each row that is 2-3kb), LeadStatusID (int), and id (autonumber int, I just…
Matt Dawdy
  • 429
  • 1
  • 9
  • 19
0
votes
3 answers

Explaining the MySQL Indexing

On my journey exploring MySQL and its advanced features, especially regarding the performance optimization I bumped in some extremely important feature for SQL performance improvement mos of us knows just as "Index" I went on with some…
Cninroh
  • 268
  • 3
  • 13
0
votes
1 answer

Storing logfiles in a searchable format

We want to store logiles so that they are easily searchable and available for extended periods of time. The problem is that there are multiple servers that needs to be archived. I've looked in to a few database based solutions. Database is pretty…
Ressu
  • 246
  • 1
  • 5
0
votes
1 answer

Index rebuild stored procedure fails while calling temporary table

SQL Server 2008 Enterprise on Windows Server 2008 Enterprise Cluster that is used to support SharePoint 2007 and 2010. We have a weekly index rebuild job that first checks the index fragmentation, and if there is greater than 10% fragmentation then…
Ddono25
  • 165
  • 2
  • 13
0
votes
1 answer

Can I use a Google Appliance/Mini to crawl and index sites I don't own?

Maybe this is a stupid question, but... I am working with this company and they said they needed to get "permission" to crawl other people's sites. They have a Google Search Appliance And some Google Minis and want to point them at other sites to…
John B
  • 171
  • 1
  • 11
0
votes
3 answers

Google APPS site - not being indexed

Help! Google crawlers appear to be visiting my site but it is not getting indexed, what am I doing wrong? Yahoo has managed to find the mydomain.appspot.com and has indexed successfully (albeit on the apspot address and not my domain) so I assume…
user47122
0
votes
1 answer

Adding FK Index to existing table in Merge Replication Topology

I have a table that has grown quite large that we are replicating to about 120 subscribers. A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing issues it had this to say --> /* Missing Index…
0
votes
0 answers

Changing database Elastic Pool disturb the indexes of the database

I have more the 5000 database and 15 Elastic Pools in Microsoft Azure and when I feel the database performance issue we change the Elastic Pool of that database. But today I note that our database indexes disturbed while changing the Elastic…
0
votes
0 answers

In Windows cmd, does `dir /s` bypass the index?

I believe the answer to this question is Yes it does, but I can't find any source to confirm. The question is, if I'm in a cmd box at the root of a drive and I do dir /s does Windows simply search of the entire drive, bypassing the…
RolfBly
  • 101
  • 4
0
votes
0 answers

Why windows search index differently on each Windows server?

I need to check the patching status on 20 Windows Server 2016 with similar configuration. So I remote control (mstsc) into each server, click the Window icon at left bottom, type in "installed" to look for View installed updates. All the servers…
Mark
  • 217
  • 3
  • 11
0
votes
1 answer

Workaround for Windows Search/Indexing on a deduplicated volume

According to Microsoft, Microsoft Windows Server 2019 still does not support Windows Search on Data Deduplication enabled volumes (source): Windows Search doesn't support Data Deduplication. Data Deduplication uses reparse points, which Windows…
stackprotector
  • 445
  • 1
  • 3
  • 20
0
votes
0 answers

indexing options hangs on waiting to receive indexing status

I’m using WS 2019 as a cloud server (AWS Lightsail). I have Office 2016 installed with about 15 RDS users. Already tried DISM .../restorehealth and sfc /scannow. Problem occurs with 2 of the 15 users, including the server's admin (and domain admin)…
BobH
  • 1
0
votes
1 answer

How to prevent search engines indexing a specific url

I have a url which i don't want indexed: http://www.mysite.com/moduleA?param=secretkey So when i google search for "mysite.com", i don't want the above link to appear in the search results. However, the following urls are part of public…
Parag
  • 123
  • 5
-1
votes
1 answer

Rescanning specific folders with Windows Indexing service

I need to know if there is a way I can automate rescanning certain folders within Windows Indexing Service. Possibly through a batch file or something like that. I have several hundred folders that need to be rescanned and I don't feel like…
Kevin
  • 105
  • 1
  • 2
  • 6