Forum Replies Created

Viewing 15 posts - 3,211 through 3,225 (of 49,552 total)

  • RE: Indexes are not recognized After partitioning !!!!

    Partitioning is not a performance tuning feature, it's for data management and maintenance.

    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

    April 20, 2016 at 5:16 am

    #1873266

  • RE: Indexes are not recognized After partitioning !!!!

    If it's recommending an index that you have exactly, ignore it.

    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

    April 20, 2016 at 3:50 am

    #1873256

  • RE: Trying to retrieve actual execution plan, returns null

    Another point, that query fetches the estimated plan (plan without run-time information) because the run-time info that makes a plan 'actual' isn't stored in cache. It would be too expensive...

    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

    April 20, 2016 at 3:16 am

    #1873250

  • RE: Indexes are not recognized After partitioning !!!!

    Without seeing the current index definitions, the query and the execution plan, no way to say for sure.

    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

    April 20, 2016 at 3:13 am

    #1873249

  • RE: Are the posted questions getting worse?

    Ed Wagner (4/19/2016)

    SQLRNNR (4/19/2016)

    GilaMonster (4/19/2016)

    And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?

    Do it!

    Are you thinking something along...

    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

    April 20, 2016 at 3:09 am

    #1873248

  • RE: Identical Versions Required?

    RTaylor2208 (4/19/2016)

    GilaMonster (4/19/2016)

    RTaylor2208 (4/19/2016)

    During fail over though the instance will take slightly longer to come online as it will perform an upgrade \ downgrade between versions. You'll see this...

    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

    April 20, 2016 at 3:04 am

    #1873247

  • RE: sql swap dated fields

    Yup, that will work fine.

    Updates are done in two phases, first a read, then a change. So SQL's read all the data it needs from the table before it starts...

    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

    April 19, 2016 at 6:14 am

    #1873018

  • RE: Identical Versions Required?

    RTaylor2208 (4/19/2016)

    During fail over though the instance will take slightly longer to come online as it will perform an upgrade \ downgrade between versions. You'll see this reported in...

    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

    April 19, 2016 at 6:07 am

    #1873017

  • RE: sql server 2016 certification

    TheComedian (4/19/2016)

    Nonetheless I've heard a rumour that after 2016, you won't have any version specific certification of SQL Server. It will just be "SQL Server certification" with a mandatory...

    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

    April 19, 2016 at 5:57 am

    #1873014

  • RE: Are the posted questions getting worse?

    And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?

    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

    April 19, 2016 at 3:53 am

    #1872982

  • RE: Can someone help me with creating queries for the below information at the Earliest ??? Thanks in advance

    Then hand it in with wrong answers, doesn't bother me.

    Have you created tables to test your queries? If not, go and do so now.

    Once you've created those tables, run 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

    April 19, 2016 at 3:52 am

    #1872981

  • RE: Can someone help me with creating queries for the below information at the Earliest ??? Thanks in advance

    Does that query run?

    If you haven't created test tables based on the assignment, you should. You need to test queries, it's very hard when you're starting to be able 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

    April 19, 2016 at 3:39 am

    #1872976

  • RE: Can someone help me with creating queries for the below information at the Earliest ??? Thanks in advance

    djmenon21 (4/19/2016)

    The reason i have posted this here is ask help..if i really knew how to solve those i would have not come here in the 1st place.

    We're happy 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

    April 19, 2016 at 3:27 am

    #1872972

  • RE: Can someone help me with creating queries for the below information at the Earliest ??? Thanks in advance

    djmenon21 (4/19/2016)

    Can you please try to improve your query for the 3rd question ?

    3. Please write an SQL query that will answer the following question:

    What’s an average number of comments...

    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

    April 19, 2016 at 3:03 am

    #1872967

  • RE: Performance tuning a query

    Can you post the execution plans 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

    April 19, 2016 at 2:53 am

    #1872962

Viewing 15 posts - 3,211 through 3,225 (of 49,552 total)