Forum Replies Created

Viewing 15 posts - 6,781 through 6,795 (of 7,506 total)

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

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

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

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • 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 ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

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

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

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

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

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

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • RE: Sql 2K to SQL 7.0

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

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

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

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • RE: Index Page VS Data Page

    Check

    - Table and Index Architecture in BOL

    - http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp

    - http://www.sqlservercentral.com/columnists/sjones/sqlserver2000indexing.asp

    - http://www.sqlservercentral.com/columnists/dharris/indexesanoverviewandmaintenanceforperformance.asp

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • RE: Switching recovery models

    To perform PIT(point in time)-recovery we perform log-backups before every other type of backup.

    If you are not interested in PIT-recovery, you can fall back to other ways :

    - make frequent full...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • RE: Excel/SQL Server - Limit Access To Authorised Data?

    You could start with a simple view test.

    Start sql Query analyser and build a query the has all the security-features in it wich you desire.

    E.g.

    Create Myview

    as

    Select mycol1 from sales...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • RE: Hide SQL server instance(s)

    Hi Brian,

    You'll off course have to select the server-instance which you want to alter the tcpip properties.

    I have a server with 3 virtual instances and all 3 are listed in...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • RE: Excel/SQL Server - Limit Access To Authorised Data?

    If you can build the query/procedure which contains the mechanism to determine "their clients" only, you can implement that.

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

  • Viewing 15 posts - 6,781 through 6,795 (of 7,506 total)