Forum Replies Created

Viewing 15 posts - 6,736 through 6,750 (of 7,466 total)

  • RE: recovery from different server.

    Don't use the copy database wizard because it detaches the source-db for a while (and reattatches it).

    You may want to consider using restore using UNC.

    Restore database MyDb

    from DISK = '\\myserver\disk$\msSQL\BACKUP\mybackup.BAK' 

     with...

    January 21, 2005 at 3:16 am

    #538464

  • RE: SQL Backup causes Unexpected Shutdown

    No Idea.

    check :

    - windows event logs

    - sqlserver logs

    - sqlagent logs

     

    January 21, 2005 at 3:11 am

    #538463

  • RE: Are clustered index columns actually usable in non-clustered indexes?

    That's why you 'll want to have your clustering keys as small as possible.

    All your NCI's will be affected because they nolonger...

    January 21, 2005 at 3:09 am

    #538462

  • RE: ''''Wait Statistics''''

    Check out Gert's article : 

    http://sqldev.net/articles/WaitTypes.htm

    January 20, 2005 at 12:52 am

    #538234

  • RE: SQL 2000 Restore Operation Failing

    - can you post your restore statement ?

    - can you post the execution report containing the error(s) ?

    January 20, 2005 at 12:47 am

    #538232

  • RE: user not able to run jobs

    only sa can run jobs he/she does not own.

    you might consider a workaround using alerts which launch the wanted job.

     

    January 20, 2005 at 12:42 am

    #538231

  • RE: Poor Trigger Performance - Why?

    Are there other users in the db/tb when you run your test(s).

    Because you are performing another tableaction

    SELECT MIN(PremInstalmentDate)

              FROM tblPremPolicyPremium

              WHERE PremPoliID = PoliID

               AND PremDeleted = 'N'

               AND PremIncludeInTotal = 'Y'

              GROUP BY PremPoliID

    January 19, 2005 at 8:10 am

    #538087

  • RE: SQL Jobs failing to run a DTS

    can you explain what's happening in step 1 of your package.

    If it is fileaccess, your user Domain\sqladmin may not have access-authority to that file.

    If you want to check it...

    January 19, 2005 at 4:53 am

    #538022

  • RE: T-SQL brain teaser, tricky sum for employee data.

    maybe this is a good starter

    select Subsel.EMPLID, Subsel.EFFDT, sum( C.AMOUNT ) as TotAmt

    from (select J1.EMPLID, J1.EFFDT

    , isnull((select dateadd(ms,-3,min(J2.EFFDT) )  from PS_JOB J2 where...

    January 19, 2005 at 4:41 am

    #538017

  • RE: Poor Trigger Performance - Why?

    can you post the full ddl of the table/indexes/triggers ?

    Just to check : There is an index defined for PoliID ?

    January 19, 2005 at 12:41 am

    #537987

  • RE: Index Page VS Data Page

    An other difference is that nonclustering indexes have the actual RID (page-row-address) when there is no clustered index defined for the object.

    If there is a clustered index defined, it contains a...

    January 19, 2005 at 12:34 am

    #537986

  • RE: Poor Trigger Performance - Why?

    How about :

    Set Nocount On

    IF UPDATE(PoliInstalments)

     UPDATE tblPoliPolicy

     SET PoliSettlementDueDate = Min_PremInstalmentDate

     FROM 

    ( SELECT PremPoliID , MIN(PremInstalmentDate) as Min_PremInstalmentDate

              FROM tblPremPolicyPremium T1

                 inner join Inserted I2

              on T1.PremPoliID = I2.PoliID

               and T1.PremDeleted = 'N'

               AND T1.PremIncludeInTotal = 'Y'

              GROUP BY PremPoliID...

    January 18, 2005 at 12:18 am

    #537777

  • RE: Where clause on vertical Name/Value pair tables

    How about :

    SELECT A1.ProductID

    FROM tblProductAttributeValues A1

    inner join tblProductAttributeValues A2

    on  A1.ProductID = A2.ProductID

     and A2.Active = 1 

     AND A2.AttributeID = 15

    AND A2.AttributeValue =1

    inner join tblProductAttributeValues A3

    on  A1.ProductID = A2.ProductID

     and A3.Active...

    January 17, 2005 at 8:09 am

    #537680

  • RE: Sql 2K to SQL 7.0

    No, but you can use dts to export/import the data.

    January 17, 2005 at 7:57 am

    #537657

  • RE: Switching recovery models

    Basicaly simple recovery works like this :

    Your log is still in use for data-transaction-integrity. Once data gets committed, the space used in the log for that transaction is marked for...

    January 17, 2005 at 7:47 am

    #537656

Viewing 15 posts - 6,736 through 6,750 (of 7,466 total)