Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 49,552 total)

  • RE: Index Usage Details.

    SQL-DBA-01 - Friday, July 7, 2017 2:13 PM

    Hello Experts,

    To monitor the real index usage I mostly use the below std query....

    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 7, 2017 at 2:32 pm

    #1950039

  • RE: Moving Database from VM to Physical server

    dcph - Friday, July 7, 2017 10:10 AM

    What is the best way to move a database form a VM to a physical...

    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 7, 2017 at 10:52 am

    #1949988

  • RE: Help with query - why am I getting 5 or 25 times the expected sums?

    On closer look, it's a case of needing to aggregate before the join, not afterwards.


    SELECT OPP.ID,
       OPP.NAME,
       OPP.AMOUNT,
       ...

    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 7, 2017 at 10:50 am

    #1949987

  • RE: Help with query - why am I getting 5 or 25 times the expected sums?

    What's often helpful to debug something like this is to take the aggregation off, and look at the full resultset.

    SELECT OPP.ID,
     OPP.NAME,
     OPP.AMOUNT,
     OPP.ATRC1,
     OPP.ATRC2,
     OPP.TRC1,

    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 7, 2017 at 10:41 am

    #1949985

  • RE: Index-Filegroup (how many Files)

    Ok Jeff, I'll interrupt my Friday evening... 🙂

    There's two main reasons to split up a database into multiple filegroups.
    1) Performance
    2) Restore times/recoverability.

    Splitting for performance...

    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 7, 2017 at 10:13 am

    #1949980

  • RE: Moving from Simple to Full Recovery Mode

    alex.palmer - Friday, July 7, 2017 7:10 AM

    I just ran an experiment on my test database. Switched to Full recovery and set...

    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 7, 2017 at 7:17 am

    #1949920

  • RE: SQL Server suddenly crashes

    I wonder if it was malware, or if someone intentionally installed it on the server to make some profit on the side from the cryptocurrency mining.

    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 7, 2017 at 7:04 am

    #1949912

  • RE: Moving from Simple to Full Recovery Mode

    alex.palmer - Friday, July 7, 2017 6:44 AM

    I read that.  Does that mean it behaves as Simple recovery mode and overwrites transaction...

    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 7, 2017 at 7:03 am

    #1949911

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Friday, July 7, 2017 4:48 AM

    My problem with FizzBuzz is I hardly ever have reason to use the symbols (like 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

    July 7, 2017 at 6:30 am

    #1949892

  • RE: how to optimise a view having 3 to 4 derived tabels.

    In general, there's nothing wrong with derived tables, in views or elsewhere.
    My general rule is to write any query in the simplest, most obvious way, and tweak it for...

    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 6, 2017 at 6:55 am

    #1949695

  • RE: Are the posted questions getting worse?

    DesNorton - Wednesday, July 5, 2017 10:08 PM

    Brandie Tarvin - Wednesday, July 5, 2017 8:48 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

    July 6, 2017 at 6:37 am

    #1949688

  • RE: Splitting TempDB

    Mike Scalise - Thursday, July 6, 2017 5:28 AM

    1 socket 8 vCPUs is the same as 8 sockets 1 vCPU 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

    July 6, 2017 at 5:59 am

    #1949670

  • RE: Are the posted questions getting worse?

    DesNorton - Wednesday, July 5, 2017 11:13 PM

    @Grant Fritchey

    I believe that congratulations are in order, sir.

    Or condolences, whiskey and a shoulder 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

    July 6, 2017 at 5:55 am

    #1949669

  • RE: SHA256 using HASHBYTES function

    a_ud - Thursday, July 6, 2017 4:58 AM

    Does SQL Server then use UNICODE by default   (while R & websites use ASCII )? ...

    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 6, 2017 at 5:20 am

    #1949659

  • RE: Index-Filegroup (how many Files)

    info 58414 - Thursday, July 6, 2017 1:41 AM

    How many files do you recommend for this index filegroup (DataWarehouse with 1200 Tables)

    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 6, 2017 at 3:11 am

    #1949636

Viewing 15 posts - 1,171 through 1,185 (of 49,552 total)