0
votes
0answers
204 views

Unique index failed?

Recently, we've been having some kind of memory leak in SQL Server. We do have a .NET assembly running to audit our tables, but this has ran for a few years without problems, so I doubt it's the ...
1
vote
1answer
263 views

Rebuilt nonclustered indexes quickly get fragmented again

I've got a couple of nonclustered indexes on tables that have rows inserted quite often. These indexes are currently around 90% fragmented, according to SQL Server. If I rebuild them, they go down to ...
1
vote
3answers
387 views

Rebuilding the Management Studio Index in SQL Server 2005

Does anyone know if using the SQL Server Management Studio Index Rebuild, rebuilds the index online or offline? Reading the help documentation doesn't say anything on this (so I would assume it is ...
2
votes
1answer
268 views

Index reorganizing slow after index rebuild

Why does index reorganizing take 3 times longer after I make an index rebuild? I wasn't sure if this happens every time, so I made a test for the last month. I configured SSMS to execute Index ...
1
vote
1answer
270 views

Index fragmentation and reorganizing database pages

Say you have a database with heavy index fragmentation. Say this database also has a lot of free space due to frequent deletes in its data file. This free space is not contiguous. If I rebuild all ...
1
vote
2answers
119 views

MSSQL 2008R2: Phantom Index Updates

I was trying to run the following query: Update A SET A.Col1 = B.Col1, ... A.ColN = B.ColN FROM A INNER JOIN B ON (A.Col1 = B.Col1) WHERE B.Col2 = ...
1
vote
2answers
582 views

Error on creating index on table in sql server, how to fix it?

On creating clustered index on table in SQL SERVER 2008 (LIVE DB) got above error. Total records in table is 1046789. I have created same index on test db with same number of records and it ...
0
votes
1answer
636 views

SQL Server - Alter Index reorg or rebuild to change fill factor

If I change the fill factor of an index, to make the change effective do I have to rebuild the index using "alter index rebuild" or can I also use "alter index reorganise"?
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 ...