Forum Replies Created

Viewing 12 posts - 61 through 72 (of 72 total)

  • RE: Developer Edition - Free to use (or not)?

    Thanks Gail.

    I signed up to Dev Essentials and downloaded DEV some while ago, and the discussion has been ongoing since.

    We have a handful of Developers, and the...

  • RE: Buffer Pool Extension

    Thanks for the response Kevin.

    My take was that the SSDs are what they are - whether they are locally or network attached in our environment it would be...

  • RE: Plan Guides (Again)

    Jacob Wilkins - Friday, June 2, 2017 9:28 AM

    SteveOC - Friday, June 2, 2017 9:08 AM

    June 2, 2017 at 10:04 am

    #1945160

  • RE: Plan Guides (Again)

    Grant Fritchey - Friday, June 2, 2017 7:22 AM

    SteveOC - Friday, June 2, 2017 3:49 AM

    June 2, 2017 at 9:08 am

    #1945129

  • RE: Plan Guides (Again)

    ChrisM@Work - Friday, June 2, 2017 5:11 AM

    SteveOC - Friday, June 2, 2017 3:49 AM

  • RE: Plan Guides (Again)

    Hello Gail.

    Thanks for the response - looking for a quick fix as this is affecting productivity - the sub-query is just doing a count on the table for...

  • RE: Using a SQL Plan Guide

    Got there in the end - back to Plan A - that I couldn't get to work in the beginning.
    I had to create a Template Plan Guide to Force parameterisation

  • RE: Using a SQL Plan Guide

    Thanks Grant!

    You are quite correct and if I create an unparameterized plan guide that exactly matches the select, with a hardcoded integer,
    and execute the select, it...

  • RE: Using a SQL Plan Guide

    Thanks Grant.

    I had read that on many posts (some by yourself IIRC)  and as a result I copy the select from the XML or the plan guide into...

  • RE: PLE and BufferPool Contents

    Thanks Folks - the learning process continues.

    "Or, as Kevin already pointed out, a query plan gets a row estimate that is wildly off, decides it needs to allocate...

  • RE: DBCC CHECKDB and TEMPDB

    Sue_H - Tuesday, January 24, 2017 1:34 PM

    SteveOC - Monday, January 23, 2017 8:41 AM

  • RE: How to troubleshoot sudden drop in Page Life Expectancy?

    That is odd - I had to look to make sure that I didn't post this as I started to post similar ,earlier in the week.

    I actually posted something related...

Viewing 12 posts - 61 through 72 (of 72 total)