Ok, who has the crystal ball? I have a thread that appears to need some foresight or divination

http://www.sqlservercentral.com/Forums/Topic837021-392-1.aspx

What are the errors that you're getting? It is not possible to help you resolve errors if we don't know what they are.

Raghavender (12/21/2009)

---

select * from sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

I am getting the same index two or more times on same table with different fragmentations and different page numbers. in that...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

If you do use AWE, you need to set SQL's max memory to ensure it doesn't use too much and hurt the OS. Set max to 6.5GB at most.

Mark_Pratt (12/21/2009)

---

You will need to ensure that you have the /PAE (and maybe /3GB) switch in your boot.ini file and you have set the Enable the Lock Pages in Memory...

No. That's index 1, the clustered index. The...

One comment on the code.

USE [SAMPLE_DB]

GO

DBCC SHRINKFILE (N'SAMPLE_DB_Log2' , EMPTYFILE)

GO

use master

go

/* This next line works in the sample, fails in my actual database */

ALTER DATABASE [SAMPLE_DB]

REMOVE FILE [b]SAMPLE_DB_Log[/b]

GO

The...

Nope. It means exactly what it says. The...

32 bit or 64 bit?

If you're not sure, run this and post the output

SELECT @@version

An extent is a contiguous 8 pages. So, given that the first page in the database is page 0, the first extent is made up of pages 0..7. The second...

Can you post the revised execution plan (after Grant's improvments)? I'm interested in seeing if there are any opportunities for improving the indexing.

Why? What are you doing that requires explicit permission in TempDB?

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

You're probably not going to like my advice...

Normalise your table structure. Leave the non-repeating columns in the original table (call it Table1) and move all the repeating columns into a...