Viewing 8 posts - 1 through 8 (of 8 total)
If you want to do this using a stored procedure, maybe the code below will help...
DECLARE @RowCnt int
CREATE TABLE #DirList (RowId int IDENTITY (1,1), OneField varchar(2000))
INSERT INTO #DirList
EXEC master..xp_cmdshell...
March 31, 2004 at 4:40 am
24 hours to run a report on a 12 million rows table sounds a bit excessive if you ask me. Have you defined any indexes on your tables referenced...
September 16, 2003 at 12:36 am
Just a word of WARNING on the query below:
SELECT *
from XXX
where R1 in (select R1
from XXX
group by R1
having count(*) = 1)
It is NOT the same as DISTINCT!!!!
It will ONLY return...
August 27, 2003 at 1:38 am
Something else to try
(Found this code on one of these useful SQL Server websites and it works pretty well for me) :
/*
SQL Script for Comparing the Contents of Two...
August 27, 2003 at 12:33 am
When you say it doesn't work, what exactly do you mean? Syntax error or no results returned?
I would have just added a alias for the derived table used, e.g.
SELECT...
August 27, 2003 at 12:27 am
Hi there
I'm by no means a guru, but have thought about this issue myself recently. Haven't done it yet, but maybe my initial train of thought might help you...
August 21, 2003 at 1:54 am
Hi there
I'm by no means a guru, but have thought about this issue myself recently. Haven't done it yet, but maybe my initial train of thought might help...
August 21, 2003 at 1:05 am
quote:
Have you taken a look at your indices? Are they consistent between your development and live environments? Another thing is...
August 7, 2003 at 3:54 am
Viewing 8 posts - 1 through 8 (of 8 total)