Hi

If I take off the order by Desc on both columns or change it to Asc, then it runs really  really quick.

But users are more interested in the latest profile...

David,

To also add, please check your PM's

sorry David, this is the query

SELECT PERSONURN, ADDRESSURN, PROFILEDATE,CLIENTNO, STATUS

FROM VwQuery

WHERE LISTID = 'L01'

AND PROFILEDATE BETWEEN '2007-02-01 23:59:59.000' AND '2007-03-19 20:11:23.000'

The query spans over two months, so...

Just to add to what David said, I'm using it as I want to be able to do filegroup backups, as I know that its only the recent month that...

The query below is the query I'm actually running, and its just the order by thats giving problems, the order by is also needed as the most recent profiledate is what...

Sorry for the mistake in the query, the group by isnt there, so you are right. but on a different note, I used your query and the performance was still...

Sorry for the query, I havnt got the exact query here with me, but I do know it has a group by on those 2 columns, it looks something like...

Hi Guys,

Thanks for all your efforts, I will explain the problem further.

To start with, below is the DDL

CREATE TABLE [dbo].[PersonProfile_2007_01] (

 [PersonURN] [varchar] (30),

 [AddressURN] [nvarchar] (50) ,

 [ProfileDate] [varchar] (10)  ,

 [LISTID]  [varchar] (10), ...

The only reason why I am intending to use partitioned view is that I can manage the underlying tables easily, i.e index rebuild time for a monthly table is lesser...

Thanks guys for the info:

One other question I have is that, if you have a partitioned table based on dates, i.e January, February, ....

If you need to delete data for...

I agree that these indexes are best left alone, but one thing is that they can be rebuilt, as I have done this before.

I wouldn't recommend that you do this...

Hi John,

I don’t know about creating replication articles on a daily basis, can this be scripted, and how reliable is this to automate with the ability to let it run...

Hi Guys,

Thanks for the reply, just been away for a well deserved break.

The reporting server needs to be near real time, sasy 2 hrs behind from current time during peaka...

Hello Colin,

Thanks for reply, I am still a bit mystified.. The curent situation is that, I have a reporting loader which inserts into a big massive table 24...

One more question that I have, if you have the indexes seperate, does this take up more space ?, compared to having 2 keys in one index.

Thanks