Forum Replies Created

Viewing 15 posts - 46 through 60 (of 60 total)

  • RE: Backing up transaction log

    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:

    http://www.sqlservercentral.com/search/?q=gilamonster&t=a

    :thumbsup:

  • RE: Backing up transaction log

    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.

  • RE: Backing up transaction log

    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...

  • RE: Convertion problem

    Thank you GilaMonster.

  • RE: Update Trigger on multiple columns

    Jeff Moden (3/11/2011)


    M Joomun (3/11/2011)


    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...

  • RE: Update Trigger on multiple columns

    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...

  • RE: Stored Procedure problems

    Jeffrey Williams-493691 (9/6/2010)


    What is the data type of your duedate column? If it is a datetime - are the dates always at midnight, or will they have a time?

    Most...

  • RE: Stored Procedure problems

    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....

  • RE: Stored Procedure problems

    Abhijit More (9/6/2010)


    okay just putting my understanding what you are looking for is

    If @assayid int > Then search by @assayid

    and

    If @dateassayrequested datetime is Valid date Then search by datediff

    If...

  • RE: Stored Procedure problems

    ashish.kuriyal (9/6/2010)


    ok, next try then

    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...

  • RE: Stored Procedure problems

    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.

  • RE: Stored Procedure problems

    ashish.kuriyal (9/6/2010)


    i think it could be because of :-

    (@assayID = 0 OR assayid = @assayid).

    can you set the @assayid = 0 on top and then @assayid = whatever passed.

    In this...

  • RE: User Role

    Thanks very much. I'll give it a go.

  • RE: Check constaints

    Thanks very much for the reply. I'll give it a shot.

  • RE: SQL Server 2005 Minimum hardware requirements

    Thanks for your responses. I think the 1GHZ processor check is what caused the problem!

     

    Mo

Viewing 15 posts - 46 through 60 (of 60 total)