1
vote
0answers
113 views

How to index document files in NAS storage?

I'm currently developing an application that have to index document files (.pdf and .doc) which are in NAS storage. After that I want to query them over the application. My customer does not want to ...
0
votes
1answer
5k views

How to create non-clustered indexes on a SQL Server 2008 database? Preferably without code?

I would appreciate help on how to create non-clustered indexes on a SQL Server 2008 database without using code--or rather, 'statically' once and for all prior to running any SQL queries (that ...
1
vote
1answer
58 views

How can I know that database indices are ok?

On Microsoft SQL Server 2008 how can I know or find out that database indices are regenerated?
0
votes
1answer
584 views

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 ...
2
votes
3answers
2k views

Large insert/update in table causes timeout while SQL Server re-arrange indexes

We insert/delete about 1 million rows of a two million rows table with SSIS. We have 20 indexes on this table. Right after the SSIS finished, we're experiencing timeouts in the frontend. The ...
0
votes
1answer
207 views

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 ...
4
votes
7answers
5k views

Best way to index this very large table

I have the following table CREATE TABLE DiaryEntries ( [userId] [uniqueidentifier] NOT NULL, [setOn] [datetime] NOT NULL, -- always set to GETDATE(). [entry] [nvarchar](255) NULL ) Each user ...
3
votes
4answers
12k views

How long does reindexing take on SQL Server?

I've inherited a very large and very messy database recently and need to clean it up. To give some idea of size, the primary database currently contains 3 big tables each with around 300 million rows ...
1
vote
1answer
409 views

Delay index build until SQL Server table load is complete with SSIS

I have a large table that I am updating. Is it possible to disable index updates on the destination table until the load is complete? It seems like a waste for it to be constantly updating the index ...
3
votes
2answers
137 views

When is an index not worth updating

is there an accepted ratio of reads to writes that makes an index worthwhile or is it less cut and dried than that? I am using this: WITH UnusedIndexQuery ( Object_ID, ObjectName, IndexName, ...
3
votes
4answers
767 views

Recommended SSD Setup

I'm building a new server which will be running a text search service for our online web services. This service requires fast IO so I am trying to further reduce any potential bottlenecks. I would ...
8
votes
2answers
2k views

Correct value for fill factor for clustered indexes with surrogate identity keys

I have a large table which has a clustered index with an identity primary key. I'm deciding on the correct value for the fill factor for this table to minimise page splits. We maintain indexes using a ...