Viewing 15 posts - 46 through 60 (of 60 total)
homebrew01 (4/11/2011)
Basically, the transaction log contains the database activity that has occured since the previous backup (full, diff or tran log)Proper explanations & details here:
:thumbsup:
April 11, 2011 at 8:09 am
homebrew01 (4/11/2011)
I think the total size of you t-log backups should be about the same. One huge daily backup, or many small 20 minute backups.
Ah, did not realise that. Thanks.
April 11, 2011 at 4:53 am
Thanks for the replies. You've given me quite a bit of food for thought.
Unfortunately, our storage facilities are very limited and so backing up the transaction log as frequently as...
April 11, 2011 at 4:40 am
Jeff Moden (3/11/2011)
M Joomun (3/11/2011)
Jeff Moden (3/10/2011)
Before you even think of capturing only the changes and the columns names, very carefully consider...
March 14, 2011 at 3:55 am
Firstly, thanks to both of you for the replies.
Jeff Moden (3/10/2011)
Before you even think of capturing only the changes and the columns names, very carefully consider how you would put...
March 11, 2011 at 1:09 am
Jeffrey Williams-493691 (9/6/2010)
Most...
September 8, 2010 at 4:29 am
Abhijit More (9/6/2010)
try this....
select * from Purchasing.PurchaseOrderDetail
where case @OrderQty when 0 then OrderQty else @OrderQty end = OrderQty
and (@duedate IS NULL OR duedate = DATEADD(dd, DATEDIFF(d,0,@duedate), 0))
Thanks again.
There's no change....
September 6, 2010 at 8:35 am
Abhijit More (9/6/2010)
If @assayid int > Then search by @assayid
and
If @dateassayrequested datetime is Valid date Then search by datediff
If...
September 6, 2010 at 7:56 am
ashish.kuriyal (9/6/2010)
dateassayrequested = DATEADD(dd, DATEDIFF(d,0,@dateassayrequested), 0))
[/code]
is this perticualr code working ok?
because when I replaced your variable with current date, then I am getting as below result...
September 6, 2010 at 7:17 am
ashish.kuriyal (9/6/2010)
i mean something like :-@assayid int,
@dateassayrequested datetime
AS
if @assayid <>0 set @assayid = 0
and then your select statement
That makes absolutely no difference I'm afraid.
September 6, 2010 at 6:59 am
ashish.kuriyal (9/6/2010)
(@assayID = 0 OR assayid = @assayid).
can you set the @assayid = 0 on top and then @assayid = whatever passed.
In this...
September 6, 2010 at 6:50 am
Thanks very much for the reply. I'll give it a shot.
August 13, 2007 at 9:55 am
Thanks for your responses. I think the 1GHZ processor check is what caused the problem!
Mo
February 3, 2005 at 9:39 am
Viewing 15 posts - 46 through 60 (of 60 total)