Forum Replies Created

Viewing 15 posts - 5,431 through 5,445 (of 49,552 total)

  • RE: Limit number of cores used per instance - Licensing

    NorthernDBA (7/2/2015)

    I'm not really comfortable with licensing (and please correct me if i'm wrong) BUT you have to license all cores that might be available to sql server and not...

    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

    July 2, 2015 at 6:25 am

    #1809823

  • RE: SQL Server 2016 Standard Edition features

    Almighty (7/2/2015)

    normal trend is that features of enterprise edition of earlier version are included in standard version

    No, it's not. In fact, the only feature I can think of that...

    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

    July 2, 2015 at 5:50 am

    #1809811

  • RE: SQL Server 2016 Standard Edition features

    The decisions as to what's Enterprise and what's Standard will likely be made much closer to release.

    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

    July 2, 2015 at 5:49 am

    #1809810

  • RE: CPU Test

    John Mitchell-245523 (7/2/2015)

    If any SPIDs have eight rows, then your change has been successful.

    No. MaxDop limits the number of running threads a query may have, not the total number of...

    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

    July 2, 2015 at 5:35 am

    #1809800

  • RE: Table variable in dynamic query

    Table variables are only visible in the scope where they are defined. They're like normal variables. Since you declared the table variable outside the dynamic SQL, it's not visible inside...

    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

    July 2, 2015 at 5:31 am

    #1809798

  • RE: advice on query tuning

    It's an inefficient split function, but whether it's the problem or not is impossible to tell from the information available.

    No, you can't move that to the client, because it's...

    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

    July 2, 2015 at 2:49 am

    #1809747

  • RE: Are the posted questions getting worse?

    jasona.work (7/1/2015)

    You know a topic is going in a bad direction when Gail starts copying-and-pasting a previous reply from the same topic...

    I don't recall doing that in the last couple...

    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

    July 2, 2015 at 2:24 am

    #1809741

  • RE: SQL Profiler and very high reads

    Zip the .sqlplan file and attach the zip. Since it's XML, it compresses very well.

    The one you captured from Profiler 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

    July 1, 2015 at 9:54 am

    #1809582

  • RE: autogrowth setting

    Look in Books Online (the SQL help documentation) on sys.master_files or sys.database_files for what the values mean.

    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

    July 1, 2015 at 9:13 am

    #1809542

  • RE: The New DBA

    Rod at work (7/1/2015)

    I have to respond to this, especially when you say that it appears there's a DBA/Developer factory pressing out people all using the same mold. That reminds...

    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

    July 1, 2015 at 9:10 am

    #1809538

  • RE: SQL Profiler and very high reads

    Can you post the query at least? The execution plan you captured would also be rather useful

    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

    July 1, 2015 at 9:00 am

    #1809532

  • RE: autogrowth setting

    SELECT * FROM sys.master_files

    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

    July 1, 2015 at 8:50 am

    #1809528

  • RE: Creating indexes with same key column but different include

    Steve Jones - SSC Editor (7/1/2015)

    AFAIK, the order of columns in the include doesn't matter.

    Correct.

    Order of columns matters in the key, not in the include

    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

    July 1, 2015 at 8:49 am

    #1809525

  • RE: Creating indexes with same key column but different include

    Feasible, but probably not a good idea.

    Unless the query which uses the smaller one is so time-sensitive that it cannot possibly take a millisecond longer, you're probably best off merging...

    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

    July 1, 2015 at 7:29 am

    #1809470

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/30/2015)

    Alvin Ramard (6/30/2015)

    Question is being asked in the forum: "if mdf get full by data then how to make free space without adding disk."

    Is it ok to suggest dropping...

    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

    July 1, 2015 at 4:47 am

    #1809419

Viewing 15 posts - 5,431 through 5,445 (of 49,552 total)