 prestige to the JEE
The Indiana University College of Arts and Sciences, under the direction of Dean Morton Lowengrub, must be thanked for its support.." Along with Robert Becker, Chair of the Department of Economics, Dean Lowengrub is maintaining that support.
Finally, George Bredon and Geoff Page of the University of South Australia deserve recognition for the support they provided the JEE during Bill Becker's residency at UniSA in June through August 1998. The involvement of all these individuals and organizations is essential to the continuing success of the Journal of Economic Education.
William E. Becker November 30, 1998
Back To:
Journal of Economic Education Home PageHalf of the Loewy length minus one of a modified stable Auslander algebra of the Nakayama algebra corresponding to the Dyck path.
The modified algebra B is obtained from the stable Auslander algebra kQ/I by deleting all relations which contain walks of length at least three (conjectural this step of deletion is not necessary as the stable higher Auslander algebras might be quadratic) and taking as B then the algebra kQ^(op)/J when J is the quadratic perp of the ideal I.
See www.findstat.org/DyckPaths/NakayamaAlgebras for the definition of Loewy length and Nakayama algebras associated to Dyck paths.Fall has us thinking about new releases.
What we’re spinning or anticipating this season: Courtney Barnett, Helado Negro, Japanese Breakfast, the HU, Kacey Musgraves, Wardrun, Lil Nas X, Low, The War on Drugs, Lizzo, Space Afrika, Faye Webster, Little Simz, Mdou Moctar, Lorde, Saint Etienne, Durand Jones and the Indications, Big Red Machine, Nite Jewel, Nathan Salsburg, and more. How about you?
Q: Re-run a specific actual query plan I have captured an actual query plan for a specific query. 
After this I've changed a few things around (including updating the statistics) and re-ran that specific query. Now the actual query plan is different (which makes sense). 
The query now runs a lot faster. I'm curious if the new execution plan has anything to do with this, because other changes (changes to the IO setup, VM settings, sql instance restart, etc) may also be causing the improvement in performance. To test this I'd like to run the query once more, and try to force SQL Server to use the old execution plan.
Question: is there a way to re-run a query with a user-provided execution plan, or even run a query directly from such a plan?
Here's what I've tried to figure this one out:


*

*I've searched in the books we have available at the office (Professional SQL Server 2012 Internals and Troubleshooting, Querying Microsoft SQL Server 2012);

*Google searches, for example "run query based on specific query plan"

*DBA.SE searches, for example "execute query plan" and "re run execution plan"

*And finally, one that has answered my questions many time before: carefully check "Questions that may already have your answer" before hitting "Post your question" :-)


So bottom line: is this possible? If so: how?

A: Yes.
You need the USE PLAN hint.
In which you supply the XML from the first plan.
SELECT *
FROM T
OPTION (USE PLAN N'<?xml version="1.0" encoding="utf-16"?>....')

Whilst it doesn't guarantee that the plan will be exactly the same (e.g. compute scalar operators can move around for example) it will likely be pretty close.
<reponame>zzzeek/infrared<filename>infrared/core/execute.py
import tempfile

import yaml
from infrared.core.utils import logger

LOG = logger.LOG


def ansible_playbook(inventory, playbook_path, verbose=None,
                     extra_vars=None, ansible_args=None):
    """Wraps the 'ansible-playbook' CLI.

     :param inventory: inventory file to use.
     :param playbook_path: the playbook to invoke
     :param verbose: Ansible verbosity level
     :param extra_vars: dict. Passed to Ansible as extra-vars
     :param ansible_args: dict of ansible-playbook arguments to plumb down
         directly to Ansible.
    """
    ansible_args = ansible_args or []
    LOG.debug("Additional ansible args: {}".format(ansible_args))

    # hack for verbosity
    from ansible.utils.display import Display
    display = Display(verbosity=verbose)
    import __main__ as main
    setattr(main, "display", display)

    # TODO(yfried): Use proper ansible API instead of emulating CLI
    cli_args = ['execute',
                playbook_path,
                '--inventory', inventory]

    # infrared should not change ansible verbosity unless user specifies that
    if verbose:
        cli_args.append('-' + 'v' * int(verbose))

    cli_args.extend(ansible_args)

    results = _run_playbook(cli_args,
                            vars_dict=extra_vars or {})

    if results:
        LOG.error('Playbook "%s" failed!' % playbook_path)
    return results


def _run_playbook(cli_args, vars_dict):
    """Runs ansible cli with vars dict

    :param vars_dict: dict, Will be passed as Ansible extra-vars
    :param cli_args: the list  of command line arguments
    :return: ansible results
    """

    # TODO(yfried): use ansible vars object instead of tmpfile
    # NOTE(oanufrii):!!!this import should be exactly here!!!
    #                 Ansible uses 'display' singleton from '__main__' and
    #                 gets it on module level. While we monkeypatching our
    #                 '__main__' in 'ansible_playbook' function import of
    #                 PlaybookCLI shoul be after that, to get patched
    #                 '__main__'. Otherwise ansible gets unpatched '__main__'
    #                 and creates new 'display' object with default (0)
    #                 verbosity.
    from ansible.cli.playbook import PlaybookCLI
    with tempfile.NamedTemporaryFile(
            prefix="ir-settings-", delete=True) as tmp:
        tmp.write(yaml.safe_dump(vars_dict, default_flow_style=False))
        # make sure created file is readable.
        tmp.flush()
        cli_args.extend(['--extra-vars', "@" + tmp.name])
        cli = PlaybookCLI(cli_args)
        LOG.debug('Starting ansible cli with args: {}'.format(cli_args[1:]))
        cli.parse()
        return cli.run()
Party boats offer an economical way to enjoy deep sea fishing without paying for expensive private charter boats. In Key West, Florida, several companies offer party boat fishing. Party boat fishing means you pay a fee to get on board and fish with a group of other people. Each trip usually averages about four to five hours in length, traveling from five to eight miles from the deck to reach the reef where you begin fishing.
Most party boats encourage you to bring your own fishing gear, but a few provide the gear or offer fishing rod rentals. Bring cold drinks and a lunch, since party boats spend a good part of the day on the water. Reservations are recommended to make sure you get a spot on the boat of your choice, although on most light days, you can just hop on without a reservation. Lightweight jackets come in handy since rainstorms tend to make the temperature cooler in the summer. Wear comfortable shoes with a good grip so you can easily move around the boat. A cooler to hold your beverages, lunch and snacks also comes in handy.
The boats provide bait and fishing licenses, saving you the time and effort of securing your own license. But if you plan to fish on your own once you get back onshore, you'll need to buy a fishing license, usually available at bait and tackle shops. The boats provide cold storage for your fish, although you'll need a cooler in your car when you return to the dock. Party boats also provide fish cleaning for an extra fee. If you forget to bring drinks or food, the boats usually sell sandwiches, water, snacks and cold beer or soft drinks.
Fishing from Key West means you're throwing out our line and hook in the Gulf of Mexico, so anytime works to go party boat fishing. But from April through August, the Gulf Stream offers better opportunities to troll or cast for dolphin, although you may catch one at any time of year. Dolphin tend to stick around patches of Sargasso seaweed.
Depending on the season, Key West party boat fishermen usually catch bottom fish such as grouper, snapper and grunts. You may also catch a dolphin. The boats drop pieces