Forum Replies Created

Viewing 15 posts - 20,251 through 20,265 (of 49,552 total)

  • RE: varchar to nvarchar

    Eugene Elutin (2/17/2012)

    GilaMonster (2/17/2012)

    An nvarchar(40) holds 40 characters.

    and its length is 80 bytes, to accomodate unicode...

    Its length is anything from 2 bytes to 82 bytes depending on the data stored...

    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

    February 17, 2012 at 8:07 am

    #1448537

  • RE: varchar to nvarchar

    An nvarchar(40) holds 40 characters.

    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

    February 17, 2012 at 7:48 am

    #1448509

  • RE: Stairway to SQL Server Indexes: Step 12, Create Alter Drop

    Charles Tsang (2/17/2012)

    Something worth keeping in mind is that Index reorganization uses the database's transaction log file as a working space.

    Rebuilding it allows the option of using the TempDB as...

    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

    February 17, 2012 at 7:03 am

    #1448475

  • RE: DTA - Database tuning advisor

    It's not looking for problems in the statements, it's not going to pick up sub-optimal coding practices. It's just looking to see if indexes and/or statistics are needed (and depending...

    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

    February 17, 2012 at 6:58 am

    #1448470

  • RE: Another Transaction Log Issue

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

    If it's just growing and growing then something is holding the log active, you need to find what it is and resolve it.

    Never shrinking 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

    February 17, 2012 at 5:38 am

    #1448424

  • RE: DTA - Database tuning advisor

    I think maybe you misunderstand how DTA works. When it's given a trace file, it tunes the statements in the trace file by either recommending or creating (depending on 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

    February 17, 2012 at 5:35 am

    #1448419

  • RE: DTA - Database tuning advisor

    Not sure I understand you.

    The numbers are to do with what DTA processed in the trace.

    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

    February 17, 2012 at 4:57 am

    #1448401

  • RE: DTA - Database tuning advisor

    Is there a question here?

    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

    February 17, 2012 at 4:38 am

    #1448397

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/14/2012)

    Steve Jones - SSC Editor (2/14/2012)

    Jeff Moden (2/13/2012)

    Shifting gears, I was going through the posts from "Posts added today" and there had to be two...

    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

    February 17, 2012 at 2:38 am

    #1448341

  • RE: Stairway to SQL Server Indexes: Step 12, Create Alter Drop

    phelmer (6/21/2011)

    When an index is created on that table (clustered or non-clustered), the command returns to the client very quickly to say "Completed successfully". It can't possibly have built 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

    February 17, 2012 at 2:36 am

    #1448340

  • RE: T-SQL Performance 1

    You might also have to remove the ID column to get a seek, depending how selective that column 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

    February 17, 2012 at 2:29 am

    #1448336

  • RE: Query optimization

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    February 17, 2012 at 2:21 am

    #1448332

  • RE: database upgrade

    Can't remember.

    Doesn't really matter, it's just a compatibility setting, nothing more. You want it at 100, set it to 100.

    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

    February 16, 2012 at 3:15 pm

    #1448194

  • RE: locking in sql server

    SQLKnowItAll (2/16/2012)

    If you don't know the answer to this, you probably should not be interviewing for the job.

    So tell me then, how do you (not the database engine) implement...

    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

    February 16, 2012 at 3:09 pm

    #1448190

  • RE: locking in sql server

    Err, you don't. The database engine takes care of locking for you.

    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

    February 16, 2012 at 3:06 pm

    #1448187

Viewing 15 posts - 20,251 through 20,265 (of 49,552 total)