Viewing 6 posts - 1 through 6 (of 6 total)
PW Your solution takes longer - 202 seconds.
Lowel - I did try datediff and it takes 93 seconds -
your example (takes 93 seconds)
select * from C_Tracked_Item_Hist
where datediff(d,ActivityDate,getdate()) > 7
my...
January 20, 2006 at 10:25 am
Field alredy has an index. If I do the following it runs fast, but I would like an alternate/better approach...
DECLARE
@sqlstr nvarchar(4000),
@DT DATETIME,
@DE char(13)
SET @dt = DATEADD(day, -7,...
January 20, 2006 at 10:08 am
? Please direct me to where I can set-up a maintenance plan. Is my problem that I was trying to do via enterpirse manager and not osql?
Thanks,
Sam
September 16, 2005 at 11:03 am
Throwing out things to try/check:
Has your firewall changed where it would deny port 1433 connections. Example Windows firewall can deny connection to the remote database. If it is turned on, check to make sure that...
August 18, 2005 at 7:44 am
SELECT DISTINCT name
FROM table1
WHERE NOT EXISTS
(SELECT name FROM table2 WHERE table1.name = table2.name)
July 26, 2005 at 7:19 am
Why not use MSDE on the disconnected machines (free lite version of SQL)? You can have them run scripts to update their local schema as it changes....
June 28, 2005 at 7:37 am
Viewing 6 posts - 1 through 6 (of 6 total)