Forum Replies Created

Viewing 15 posts - 10,546 through 10,560 (of 49,552 total)

  • RE: alter file

    How much usage does TempDB see? How much of that 50GB gets used?

    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

    December 27, 2013 at 5:11 am

    #1676053

  • RE: Table Structure

    kapil_kk (12/27/2013)

    But if I add few column of non clustered index to unique constraint columns then also uniqueness will be retained.... so in that case can I go with this

    Yes,...

    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

    December 27, 2013 at 4:28 am

    #1676050

  • RE: Clustered Index

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    And look in Books Online, lots of material on indexes in there.

    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

    December 26, 2013 at 2:00 pm

    #1676015

  • RE: I can't attach my database to SQL Server 2008 Instance

    MohamedDBA (12/25/2013)

    But the compatibility level of the database is - SQL Server 2008 (100) , and this database was created on SQL Server 2008 before I attach It to SQL...

    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

    December 26, 2013 at 1:59 pm

    #1676014

  • RE: Physical Operators

    ramana3327 (12/25/2013)

    Please tell me which is the very bad performance issue.

    All of them. None of them.

    If there was a join operator that always was a performance problem, why would...

    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

    December 26, 2013 at 1:55 pm

    #1676012

  • RE: Table Structure

    kapil_kk (12/24/2013)

    GilaMonster (12/24/2013)

    kapil_kk (12/24/2013)

    Should I drop unique constraint and make non clustered index only or add more column in unique constraint instead of creating another nonclustered index?

    If the index 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

    December 26, 2013 at 1:43 pm

    #1676011

  • RE: Compiling a stored procedure

    cboneill181 (12/24/2013)

    Does SQL Server check to see if the object exists, and if it does it verifies the column names, and if the object doesn't exist it lets you compile...

    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

    December 24, 2013 at 8:43 am

    #1675783

  • RE: Table Structure

    kapil_kk (12/24/2013)

    Should I drop unique constraint and make non clustered index only or add more column in unique constraint instead of creating another nonclustered index?

    If the index is there to...

    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

    December 24, 2013 at 7:21 am

    #1675774

  • RE: My log file became not available and the database went into Recovery Pending mode

    ALZDBA (12/24/2013)

    could you please add @@version information of that instance ?

    Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)

    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

    December 24, 2013 at 7:10 am

    #1675772

  • RE: My log file became not available and the database went into Recovery Pending mode

    tjaybelt (12/24/2013)

    Log entry:Error: 3314, Severity: 21, State: 1.

    During undoing of a logged operation in database 'ILCentralDataEnt', an error occurred at log record ID (386988:95874:18). Typically, the...

    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

    December 24, 2013 at 7:09 am

    #1675771

  • RE: dm_db_index_usage_stats - lookups

    You will only find lookups > 0 on clustered indexes. It is the number of key lookups that are done *to* that clustered index after a seek operation (or sometimes...

    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

    December 24, 2013 at 5:39 am

    #1675757

  • RE: Log dumps/loads

    Hard to say anything useful from across the network, but if the output says that a directory doesn't exist, that's what the error is.

    Double-check what account the job is running...

    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

    December 23, 2013 at 8:29 am

    #1675631

  • RE: Log dumps/loads

    Steve-0 (12/23/2013)

    D:\MSSQL.1\MSSQL\Backup\dailyprocessLog.bak

    1 File(s) copied

    The system cannot find the path specified.

    Have you checked that all paths referenced in that job step exist and are accessible

    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

    December 23, 2013 at 7:33 am

    #1675606

  • RE: Log dumps/loads

    Edit the job, go to the advanced properties of the step and log output to file. There's nothing in the message you posted that is useful, the output of the...

    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

    December 23, 2013 at 7:04 am

    #1675596

  • RE: Serious intermittent performance issues

    It may be worth looking through the codebase for other similar procedures. I've typically found that if this kind of pattern is used in one place, it's used in a...

    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

    December 23, 2013 at 5:37 am

    #1675563

Viewing 15 posts - 10,546 through 10,560 (of 49,552 total)