Viewing 15 posts - 19,546 through 19,560 (of 26,490 total)
Still using a simple table, but probably meets your requirements. Each run of the query took approximately 8 seconds.
declare @PageNum int,
@RowsPerPage...
July 24, 2009 at 9:52 am
michael vessey (7/24/2009)
as i said, this might be a huge query with maybe 15 tables
so your example of
with PagedData as (
select
...
July 24, 2009 at 9:50 am
This is really weird. Is there anything else running on the servers? Anti-Virus software, etc?
July 24, 2009 at 9:46 am
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?...
July 24, 2009 at 9:41 am
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
...
July 24, 2009 at 9:31 am
Only if it is running a virtual machine running a Windows OS. SQL Server can't be installed directly on a non windows OS.
July 24, 2009 at 9:08 am
Gift Peddie (7/24/2009)
No comprehension problem, you are blaming Toshiba for your failure to properly protect your work should you experience a hardware failure.
Do I have it right?
Actually no data backup...
July 24, 2009 at 9:05 am
Actually Jeff, please do post the url when you find it.
July 24, 2009 at 8:51 am
Gift Peddie (7/24/2009)
July 24, 2009 at 8:49 am
Gift Peddie (7/24/2009)
July 24, 2009 at 7:35 am
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.
July 24, 2009 at 7:29 am
TAman (7/24/2009)
WHERE DATEDIFF(mi,L1.Start_Entry,L2.Start_Entry) < 60 AND Start_Entry BETWEEN '07/01/09' AND '07/23/09'
I get...
July 24, 2009 at 7:27 am
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...
July 24, 2009 at 7:14 am
Srikanth Anumalasetty (7/24/2009)
Ok, i have another question. Whether a table with ntext column having 1 million records occupy 7GB space?
Consider this, each row of the ntext (or nvarchar(max)) column could...
July 24, 2009 at 7:11 am
Viewing 15 posts - 19,546 through 19,560 (of 26,490 total)