Forum Replies Created

Viewing 15 posts - 7,591 through 7,605 (of 49,552 total)

  • RE: Book example doesn't work, how come?

    The problem is that SQL 2000 has been out of support for years and there's a fair number of database consultants who won't work on SQL 2000 databases any longer,...

    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

    October 7, 2014 at 11:52 am

    #1750727

  • RE: Are the posted questions getting worse?

    Sean Lange (10/7/2014)

    The upside is the end of the list should be approaching fast. 😀

    He's up to 2007. 🙁

    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

    October 7, 2014 at 11:47 am

    #1750725

  • RE: Trace File

    ramana3327 (10/7/2014)

    It is giving that the path doesn't exist msg.

    You've double-checked that there are no spelling mistakes in the script, the server you're running the trace against has a local...

    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

    October 7, 2014 at 8:11 am

    #1750595

  • RE: Why CTE should begin with semicolon or Go

    er.mayankshukla (10/7/2014)

    I had this doubt that why CTE should begin with semicolon or Go.

    It shouldn't.

    If the CTE is not the first statement in the batch, then the previous statement needs...

    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

    October 7, 2014 at 7:54 am

    #1750587

  • RE: Trace File

    What do you mean 'it's not working'?

    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

    October 7, 2014 at 6:32 am

    #1750542

  • RE: Performance of the new (2014) Cardinality Estimator

    Alan.B (10/6/2014)

    So it is whatever the default is - is what it is set at. I will tell you exactly tomorrow.

    Which means it'll be cost threshold of 5 and maxdop...

    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

    October 7, 2014 at 2:26 am

    #1750488

  • RE: Datatype to be changed from Varchar to Nvarchar

    Koen Verbeeck (10/7/2014)

    SQL Server will just use implicit conversions everywhere, which may impact execution plans and the use of indexes.

    However, since the column will be going to varchar, the implicit...

    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

    October 7, 2014 at 2:23 am

    #1750487

  • RE: Trace File

    Or, if they're different traces, rather than rollover files, by using INSERT INTO instead of SELECT ... 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

    October 6, 2014 at 1:38 pm

    #1750399

  • RE: Unable to pass the select statement to cursor to get details across each databases.

    What do you mean by 'unable'?

    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

    October 6, 2014 at 9:18 am

    #1750332

  • RE: Improving performance on slow running query

    Actual plan please, not estimated. The text plans are near useless because they're missing everything except the operator. Plus they're a pain to read.

    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

    October 6, 2014 at 9:06 am

    #1750329

  • RE: Improving performance on slow running query

    Text plan? You have a SQL 2000 server 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

    October 6, 2014 at 7:21 am

    #1750306

  • RE: Can someone explain some Indexing questions?

    why don't small indexes (especially PKs) get the same treatment?

    In short, because there's no point in doing so.

    There's no reason to rebuild small indexes. They won't benefit and the queries...

    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

    October 6, 2014 at 7:05 am

    #1750303

  • RE: Trace File

    HanShi (10/6/2014)

    If the second server doesn't have access to the D drive of the first server you first need to copy the physical file to an accessible location. Next 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

    October 6, 2014 at 6:56 am

    #1750297

  • RE: Trace File

    Copy the file to machine B, then use the SQL function fn_trace_gettable

    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

    October 6, 2014 at 6:48 am

    #1750292

  • RE: Improving performance on slow running query

    Index definitions and execution plan please.

    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

    October 6, 2014 at 6:05 am

    #1750277

Viewing 15 posts - 7,591 through 7,605 (of 49,552 total)