Forum Replies Created

Viewing 15 posts - 631 through 645 (of 49,552 total)

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    Jeff Moden - Sunday, November 19, 2017 9:42 AM

    SQL-DBA-01 - Friday, November 17, 2017 1:29 PM

    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

    November 20, 2017 at 4:33 am

    #1968728

  • RE: Index Key Re-Ordering

    An index rebuild *is* a physical reordering. It creates a new index and drops the old one.

    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

    November 17, 2017 at 1:49 pm

    #1968601

  • RE: Moving master database mdf and ldf to different location

    9-year old thread, and master can't be replicated.
    Please ask new questions in a new thread.

    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

    November 17, 2017 at 9:02 am

    #1968549

  • RE: Index Key Re-Ordering

    Arsh - Friday, November 17, 2017 7:44 AM

    GilaMonster - Friday, November 17, 2017 5:31 AM

    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

    November 17, 2017 at 8:51 am

    #1968544

  • RE: Index Key Re-Ordering

    Arsh - Friday, November 17, 2017 3:21 AM

    Dear Experts,
    Please advise when does the re-ordering of a index pages occur when a key...

    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

    November 17, 2017 at 5:31 am

    #1968492

  • RE: question related to inmemory

    You can't use in-memory OLTP with tempDB. Not directly.
    You can use in-memory tables in place of table variables, but that's considered to be part of the user DBs, 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

    November 17, 2017 at 3:04 am

    #1968477

  • RE: Log file R drive- What is consuming it

    coolchaitu - Friday, November 17, 2017 12:07 AM

     Is there a way to find out the spid/transaction that is eating up 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

    November 17, 2017 at 3:03 am

    #1968475

  • RE: VIEWs and execution plans

    Indexed view?

    Why are you trying to avoid it? If an indexed view is showing up in a plan, the optimiser thinks it's more efficient than going to 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

    November 16, 2017 at 12:50 pm

    #1968416

  • RE: Is it preferred to keep the SQL server Min memory to 0 (default)?

    NJ-DBA - Thursday, November 16, 2017 10:49 AM

    GilaMonster - Wednesday, November 15, 2017 2:02 PM

    I...

    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

    November 16, 2017 at 12:43 pm

    #1968414

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, November 15, 2017 3:00 PM

    Chris Harshman - Wednesday, November 15, 2017 2:17 PM

    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

    November 15, 2017 at 11:52 pm

    #1968317

  • RE: SQL Enterprise 2017 Mirror Database Snapshot issue

    jcl2399 - Wednesday, November 15, 2017 1:10 PM

      The only issue is the Snapshot is not updating the transactions being held at...

    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

    November 15, 2017 at 2:10 pm

    #1968277

  • RE: Is it preferred to keep the SQL server Min memory to 0 (default)?

    I strongly recommend against setting the min to the max. Something unexpected allocating memory (like a remote connection) and suddenly SQL's memory is in the page file and performance 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

    November 15, 2017 at 2:02 pm

    #1968274

  • RE: What is the best ways of storing unstructured data in sql server 2016, except filestream.

    Abhi kr - Wednesday, November 15, 2017 5:19 AM

    GilaMonster - Wednesday, November 15, 2017 4:14 AM

    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

    November 15, 2017 at 6:37 am

    #1968172

  • RE: What is the best ways of storing unstructured data in sql server 2016, except filestream.

    VARBINARY(MAX) columns. Doesn't have to be filestream, normal VARBINARY(MAX) columns work OK.

    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

    November 15, 2017 at 4:14 am

    #1968152

  • RE: Indexing Issue

    Can you post an example query that's run for this search?

    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

    November 15, 2017 at 1:22 am

    #1968124

Viewing 15 posts - 631 through 645 (of 49,552 total)