Still using a simple table, but probably meets your requirements. Each run of the query took approximately 8 seconds.

declare @PageNum int,

@RowsPerPage...

michael vessey (7/24/2009)

---

that's not really do-able for me

as i said, this might be a huge query with maybe 15 tables

so your example of

with PagedData as (

select

...

This is really weird. Is there anything else running on the servers? Anti-Virus software, etc?

Gift Peddie (7/24/2009)

---

dont think I quite understand, Code is simply data if you could recover all your data then why are you not able to recover all your code?...

Something like this?

declare @PageNum int,

@RowsPerPage int;

set @PageNum = 1;

Set @RowsPerPage = 10;

set statistics io on;

set statistics time on;

with PagedData as (

select

...

Only if it is running a virtual machine running a Windows OS. SQL Server can't be installed directly on a non windows OS.

Gift Peddie (7/24/2009)

---

Actually no data backup...

Actually Jeff, please do post the url when you find it.

Gift Peddie (7/24/2009)

---

Ok I am assuming there is a comprehension problem here data is just part of what is lost recovery from data pedestrian. While code is not so...

No.

Gift Peddie (7/24/2009)

---

I had backup but data backup and development backup are not the same that is the reason software development companies sell source control systems. So the only...

Could be how the data was moved around in the datapages as it was converted. More pages could have been allocated to store the same amount of data.

TAman (7/24/2009)

---

I think we are really close, but when I add a date range in my WHERE clause(see below)

WHERE DATEDIFF(mi,L1.Start_Entry,L2.Start_Entry) < 60 AND Start_Entry BETWEEN '07/01/09' AND '07/23/09'

I get...

Yes, you also need the cast to varchar(17) for ProjectID in the select statement as well. Good catch, be sure to do it in the third query in...

Consider this, each row of the ntext (or nvarchar(max)) column could...