Can I answer a question 11 years later?

Its a very picky thing but I have found this will make it work.  It can be used to do a...

Operations that can be minimally logged are minimally logged in both simple and bulk-logged recovery so I think your good to go. I just realized you have this posted...

I am fairly confident your not getting over 2000 IOPS from 2 disk.

I have a similar situation as you for my UAT server that is a Dell 510 with...

I would suggest you find out your percentage of reads to writes before deciding this. The limited hardware you have listed here isn't going to support a very busy database...

To provide some followup on what is going on with this. I removed the table from the partitioning and test the query with much better results. In fact...

Your version of the query ran in 30 seconds without any high disk latencies observed.

Wow I am so impressed. This is of great help for me in knowing what is going on. I really need to read this forum more I have...

Here they are

Plan using the hint still slow and very high latencies. So I guess I have achieved my objective to test the new hardware.

http://www.evernote.com/shard/s272/sh/7212dbd2-aeb3-423f-b5aa-0485027757e2/2d85a33fca98e3c0df2c41e4783f93d0

Yes sir, the Current production server does it in about 1 min. The new one takes from 4 to 7 mins. I did use the hint which I...

the query. Understand this was for a test of the server but I got more than I bargained for.

select top 10000 * from claims with (nolock) where...

CREATE NONCLUSTERED INDEX [IX_Claims_RecordDate_INC_ClaimID_UserID] ON [dbo].[Claims]

(

[RecordDate] ASC

)

INCLUDE ( [ClaimID],

[UserID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE =...

Table.

CREATE TABLE [dbo].[Claims](

[ClaimID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[SenderID] [int] NOT NULL,

[UserID] [int] NOT NULL,

[FileID] [int] NOT NULL,

[StrProviderID] [varchar](50) NOT NULL,

[ProviderID] [int] NOT NULL,

[PayToProviderID] [int] NULL,

[PayerID] [int] NOT NULL,

[AccountNumber]...

Absolutely understand and he said I can just now. So I will get all that together. There certainly wouldn't be a covering index for the query because we would...

Actually the table is over 100GB in size just data not counting indexes. This is a very large database (5TB) and the servers are very powerful with over...