Viewing 15 posts - 1,696 through 1,710 (of 2,462 total)
script out the backup and post here.
second what Msg Id, Severity, Error Message you got in error message
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 1:09 am
Your message doesnt show any thing bad here.
See the sql error log at the time when backup got failed . if you didnt get any thing there.again try to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 12:58 am
yes you can create
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 12, 2010 at 6:12 am
-Shree (5/11/2010)
the query did started running..but it is taking ages!!Seems like its gonna be a long day!!!!
Also check the exec plan to see how indexes are playing there.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 12, 2010 at 6:03 am
-Shree (5/11/2010)
where a.CONO = '10' and c.Branch= '43'
try where a.CONO = 10 and c.Branch= 43
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 11, 2010 at 6:12 am
GilaMonster (5/11/2010)
Does it use the nc index then join back to the cluster/heap to delete?
You mean to say Key Lookup ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 11, 2010 at 4:19 am
turkey-500673 (5/10/2010)
Thanks for the great solutions, but none of them worked.
But why ? , Did you get stuck somewhere ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 10, 2010 at 11:51 pm
sqlwars (5/5/2010)
I checked the web and there was a solution to create a proxy account, but i am not sure how. will it help?
It will work perfectly for your...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 10, 2010 at 1:39 am
Try to use this
CREATE FUNCTION GPDivNErr(@Val1 float, @Val2 float)
RETURNS float
AS
BEGIN
DECLARE @MyVal FLOAT
IF @Val2=0
SELECT @MyVal = 0
ELSE
SELECT @MyVal = @Val1/@Val2
RETURN @MyVal
END
--select dbo.GPDivNErr(2,2)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 10, 2010 at 1:30 am
dhaval_dsa (5/10/2010)
difference between after trigger & instead of trigger?
google it , you will get good and satisfactory link/details about it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 10, 2010 at 1:24 am
sk.sarim (5/10/2010)
while creating a view use nolock in ur create view statement, and then try it. for ex:
CREATE VIEW...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 10, 2010 at 12:59 am
nialltuohy (5/9/2010)
would you feel that is a more suitable method than my original post?
Well it depends. 🙂 . Better to test Vladan's query with heavy data volume on...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 10, 2010 at 12:08 am
try to use WITH RECOMPLIE option with SP.might be OFF exec paln be reason of slowness
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 9, 2010 at 12:17 am
back up and job wil run in two different trnsactions so there would be no conflict but i am not sure that if backup is ON and job get...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 9, 2010 at 12:02 am
mahesh.vsp (5/7/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 8, 2010 at 11:15 pm
Viewing 15 posts - 1,696 through 1,710 (of 2,462 total)