Forum Replies Created

Viewing 15 posts - 19,981 through 19,995 (of 49,552 total)

  • RE: Login failure for non existing login filling SQL Error log

    No, you don't want the standard template, that's only got Audit Login and Audit Logout. I said trace the Audit Login Failure event.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 8:07 am

    #1453651

  • RE: Trying to figure out why this is a full table scan

    aurato (3/1/2012)

    GilaMonster (3/1/2012)

    aurato (3/1/2012)

    GilaMonster (3/1/2012)

    Chance the #StatusHistory temp table not the permanent table. You'll need to drop all indexes and constraints on that column first, change the data type and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 8:06 am

    #1453649

  • RE: Trying to figure out why this is a full table scan

    aurato (3/1/2012)

    GilaMonster (3/1/2012)

    Chance the #StatusHistory temp table not the permanent table. You'll need to drop all indexes and constraints on that column first, change the data type and then recreate...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 8:02 am

    #1453645

  • RE: SQL Server Licencing

    Only if you can't count the users (eg internet facing)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:59 am

    #1453642

  • RE: Question about the use of [] in queries...

    Personally the only time I use them is when I have an object named with an 'illegal' name or when I'm writing generic (and dynamic) SQL and don't know what...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:58 am

    #1453641

  • RE: Trying to figure out why this is a full table scan

    Chance the #StatusHistory temp table not the permanent table. You'll need to drop all indexes and constraints on that column first, change the data type and then recreate the indexes...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:46 am

    #1453630

  • RE: Login failure for non existing login filling SQL Error log

    Use profiler and trace for the Audit Login Failed event, get the hostname and the application name and you should be able to see what machine and what application is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:44 am

    #1453627

  • RE: IS NOT NULL vs <> ''

    The first finds rows where the column is not NULL

    The second finds rows where the column does not equal an empty string.

    CREATE TABLE Blah (

    SomeString char(2)

    )

    Insert into Blah (null)

    Insert into...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:42 am

    #1453626

  • RE: Trying to figure out why this is a full table scan

    I suspect there are two main reasons this is a table scan.

    1) The data types of the two join columns don't match. They should be both char/varchar or both nchar/nvarchar

    2)...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:39 am

    #1453622

  • RE: Trying to figure out why this is a full table scan

    Eugene Elutin (3/1/2012)

    aurato (3/1/2012)

    Great Plains Query:

    -----------------------------

    SELECT * FROM SOP30300

    WHERE SOPNUMBE IN

    (

    SELECT SOPNUMBE FROM #StatusHistory

    )

    ...

    Have you ever heard of JOIN's in SQL?

    SELECT s.*

    FROM SOP30300 s

    JOIN #StatusHistory h ON h.SOPNUMBE...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:33 am

    #1453615

  • RE: Truncate log question

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:29 am

    #1453614

  • RE: SQL Server Licencing

    siva 20997 (3/1/2012)

    Then if I had 300 or so field operators who occasionly go on to the company website and login to see if they have any jobs

    (Say using PHP/Appache...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:29 am

    #1453613

  • RE: Question about the use of [] in queries...

    It's so that illegal identifiers won't break queries.

    CREATE LOGIN [!2hjasdsss.lksks stupid] WITH PASSWORD ...

    will work fine

    CREATE LOGIN !2hjasdsss.lksks stupid WITH PASSWORD ...

    Msg 102, Level 15, State...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:24 am

    #1453610

  • RE: Triggers to be avoided? ....

    Eugene Elutin (3/1/2012)

    If the OP compared time between "with trigger" to "using merge", and in both cases he did insert as many as 2.7 million rows into Audit Log (looks...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 7:19 am

    #1453609

  • RE: Triggers to be avoided? ....

    Well, note that with that trigger you're doing more than twice times the work of an update without it and affecting twice the rows, so without the trigger will be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 1, 2012 at 4:44 am

    #1453548

Viewing 15 posts - 19,981 through 19,995 (of 49,552 total)