text: 
  
  
  
  
  
  
  
  <!DOCTYPE html>
  <html lang="en">
    <head>
      <meta charset="utf-8">
    <link rel="dns-prefetch" href="https://assets-cdn.github.com">
    <link rel="dns-prefetch" href="https://avatars0.githubusercontent.com">
    <link rel="dns-prefetch" href="https://avatars1.githubusercontent.com">
    <link rel="dns-prefetch" href="https://avatars2.githubusercontent.com">
    <link rel="dns-prefetch" href="https://avatars3.githubusercontent.com">
    <link rel="dns-prefetch" href="https://github-cloud.s3.amazonaws.com">
    <link rel="dns-prefetch" href="https://user-images.githubusercontent.com/">
  
  
  
    <link crossorigin="anonymous" media="all" integrity="sha512-mjQPRAh2Y9A0sPdZzipNfPO7PT4g06mk0uZs15DbL/vsNCRGx1uRzWVzls9MJCoy2yRNjaMmEVFKJDpCui00mA==" rel="stylesheet" href="https://assets-cdn.github.com/assets/frameworks-df973073d880f28fbbae0263fb1ef62b.css" />
    <link crossorigin="anonymous" media="all" integrity="sha512-uTw2EuWpUwAcnEun3FDrF0hdxaanMkaAbYDTab9IbhcY2p5JiNBHGXSVt5vXPUvFfsS+j0FC1mjVxea/aZ2klQ==" rel="stylesheet" href="https://assets-cdn.github.com/assets/github-a65c3bf123248e10ec8b0ffb9a533961.css" />
    
    
    
    
  
    <meta name="viewport" content="width=device-width">
    
    <title>bobsql/pageinfo.sql at master · Microsoft/bobsql</title>
      <meta name="description" content="demos, scripts, samples, and code from the two bobs who work at Microsoft on SQL Server - Microsoft/bobsql">
      <link rel="search" type="application/opensearchdescription+xml" href="/opensearch.xml" title="GitHub">
    <link rel="fluid-icon" href="https://github.com/fluidicon.png" title="GitHub">
    <meta property="fb:app_id" content="1401488693436528">
  
      
      <meta property="og:image" content="https://avatars2.githubusercontent.com/u/6154722?s=400&amp;v=4" /><meta property="og:site_name" content="GitHub" /><meta property="og:type" content="object" /><meta property="og:title" content="Microsoft/bobsql" /><meta property="og:url" content="https://github.com/Microsoft/bobsql" /><meta property="og:description" content="demos, scripts, samples, and code from the two bobs who work at Microsoft on SQL Server - Microsoft/bobsql" />
  
    <link rel="assets" href="https://assets-cdn.github.com/">
    <link rel="web-socket" href="wss://live.github.com/_sockets/VjI6MzIyNTE1NDU0OjI0OGM5NzAzNmM4YTczZGQwMTM1Zjk0MzgwODE4MTYyMGZmOWEwMzc1MzMyN2VlNDg2ZDAwNzJlMzBjODE2MzE=--400e5fe1ec05dd14fa95e65ecf1e7021c22380a1">
    <meta name="pjax-timeout" content="1000">
    <link rel="sudo-modal" href="/sessions/sudo_modal">
    <meta name="request-id" content="8500:47BA:DA33C6:17A1E0B:5BAE2FCC" data-pjax-transient>
  
  
    
  
    <meta name="selected-link" value="repo_source" data-pjax-transient>
  
        <meta name="google-site-verification" content="KT5gs8h0wvaagLKAVWq8bbeNwnZZK1r1XQysX3xurLU">
      <meta name="google-site-verification" content="ZzhVyEFwb7w3e0-uOTltm8Jsck2F5StVihD0exw2fsA">
      <meta name="google-site-verification" content="GXs5KoUUkNCoaAZn7wPN-t01Pywp9M3sEjnt_3_ZWPc">
  
    <meta name="octolytics-host" content="collector.githubapp.com" /><meta name="octolytics-app-id" content="github" /><meta name="octolytics-event-url" content="https://collector.githubapp.com/github-external/browser_event" /><meta name="octolytics-dimension-request_id" content="8500:47BA:DA33C6:17A1E0B:5BAE2FCC" /><meta name="octolytics-dimension-region_edge" content="iad" /><meta name="octolytics-dimension-region_render" content="iad" /><meta name="octolytics-actor-id" content="31067101" /><meta name="octolytics-actor-login" content="nmbazima" /><meta name="octolytics-actor-hash" content="dc63dc41cf425b13a26843c2547de64290be7380e4e2038bc2636572397b17d7" />
  <meta name="analytics-location" content="/&lt;user-name&gt;/&lt;repo-name&gt;/blob/show" data-pjax-transient="true" />
  
  
  
      <meta name="google-analytics" content="UA-3769691-2">
  
    <meta class="js-ga-set" name="userId" content="06db85e785723595827291365512a4a3" %>
  
  <meta class="js-ga-set" name="dimension1" content="Logged In">
  
  
  
    
  
        <meta name="hostname" content="github.com">
      <meta name="user-login" content="nmbazima">
  
        <meta name="expected-hostname" content="github.com">
      <meta name="js-proxy-site-detection-payload" content="NDg2MjZhZjBkNDc4YzgxYTA0NGI1NmFjNDhjMTIzMzM5YTIwOTYyYWViOTUxNmQ4N2I4ZWZmYWIzOGY3NDEwN3x7InJlbW90ZV9hZGRyZXNzIjoiNDEuNjAuMjAuMzEiLCJyZXF1ZXN0X2lkIjoiODUwMDo0N0JBOkRBMzNDNjoxN0ExRTBCOjVCQUUyRkNDIiwidGltZXN0YW1wIjoxNTM4MTQyMTY1LCJob3N0IjoiZ2l0aHViLmNvbSJ9">
  
      <meta name="enabled-features" content="DASHBOARD_V2_LAYOUT_OPT_IN,EXPLORE_DISCOVER_REPOSITORIES,UNIVERSE_BANNER,MARKETPLACE_PLAN_RESTRICTION_EDITOR,MARKETPLACE_RETARGETING,COLLAPSE_REPEATED_COMMENTS">
  
    <meta name="html-safe-nonce" content="1528df6defe55a4720b52f7673daf15aca851c01">
  
    <meta http-equiv="x-pjax-version" content="67b79980cf9109b2dfd12718280ec05e">
    
  
        <link href="https://github.com/Microsoft/bobsql/commits/master.atom" rel="alternate" title="Recent Commits to bobsql:master" type="application/atom+xml">
  
    <meta name="go-import" content="github.com/Microsoft/bobsql git https://github.com/Microsoft/bobsql.git">
  
    <meta name="octolytics-dimension-user_id" content="6154722" /><meta name="octolytics-dimension-user_login" content="Microsoft" /><meta name="octolytics-dimension-repository_id" content="95336057" /><meta name="octolytics-dimension-repository_nwo" content="Microsoft/bobsql" /><meta name="octolytics-dimension-repository_public" content="true" /><meta name="octolytics-dimension-repository_is_fork" content="false" /><meta name="octolytics-dimension-repository_network_root_id" content="95336057" /><meta name="octolytics-dimension-repository_network_root_nwo" content="Microsoft/bobsql" /><meta name="octolytics-dimension-repository_explore_github_marketplace_ci_cta_shown" content="false" />
  
  
      <link rel="canonical" href="https://github.com/Microsoft/bobsql/blob/master/demos/msignite2018/pageinfo/pageinfo.sql" data-pjax-transient>
  
  
    <meta name="browser-stats-url" content="https://api.github.com/_private/browser/stats">
  
    <meta name="browser-errors-url" content="https://api.github.com/_private/browser/errors">
  
    <link rel="mask-icon" href="https://assets-cdn.github.com/pinned-octocat.svg" color="#000000">
    <link rel="icon" type="image/x-icon" class="js-site-favicon" href="https://assets-cdn.github.com/favicon.ico">
  
  <meta name="theme-color" content="#1e2327">
  
  
    <meta name="u2f-support" content="true">
  
    <link rel="manifest" href="/manifest.json" crossOrigin="use-credentials">
  
    </head>
  
    <body class="logged-in env-production page-blob">
      
  
    <div class="position-relative js-header-wrapper ">
      <a href="#start-of-content" tabindex="1" class="p-3 bg-blue text-white show-on-focus js-skip-to-content">Skip to content</a>
      <div id="js-pjax-loader-bar" class="pjax-loader-bar"><div class="progress"></div></div>
  
      
      
      
  
  
  
          
  <header class="Header  f5" role="banner">
    <div class="d-flex flex-justify-between px-3 container-lg">
      <div class="d-flex flex-justify-between ">
        <div class="">
          <a class="header-logo-invertocat" href="https://github.com/" data-hotkey="g d" aria-label="Homepage" data-ga-click="Header, go to dashboard, icon:logo">
    <svg height="32" class="octicon octicon-mark-github" viewBox="0 0 16 16" version="1.1" width="32" aria-hidden="true"><path fill-rule="evenodd" d="M8 0C3.58 0 0 3.58 0 8c0 3.54 2.29 6.53 5.47 7.59.4.07.55-.17.55-.38 0-.19-.01-.82-.01-1.49-2.01.37-2.53-.49-2.69-.94-.09-.23-.48-.94-.82-1.13-.28-.15-.68-.52-.01-.53.63-.01 1.08.58 1.23.82.72 1.21 1.87.87 2.33.66.07-.52.28-.87.51-1.07-1.78-.2-3.64-.89-3.64-3.95 0-.87.31-1.59.82-2.15-.08-.2-.36-1.02.08-2.12 0 0 .67-.21 2.2.82.64-.18 1.32-.27 2-.27.68 0 1.36.09 2 .27 1.53-1.04 2.2-.82 2.2-.82.44 1.1.16 1.92.08 2.12.51.56.82 1.27.82 2.15 0 3.07-1.87 3.75-3.65 3.95.29.25.54.73.54 1.48 0 1.07-.01 1.93-.01 2.2 0 .21.15.46.55.38A8.013 8.013 0 0 0 16 8c0-4.42-3.58-8-8-8z"/></svg>
  </a>
  
        </div>
  
      </div>
  
      <div class="HeaderMenu d-flex flex-justify-between flex-auto">
        <div class="d-flex">
              <div class="">
                <div class="header-search scoped-search site-scoped-search js-site-search position-relative js-jump-to"
    role="combobox"
    aria-owns="jump-to-results"
    aria-label="Search or jump to"
    aria-haspopup="listbox"
    aria-expanded="false"
  >
    <div class="position-relative">
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="js-site-search-form" data-scope-type="Repository" data-scope-id="95336057" data-scoped-search-url="/Microsoft/bobsql/search" data-unscoped-search-url="/search" action="/Microsoft/bobsql/search" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="&#x2713;" />
        <label class="form-control header-search-wrapper header-search-wrapper-jump-to position-relative d-flex flex-justify-between flex-items-center js-chromeless-input-container">
          <input type="text"
            class="form-control header-search-input jump-to-field js-jump-to-field js-site-search-focus js-site-search-field is-clearable"
            data-hotkey="s,/"
            name="q"
            value=""
            placeholder="Search or jump to…"
            data-unscoped-placeholder="Search or jump to…"
            data-scoped-placeholder="Search or jump to…"
            autocapitalize="off"
            aria-autocomplete="list"
            aria-controls="jump-to-results"
            data-jump-to-suggestions-path="/_graphql/GetSuggestedNavigationDestinations#csrf-token=2i1el4qEf8XoiA1m7+DMdKrwxVV7HTKYYAzhIo0mzQat9JYOhQEAmPMYkzjN6ui/dp0CVLg3CywguYjLEhJC9g=="
            spellcheck="false"
            autocomplete="off"
            >
            <input type="hidden" class="js-site-search-type-field" name="type" >
              <img src="https://assets-cdn.github.com/images/search-shortcut-hint.svg" alt="" class="mr-2 header-search-key-slash">
  
              <div class="Box position-absolute overflow-hidden d-none jump-to-suggestions js-jump-to-suggestions-container">
                <ul class="d-none js-jump-to-suggestions-template-container">
                  <li class="d-flex flex-justify-start flex-items-center p-0 f5 navigation-item js-navigation-item" role="option">
                    <a tabindex="-1" class="no-underline d-flex flex-auto flex-items-center p-2 jump-to-suggestions-path js-jump-to-suggestion-path js-navigation-open" href="">
                      <div class="jump-to-octicon js-jump-to-octicon mr-2 text-center d-none">
                        <svg height="16" width="16" class="octicon octicon-repo flex-shrink-0 js-jump-to-octicon-repo d-none" title="Repository" aria-label="Repository" viewBox="0 0 12 16" version="1.1" role="img"><path fill-rule="evenodd" d="M4 9H3V8h1v1zm0-3H3v1h1V6zm0-2H3v1h1V4zm0-2H3v1h1V2zm8-1v12c0 .55-.45 1-1 1H6v2l-1.5-1.5L3 16v-2H1c-.55 0-1-.45-1-1V1c0-.55.45-1 1-1h10c.55 0 1 .45 1 1zm-1 10H1v2h2v-1h3v1h5v-2zm0-10H2v9h9V1z"/></svg>
                        <svg height="16" width="16" class="octicon octicon-project flex-shrink-0 js-jump-to-octicon-project d-none" title="Project" aria-label="Project" viewBox="0 0 15 16" version="1.1" role="img"><path fill-rule="evenodd" d="M10 12h3V2h-3v10zm-4-2h3V2H6v8zm-4 4h3V2H2v12zm-1 1h13V1H1v14zM14 0H1a1 1 0 0 0-1 1v14a1 1 0 0 0 1 1h13a1 1 0 0 0 1-1V1a1 1 0 0 0-1-1z"/></svg>
                        <svg height="16" width="16" class="octicon octicon-search flex-shrink-0 js-jump-to-octicon-search d-none" title="Search" aria-label="Search" viewBox="0 0 16 16" version="1.1" role="img"><path fill-rule="evenodd" d="M15.7 13.3l-3.81-3.83A5.93 5.93 0 0 0 13 6c0-3.31-2.69-6-6-6S1 2.69 1 6s2.69 6 6 6c1.3 0 2.48-.41 3.47-1.11l3.83 3.81c.19.2.45.3.7.3.25 0 .52-.09.7-.3a.996.996 0 0 0 0-1.41v.01zM7 10.7c-2.59 0-4.7-2.11-4.7-4.7 0-2.59 2.11-4.7 4.7-4.7 2.59 0 4.7 2.11 4.7 4.7 0 2.59-2.11 4.7-4.7 4.7z"/></svg>
                      </div>
  
                      <img class="avatar mr-2 flex-shrink-0 js-jump-to-suggestion-avatar d-none" alt="" aria-label="Team" src="" width="28" height="28">
  
                      <div class="jump-to-suggestion-name js-jump-to-suggestion-name flex-auto overflow-hidden text-left no-wrap css-truncate css-truncate-target">
                      </div>
  
                      <div class="border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none js-jump-to-badge-search">
                        <span class="js-jump-to-badge-search-text-default d-none" aria-label="in this repository">
                          In this repository
                        </span>
                        <span class="js-jump-to-badge-search-text-global d-none" aria-label="in all of GitHub">
                          All GitHub
                        </span>
                        <span aria-hidden="true" class="d-inline-block ml-1 v-align-middle">↵</span>
                      </div>
  
                      <div aria-hidden="true" class="border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none d-on-nav-focus js-jump-to-badge-jump">
                        Jump to
                        <span class="d-inline-block ml-1 v-align-middle">↵</span>
                      </div>
                    </a>
                  </li>
                </ul>
                <ul class="d-none js-jump-to-no-results-template-container">
                  <li class="d-flex flex-justify-center flex-items-center p-3 f5 d-none">
                    <span class="text-gray">No suggested jump to results</span>
                  </li>
                </ul>
  
                <ul id="jump-to-results" role="listbox" class="js-navigation-container jump-to-suggestions-results-container js-jump-to-suggestions-results-container" >
                  <li class="d-flex flex-justify-center flex-items-center p-0 f5">
                    <img src="https://assets-cdn.github.com/images/spinners/octocat-spinner-128.gif" alt="Octocat Spinner Icon" class="m-2" width="28">
                  </li>
                </ul>
              </div>
        </label>
  </form>  </div>
  </div>
  
              </div>
  
            <ul class="d-flex pl-2 flex-items-center text-bold list-style-none" role="navigation">
              <li>
                <a class="js-selected-navigation-item HeaderNavlink px-2" data-hotkey="g p" data-ga-click="Header, click, Nav menu - item:pulls context:user" aria-label="Pull requests you created" data-selected-links="/pulls /pulls/assigned /pulls/mentioned /pulls" href="/pulls">
                  Pull requests
  </a>            </li>
              <li>
                <a class="js-selected-navigation-item HeaderNavlink px-2" data-hotkey="g i" data-ga-click="Header, click, Nav menu - item:issues context:user" aria-label="Issues you created" data-selected-links="/issues /issues/assigned /issues/mentioned /issues" href="/issues">
                  Issues
  </a>            </li>
                <li>
                  <a class="js-selected-navigation-item HeaderNavlink px-2" data-ga-click="Header, click, Nav menu - item:marketplace context:user" data-octo-click="marketplace_click" data-octo-dimensions="location:nav_bar" data-selected-links=" /marketplace" href="/marketplace">
                     Marketplace
  </a>              </li>
              <li>
                <a class="js-selected-navigation-item HeaderNavlink px-2" data-ga-click="Header, click, Nav menu - item:explore" data-selected-links="/explore /trending /trending/developers /integrations /integrations/feature/code /integrations/feature/collaborate /integrations/feature/ship showcases showcases_search showcases_landing /explore" href="/explore">
                  Explore
  </a>            </li>
            </ul>
        </div>
  
        <div class="d-flex">
          
  <ul class="user-nav d-flex flex-items-center list-style-none" id="user-links">
    <li class="dropdown">
      <span class="d-inline-block  px-2">
        
      <a aria-label="You have no unread notifications" class="notification-indicator tooltipped tooltipped-s  js-socket-channel js-notification-indicator" data-hotkey="g n" data-ga-click="Header, go to notifications, icon:read" data-channel="notification-changed:31067101" href="/notifications">
          <span class="mail-status "></span>
          <svg class="octicon octicon-bell" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M13.99 11.991v1H0v-1l.73-.58c.769-.769.809-2.547 1.189-4.416.77-3.767 4.077-4.996 4.077-4.996 0-.55.45-1 .999-1 .55 0 1 .45 1 1 0 0 3.387 1.229 4.156 4.996.38 1.879.42 3.657 1.19 4.417l.659.58h-.01zM6.995 15.99c1.11 0 1.999-.89 1.999-1.999H4.996c0 1.11.89 1.999 1.999 1.999z"/></svg>
  </a>
      </span>
    </li>
  
    <li class="dropdown">
      <details class="details-overlay details-reset d-flex px-2 flex-items-center">
        <summary class="HeaderNavlink"
           aria-label="Create new…"
           data-ga-click="Header, create new, icon:add">
          <svg class="octicon octicon-plus float-left mr-1 mt-1" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 9H7v5H5V9H0V7h5V2h2v5h5v2z"/></svg>
          <span class="dropdown-caret mt-1"></span>
        </summary>
        <details-menu class="dropdown-menu dropdown-menu-sw">
          
  <a role="menuitem" class="dropdown-item" href="/new" data-ga-click="Header, create new repository">
    New repository
  </a>
  
    <a role="menuitem" class="dropdown-item" href="/new/import" data-ga-click="Header, import a repository">
      Import repository
    </a>
  
  <a role="menuitem" class="dropdown-item" href="https://gist.github.com/" data-ga-click="Header, create new gist">
    New gist
  </a>
  
    <a role="menuitem" class="dropdown-item" href="/organizations/new" data-ga-click="Header, create new organization">
      New organization
    </a>
  
  
    <div class="dropdown-divider"></div>
    <div class="dropdown-header">
      <span title="Microsoft/bobsql">This repository</span>
    </div>
      <a role="menuitem" class="dropdown-item" href="/Microsoft/bobsql/issues/new" data-ga-click="Header, create new issue">
        New issue
      </a>
  
  
        </details-menu>
      </details>
    </li>
  
    <li class="dropdown">
  
      <details class="details-overlay details-reset d-flex pl-2 flex-items-center">
        <summary class="HeaderNavlink name mt-1"
          aria-label="View profile and more"
          data-ga-click="Header, show menu, icon:avatar">
          <img alt="@nmbazima" class="avatar float-left mr-1" src="https://avatars3.githubusercontent.com/u/31067101?s=40&amp;v=4" height="20" width="20">
          <span class="dropdown-caret"></span>
        </summary>
        <details-menu class="dropdown-menu dropdown-menu-sw">
          <ul>
            <li class="header-nav-current-user css-truncate"><a role="menuitem" class="no-underline user-profile-link px-3 pt-2 pb-2 mb-n2 mt-n1 d-block" href="/nmbazima" data-ga-click="Header, go to profile, text:Signed in as">Signed in as <strong class="css-truncate-target">nmbazima</strong></a></li>
            <li class="dropdown-divider"></li>
            <li><a role="menuitem" class="dropdown-item" href="/nmbazima" data-ga-click="Header, go to profile, text:your profile">Your profile</a></li>
            <li><a role="menuitem" class="dropdown-item" href="/nmbazima?tab=repositories" data-ga-click="Header, go to repositories, text:your repositories">Your repositories</a></li>
  
  
            <li><a role="menuitem" class="dropdown-item" href="/nmbazima?tab=stars" data-ga-click="Header, go to starred repos, text:your stars">Your stars</a></li>
              <li><a role="menuitem" class="dropdown-item" href="https://gist.github.com/" data-ga-click="Header, your gists, text:your gists">Your gists</a></li>
            <li class="dropdown-divider"></li>
            <li><a role="menuitem" class="dropdown-item" href="https://help.github.com" data-ga-click="Header, go to help, text:help">Help</a></li>
            <li><a role="menuitem" class="dropdown-item" href="/settings/profile" data-ga-click="Header, go to settings, icon:settings">Settings</a></li>
            <li>
              <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="logout-form" action="/logout" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="35fFd2Znr+XkokDGesD26ECoiY23r0xHLgt9pVPkx7RCVff//3i7LxgnYgmGdDQaUr2hy2h8Xxslc1b+AhGeCA==" />
                <button type="submit" class="dropdown-item dropdown-signout" data-ga-click="Header, sign out, icon:logout" role="menuitem">
                  Sign out
                </button>
  </form>          </li>
          </ul>
        </details-menu>
      </details>
    </li>
  </ul>
  
  
  
          <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="sr-only right-0" action="/logout" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="rqJK3bXHvlZwc5Nq6yRimFyDX5ZAQuL2u282JqznfLczYHhVLNiqnIz2saUXkKBqTpZ30J+R8aqwFx19/RIlCw==" />
            <button type="submit" class="dropdown-item dropdown-signout" data-ga-click="Header, sign out, icon:logout">
              Sign out
            </button>
  </form>      </div>
      </div>
    </div>
  </header>
  
        
  
    </div>
  
    <div id="start-of-content" class="show-on-focus"></div>
  
      <div id="js-flash-container">
  
  
  </div>
  
  
  
    <div role="main" class="application-main ">
          <div itemscope itemtype="http://schema.org/SoftwareSourceCode" class="">
      <div id="js-repo-pjax-container" data-pjax-container >
        
  
  
  
  
  
  
    
  
  
  
    <div class="pagehead repohead instapaper_ignore readability-menu experiment-repo-nav  ">
      <div class="repohead-details-container clearfix container">
  
        <ul class="pagehead-actions">
    <li>
          <!-- '"` --><!-- </textarea></xmp> --></option></form><form data-remote="true" class="js-social-form js-social-container" action="/notifications/subscribe" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="R61hLy67AP63dySTABZ6i9fLb7oI4UPWSDp5mER2L9p0sRbWEle8lvOt6m/ahHa26no3QyeNbJ+73kMlPDMp9Q==" />      <input type="hidden" name="repository_id" id="repository_id" value="95336057" class="form-control" />
  
        <details class="details-reset details-overlay select-menu float-left">
          <summary class="btn btn-sm btn-with-count select-menu-button" data-ga-click="Repository, click Watch settings, action:blob#show">
            <span data-menu-button>
                <svg class="octicon octicon-eye v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.06 2C3 2 0 8 0 8s3 6 8.06 6C13 14 16 8 16 8s-3-6-7.94-6zM8 12c-2.2 0-4-1.78-4-4 0-2.2 1.8-4 4-4 2.22 0 4 1.8 4 4 0 2.22-1.78 4-4 4zm2-4c0 1.11-.89 2-2 2-1.11 0-2-.89-2-2 0-1.11.89-2 2-2 1.11 0 2 .89 2 2z"/></svg>
                Unwatch
            </span>
          </summary>
          <details-menu class="select-menu-modal position-absolute mt-5" style="z-index: 99;">
            <div class="select-menu-header">
              <span class="select-menu-title">Notifications</span>
            </div>
            <div class="select-menu-list">
              <button type="submit" name="do" value="included" class="select-menu-item width-full" aria-checked="false" role="menuitemradio">
                <svg class="octicon octicon-check select-menu-item-icon" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 5l-8 8-4-4 1.5-1.5L4 10l6.5-6.5L12 5z"/></svg>
                <div class="select-menu-item-text">
                  <span class="select-menu-item-heading">Not watching</span>
                  <span class="description">Be notified when participating or @mentioned.</span>
                  <span class="hidden-select-button-text" data-menu-button-contents>
                    <svg class="octicon octicon-eye v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.06 2C3 2 0 8 0 8s3 6 8.06 6C13 14 16 8 16 8s-3-6-7.94-6zM8 12c-2.2 0-4-1.78-4-4 0-2.2 1.8-4 4-4 2.22 0 4 1.8 4 4 0 2.22-1.78 4-4 4zm2-4c0 1.11-.89 2-2 2-1.11 0-2-.89-2-2 0-1.11.89-2 2-2 1.11 0 2 .89 2 2z"/></svg>
                    Watch
                  </span>
                </div>
              </button>
  
              <button type="submit" name="do" value="subscribed" class="select-menu-item width-full" aria-checked="true" role="menuitemradio">
                <svg class="octicon octicon-check select-menu-item-icon" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 5l-8 8-4-4 1.5-1.5L4 10l6.5-6.5L12 5z"/></svg>
                <div class="select-menu-item-text">
                  <span class="select-menu-item-heading">Watching</span>
                  <span class="description">Be notified of all conversations.</span>
                  <span class="hidden-select-button-text" data-menu-button-contents>
                    <svg class="octicon octicon-eye v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.06 2C3 2 0 8 0 8s3 6 8.06 6C13 14 16 8 16 8s-3-6-7.94-6zM8 12c-2.2 0-4-1.78-4-4 0-2.2 1.8-4 4-4 2.22 0 4 1.8 4 4 0 2.22-1.78 4-4 4zm2-4c0 1.11-.89 2-2 2-1.11 0-2-.89-2-2 0-1.11.89-2 2-2 1.11 0 2 .89 2 2z"/></svg>
                    Unwatch
                  </span>
                </div>
              </button>
  
              <button type="submit" name="do" value="ignore" class="select-menu-item width-full" aria-checked="false" role="menuitemradio">
                <svg class="octicon octicon-check select-menu-item-icon" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 5l-8 8-4-4 1.5-1.5L4 10l6.5-6.5L12 5z"/></svg>
                <div class="select-menu-item-text">
                  <span class="select-menu-item-heading">Ignoring</span>
                  <span class="description">Never be notified.</span>
                  <span class="hidden-select-button-text" data-menu-button-contents>
                    <svg class="octicon octicon-mute v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8 2.81v10.38c0 .67-.81 1-1.28.53L3 10H1c-.55 0-1-.45-1-1V7c0-.55.45-1 1-1h2l3.72-3.72C7.19 1.81 8 2.14 8 2.81zm7.53 3.22l-1.06-1.06-1.97 1.97-1.97-1.97-1.06 1.06L11.44 8 9.47 9.97l1.06 1.06 1.97-1.97 1.97 1.97 1.06-1.06L13.56 8l1.97-1.97z"/></svg>
                    Stop ignoring
                  </span>
                </div>
              </button>
            </div>
          </details-menu>
        </details>
        <a class="social-count js-social-count"
          href="/Microsoft/bobsql/watchers"
          aria-label="19 users are watching this repository">
          19
        </a>
  </form>
    </li>
  
    <li>
      
    <div class="js-toggler-container js-social-container starring-container on">
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="starred js-social-form" action="/Microsoft/bobsql/unstar" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="No7lOOXovl5ncpTFr0Fu7s67kwBw6Yw9CVPxNzBV0a72voPACFJr+AqtphNgRqJBhjuiYcNR1McjVWjDQ0Sz7A==" />
        <input type="hidden" name="context" value="repository"></input>
        <button
          type="submit"
          class="btn btn-sm btn-with-count js-toggler-target"
          aria-label="Unstar this repository" title="Unstar Microsoft/bobsql"
          data-ga-click="Repository, click unstar button, action:blob#show; text:Unstar">
          <svg class="octicon octicon-star v-align-text-bottom" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M14 6l-4.9-.64L7 1 4.9 5.36 0 6l3.6 3.26L2.67 14 7 11.67 11.33 14l-.93-4.74L14 6z"/></svg>
          Unstar
        </button>
          <a class="social-count js-social-count" href="/Microsoft/bobsql/stargazers"
             aria-label="29 users starred this repository">
            29
          </a>
  </form>
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="unstarred js-social-form" action="/Microsoft/bobsql/star" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="eWyRJuWdGO5lmPQkc/t04ECsVZCSKVRUT1RpWAo8M74ERjoBZWkh8pIQSJ6pumzM6SEYrN18UD0T1FrcnFlQ1w==" />
        <input type="hidden" name="context" value="repository"></input>
        <button
          type="submit"
          class="btn btn-sm btn-with-count js-toggler-target"
          aria-label="Star this repository" title="Star Microsoft/bobsql"
          data-ga-click="Repository, click star button, action:blob#show; text:Star">
          <svg class="octicon octicon-star v-align-text-bottom" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M14 6l-4.9-.64L7 1 4.9 5.36 0 6l3.6 3.26L2.67 14 7 11.67 11.33 14l-.93-4.74L14 6z"/></svg>
          Star
        </button>
          <a class="social-count js-social-count" href="/Microsoft/bobsql/stargazers"
             aria-label="29 users starred this repository">
            29
          </a>
  </form>  </div>
  
    </li>
  
    <li>
            <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="btn-with-count" action="/Microsoft/bobsql/fork" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="HgX1nZcT38IGMJ6OEz7WHHTKPOT5WW2NoJZWEImuHRaPbujtaot1nJLKgr9E554xmQe5DWCZYIWc04/qPMj/VQ==" />
              <button
                  type="submit"
                  class="btn btn-sm btn-with-count"
                  data-ga-click="Repository, show fork modal, action:blob#show; text:Fork"
                  title="Fork your own copy of Microsoft/bobsql to your account"
                  aria-label="Fork your own copy of Microsoft/bobsql to your account">
                <svg class="octicon octicon-repo-forked v-align-text-bottom" viewBox="0 0 10 16" version="1.1" width="10" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8 1a1.993 1.993 0 0 0-1 3.72V6L5 8 3 6V4.72A1.993 1.993 0 0 0 2 1a1.993 1.993 0 0 0-1 3.72V6.5l3 3v1.78A1.993 1.993 0 0 0 5 15a1.993 1.993 0 0 0 1-3.72V9.5l3-3V4.72A1.993 1.993 0 0 0 8 1zM2 4.2C1.34 4.2.8 3.65.8 3c0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2zm3 10c-.66 0-1.2-.55-1.2-1.2 0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2zm3-10c-.66 0-1.2-.55-1.2-1.2 0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2z"/></svg>
                Fork
              </button>
  </form>
      <a href="/Microsoft/bobsql/network/members" class="social-count"
         aria-label="10 users forked this repository">
        10
      </a>
    </li>
  </ul>
  
        <h1 class="public ">
    <svg class="octicon octicon-repo" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9H3V8h1v1zm0-3H3v1h1V6zm0-2H3v1h1V4zm0-2H3v1h1V2zm8-1v12c0 .55-.45 1-1 1H6v2l-1.5-1.5L3 16v-2H1c-.55 0-1-.45-1-1V1c0-.55.45-1 1-1h10c.55 0 1 .45 1 1zm-1 10H1v2h2v-1h3v1h5v-2zm0-10H2v9h9V1z"/></svg>
    <span class="author" itemprop="author"><a class="url fn" rel="author" href="/Microsoft">Microsoft</a></span><!--
  --><span class="path-divider">/</span><!--
  --><strong itemprop="name"><a data-pjax="#js-repo-pjax-container" href="/Microsoft/bobsql">bobsql</a></strong>
  
  </h1>
  
      </div>
      
  <nav class="reponav js-repo-nav js-sidenav-container-pjax container"
       itemscope
       itemtype="http://schema.org/BreadcrumbList"
       role="navigation"
       data-pjax="#js-repo-pjax-container">
  
    <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
      <a class="js-selected-navigation-item selected reponav-item" itemprop="url" data-hotkey="g c" data-selected-links="repo_source repo_downloads repo_commits repo_releases repo_tags repo_branches repo_packages /Microsoft/bobsql" href="/Microsoft/bobsql">
        <svg class="octicon octicon-code" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M9.5 3L8 4.5 11.5 8 8 11.5 9.5 13 14 8 9.5 3zm-5 0L0 8l4.5 5L6 11.5 2.5 8 6 4.5 4.5 3z"/></svg>
        <span itemprop="name">Code</span>
        <meta itemprop="position" content="1">
  </a>  </span>
  
      <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
        <a itemprop="url" data-hotkey="g i" class="js-selected-navigation-item reponav-item" data-selected-links="repo_issues repo_labels repo_milestones /Microsoft/bobsql/issues" href="/Microsoft/bobsql/issues">
          <svg class="octicon octicon-issue-opened" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7 2.3c3.14 0 5.7 2.56 5.7 5.7s-2.56 5.7-5.7 5.7A5.71 5.71 0 0 1 1.3 8c0-3.14 2.56-5.7 5.7-5.7zM7 1C3.14 1 0 4.14 0 8s3.14 7 7 7 7-3.14 7-7-3.14-7-7-7zm1 3H6v5h2V4zm0 6H6v2h2v-2z"/></svg>
          <span itemprop="name">Issues</span>
          <span class="Counter">0</span>
          <meta itemprop="position" content="2">
  </a>    </span>
  
    <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
      <a data-hotkey="g p" itemprop="url" class="js-selected-navigation-item reponav-item" data-selected-links="repo_pulls checks /Microsoft/bobsql/pulls" href="/Microsoft/bobsql/pulls">
        <svg class="octicon octicon-git-pull-request" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M11 11.28V5c-.03-.78-.34-1.47-.94-2.06C9.46 2.35 8.78 2.03 8 2H7V0L4 3l3 3V4h1c.27.02.48.11.69.31.21.2.3.42.31.69v6.28A1.993 1.993 0 0 0 10 15a1.993 1.993 0 0 0 1-3.72zm-1 2.92c-.66 0-1.2-.55-1.2-1.2 0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2zM4 3c0-1.11-.89-2-2-2a1.993 1.993 0 0 0-1 3.72v6.56A1.993 1.993 0 0 0 2 15a1.993 1.993 0 0 0 1-3.72V4.72c.59-.34 1-.98 1-1.72zm-.8 10c0 .66-.55 1.2-1.2 1.2-.65 0-1.2-.55-1.2-1.2 0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2zM2 4.2C1.34 4.2.8 3.65.8 3c0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2z"/></svg>
        <span itemprop="name">Pull requests</span>
        <span class="Counter">0</span>
        <meta itemprop="position" content="3">
  </a>  </span>
  
      <a data-hotkey="g b" class="js-selected-navigation-item reponav-item" data-selected-links="repo_projects new_repo_project repo_project /Microsoft/bobsql/projects" href="/Microsoft/bobsql/projects">
        <svg class="octicon octicon-project" viewBox="0 0 15 16" version="1.1" width="15" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M10 12h3V2h-3v10zm-4-2h3V2H6v8zm-4 4h3V2H2v12zm-1 1h13V1H1v14zM14 0H1a1 1 0 0 0-1 1v14a1 1 0 0 0 1 1h13a1 1 0 0 0 1-1V1a1 1 0 0 0-1-1z"/></svg>
        Projects
        <span class="Counter" >0</span>
  </a>
  
  
      <a class="js-selected-navigation-item reponav-item" data-hotkey="g w" data-selected-links="repo_wiki /Microsoft/bobsql/wiki" href="/Microsoft/bobsql/wiki">
        <svg class="octicon octicon-book" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M3 5h4v1H3V5zm0 3h4V7H3v1zm0 2h4V9H3v1zm11-5h-4v1h4V5zm0 2h-4v1h4V7zm0 2h-4v1h4V9zm2-6v9c0 .55-.45 1-1 1H9.5l-1 1-1-1H2c-.55 0-1-.45-1-1V3c0-.55.45-1 1-1h5.5l1 1 1-1H15c.55 0 1 .45 1 1zm-8 .5L7.5 3H2v9h6V3.5zm7-.5H9.5l-.5.5V12h6V3z"/></svg>
        Wiki
  </a>
    <a class="js-selected-navigation-item reponav-item" data-selected-links="repo_graphs repo_contributors dependency_graph pulse alerts /Microsoft/bobsql/pulse" href="/Microsoft/bobsql/pulse">
      <svg class="octicon octicon-graph" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M16 14v1H0V0h1v14h15zM5 13H3V8h2v5zm4 0H7V3h2v10zm4 0h-2V6h2v7z"/></svg>
      Insights
  </a>
  
  </nav>
  
  
    </div>
  
  <div class="container new-discussion-timeline experiment-repo-nav  ">
    <div class="repository-content ">
  
      
    <a class="d-none js-permalink-shortcut" data-hotkey="y" href="/Microsoft/bobsql/blob/4796a65f0ac36822ed8dbc89a991f864c625d7bc/demos/msignite2018/pageinfo/pageinfo.sql">Permalink</a>
  
    <!-- blob contrib key: blob_contributors:v21:7cbd1b93539fc2c76a3796d1741d03b2 -->
  
    
  
    <div class="file-navigation">
      
  <div class="select-menu branch-select-menu js-menu-container js-select-menu float-left">
    <button class=" btn btn-sm select-menu-button js-menu-target css-truncate" data-hotkey="w"
      
      type="button" aria-label="Switch branches or tags" aria-expanded="false" aria-haspopup="true">
        <i>Branch:</i>
        <span class="js-select-button css-truncate-target">master</span>
    </button>
  
    <div class="select-menu-modal-holder js-menu-content js-navigation-container" data-pjax>
  
      <div class="select-menu-modal">
        <div class="select-menu-header">
          <svg class="octicon octicon-x js-menu-close" role="img" aria-label="Close" viewBox="0 0 12 16" version="1.1" width="12" height="16"><path fill-rule="evenodd" d="M7.48 8l3.75 3.75-1.48 1.48L6 9.48l-3.75 3.75-1.48-1.48L4.52 8 .77 4.25l1.48-1.48L6 6.52l3.75-3.75 1.48 1.48L7.48 8z"/></svg>
          <span class="select-menu-title">Switch branches/tags</span>
        </div>
  
        <div class="select-menu-filters">
          <div class="select-menu-text-filter">
            <input type="text" aria-label="Filter branches/tags" id="context-commitish-filter-field" class="form-control js-filterable-field js-navigation-enable" placeholder="Filter branches/tags">
          </div>
          <div class="select-menu-tabs">
            <ul>
              <li class="select-menu-tab">
                <a href="#" data-tab-filter="branches" data-filter-placeholder="Filter branches/tags" class="js-select-menu-tab" role="tab">Branches</a>
              </li>
              <li class="select-menu-tab">
                <a href="#" data-tab-filter="tags" data-filter-placeholder="Find a tag…" class="js-select-menu-tab" role="tab">Tags</a>
              </li>
            </ul>
          </div>
        </div>
  
        <div class="select-menu-list select-menu-tab-bucket js-select-menu-tab-bucket" data-tab-filter="branches" role="menu">
  
          <div data-filterable-for="context-commitish-filter-field" data-filterable-type="substring">
  
  
              <a class="select-menu-item js-navigation-item js-navigation-open selected"
                 href="/Microsoft/bobsql/blob/master/demos/msignite2018/pageinfo/pageinfo.sql"
                 data-name="master"
                 data-skip-pjax="true"
                 rel="nofollow">
                <svg class="octicon octicon-check select-menu-item-icon" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 5l-8 8-4-4 1.5-1.5L4 10l6.5-6.5L12 5z"/></svg>
                <span class="select-menu-item-text css-truncate-target js-select-menu-filter-text">
                  master
                </span>
              </a>
          </div>
  
            <div class="select-menu-no-results">Nothing to show</div>
        </div>
  
        <div class="select-menu-list select-menu-tab-bucket js-select-menu-tab-bucket" data-tab-filter="tags">
          <div data-filterable-for="context-commitish-filter-field" data-filterable-type="substring">
  
  
          </div>
  
          <div class="select-menu-no-results">Nothing to show</div>
        </div>
  
      </div>
    </div>
  </div>
  
      <div class="BtnGroup float-right">
        <a href="/Microsoft/bobsql/find/master"
              class="js-pjax-capture-input btn btn-sm BtnGroup-item"
              data-pjax
              data-hotkey="t">
          Find file
        </a>
        <clipboard-copy for="blob-path" class="btn btn-sm BtnGroup-item">
          Copy path
        </clipboard-copy>
      </div>
      <div id="blob-path" class="breadcrumb">
        <span class="repo-root js-repo-root"><span class="js-path-segment"><a data-pjax="true" href="/Microsoft/bobsql"><span>bobsql</span></a></span></span><span class="separator">/</span><span class="js-path-segment"><a data-pjax="true" href="/Microsoft/bobsql/tree/master/demos"><span>demos</span></a></span><span class="separator">/</span><span class="js-path-segment"><a data-pjax="true" href="/Microsoft/bobsql/tree/master/demos/msignite2018"><span>msignite2018</span></a></span><span class="separator">/</span><span class="js-path-segment"><a data-pjax="true" href="/Microsoft/bobsql/tree/master/demos/msignite2018/pageinfo"><span>pageinfo</span></a></span><span class="separator">/</span><strong class="final-path">pageinfo.sql</strong>
      </div>
    </div>
  
  
    <include-fragment src="/Microsoft/bobsql/contributors/master/demos/msignite2018/pageinfo/pageinfo.sql" class="commit-tease commit-loader">
      <div>
        Fetching contributors&hellip;
      </div>
  
      <div class="commit-tease-contributors">
          <img alt="" class="loader-loading float-left" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32-EAF2F5.gif" width="16" height="16" />
        <span class="loader-error">Cannot retrieve contributors at this time</span>
      </div>
  </include-fragment>
  
  
    <div class="file">
      <div class="file-header">
    <div class="file-actions">
  
      <div class="BtnGroup">
        <a id="raw-url" class="btn btn-sm BtnGroup-item" href="/Microsoft/bobsql/raw/master/demos/msignite2018/pageinfo/pageinfo.sql">Raw</a>
          <a class="btn btn-sm js-update-url-with-hash BtnGroup-item" data-hotkey="b" href="/Microsoft/bobsql/blame/master/demos/msignite2018/pageinfo/pageinfo.sql">Blame</a>
        <a rel="nofollow" class="btn btn-sm BtnGroup-item" href="/Microsoft/bobsql/commits/master/demos/msignite2018/pageinfo/pageinfo.sql">History</a>
      </div>
  
          <a class="btn-octicon tooltipped tooltipped-nw"
             href="x-github-client://openRepo/https://github.com/Microsoft/bobsql?branch=master&amp;filepath=demos%2Fmsignite2018%2Fpageinfo%2Fpageinfo.sql"
             aria-label="Open this file in GitHub Desktop"
             data-ga-click="Repository, open with desktop, type:windows">
              <svg class="octicon octicon-device-desktop" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M15 2H1c-.55 0-1 .45-1 1v9c0 .55.45 1 1 1h5.34c-.25.61-.86 1.39-2.34 2h8c-1.48-.61-2.09-1.39-2.34-2H15c.55 0 1-.45 1-1V3c0-.55-.45-1-1-1zm0 9H1V3h14v8z"/></svg>
          </a>
  
            <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="inline-form js-update-url-with-hash" action="/Microsoft/bobsql/edit/master/demos/msignite2018/pageinfo/pageinfo.sql" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="DOvAuEMjQEsMG8HVyUMmQUSiRvAygzNuiCYJBlqZ+fnaQ7qTkjTmg82Ficb5vmZtNKThMiNGU+ydghG0opoIsQ==" />
              <button class="btn-octicon tooltipped tooltipped-nw" type="submit"
                aria-label="Edit the file in your fork of this project" data-hotkey="e" data-disable-with>
                <svg class="octicon octicon-pencil" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M0 12v3h3l8-8-3-3-8 8zm3 2H1v-2h1v1h1v1zm10.3-9.3L12 6 9 3l1.3-1.3a.996.996 0 0 1 1.41 0l1.59 1.59c.39.39.39 1.02 0 1.41z"/></svg>
              </button>
  </form>
          <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="inline-form" action="/Microsoft/bobsql/delete/master/demos/msignite2018/pageinfo/pageinfo.sql" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="BeWjojXOY157BPPtzRp6gmTqDLTV9Pi52lf3orEc5E2bNKT+qdIkKujNPvFk970nViTs2n0sueC00S86v4Leiw==" />
            <button class="btn-octicon btn-octicon-danger tooltipped tooltipped-nw" type="submit"
              aria-label="Delete the file in your fork of this project" data-disable-with>
              <svg class="octicon octicon-trashcan" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M11 2H9c0-.55-.45-1-1-1H5c-.55 0-1 .45-1 1H2c-.55 0-1 .45-1 1v1c0 .55.45 1 1 1v9c0 .55.45 1 1 1h7c.55 0 1-.45 1-1V5c.55 0 1-.45 1-1V3c0-.55-.45-1-1-1zm-1 12H3V5h1v8h1V5h1v8h1V5h1v8h1V5h1v9zm1-10H2V3h9v1z"/></svg>
            </button>
  </form>  </div>
  
    <div class="file-info">
        8 lines (8 sloc)
        <span class="file-info-divider"></span>
      253 Bytes
    </div>
  </div>
  
      
  
    <div itemprop="text" class="blob-wrapper data type-sql">
        <table class="highlight tab-size js-file-line-container" data-tab-size="8">
        <tr>
          <td id="L1" class="blob-num js-line-number" data-line-number="1"></td>
          <td id="LC1" class="blob-code blob-code-inner js-file-line">use tempdb</td>
        </tr>
        <tr>
          <td id="L2" class="blob-num js-line-number" data-line-number="2"></td>
          <td id="LC2" class="blob-code blob-code-inner js-file-line">go</td>
        </tr>
        <tr>
          <td id="L3" class="blob-num js-line-number" data-line-number="3"></td>
          <td id="LC3" class="blob-code blob-code-inner js-file-line"><span class="pl-k">SELECT</span> object_name(<span class="pl-c1">page_info</span>.<span class="pl-c1">object_id</span>), page_info.<span class="pl-k">*</span> </td>
        </tr>
        <tr>
          <td id="L4" class="blob-num js-line-number" data-line-number="4"></td>
          <td id="LC4" class="blob-code blob-code-inner js-file-line"><span class="pl-k">FROM</span> <span class="pl-c1">sys</span>.<span class="pl-c1">dm_exec_requests</span> <span class="pl-k">AS</span> d </td>
        </tr>
        <tr>
          <td id="L5" class="blob-num js-line-number" data-line-number="5"></td>
          <td id="LC5" class="blob-code blob-code-inner js-file-line">  CROSS APPLY <span class="pl-c1">sys</span>.<span class="pl-c1">fn_PageResCracker</span>(<span class="pl-c1">d</span>.<span class="pl-c1">page_resource</span>) <span class="pl-k">AS</span> r</td>
        </tr>
        <tr>
          <td id="L6" class="blob-num js-line-number" data-line-number="6"></td>
          <td id="LC6" class="blob-code blob-code-inner js-file-line">  CROSS APPLY <span class="pl-c1">sys</span>.<span class="pl-c1">dm_db_page_info</span>(<span class="pl-c1">r</span>.<span class="pl-c1">db_id</span>, <span class="pl-c1">r</span>.<span class="pl-c1">file_id</span>, <span class="pl-c1">r</span>.<span class="pl-c1">page_id</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>DETAILED<span class="pl-pds">&#39;</span></span>)</td>
        </tr>
        <tr>
          <td id="L7" class="blob-num js-line-number" data-line-number="7"></td>
          <td id="LC7" class="blob-code blob-code-inner js-file-line">    <span class="pl-k">AS</span> page_info</td>
        </tr>
        <tr>
          <td id="L8" class="blob-num js-line-number" data-line-number="8"></td>
          <td id="LC8" class="blob-code blob-code-inner js-file-line">GO</td>
        </tr>
  </table>
  
    <details class="details-reset details-overlay BlobToolbar position-absolute js-file-line-actions dropdown d-none" aria-hidden="true">
      <summary class="btn-octicon ml-0 px-2 p-0 bg-white border border-gray-dark rounded-1" aria-label="Inline file action toolbar">
        <svg class="octicon octicon-kebab-horizontal" viewBox="0 0 13 16" version="1.1" width="13" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M1.5 9a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3zm5 0a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3zM13 7.5a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0z"/></svg>
      </summary>
      <details-menu>
        <ul class="BlobToolbar-dropdown dropdown-menu dropdown-menu-se mt-2">
          <li><clipboard-copy role="menuitem" class="dropdown-item" id="js-copy-lines" style="cursor:pointer;" data-original-text="Copy lines">Copy lines</clipboard-copy></li>
          <li><clipboard-copy role="menuitem" class="dropdown-item" id="js-copy-permalink" style="cursor:pointer;" data-original-text="Copy link">Copy link</clipboard-copy></li>
          <li><a class="dropdown-item js-update-url-with-hash" id="js-view-git-blame" role="menuitem" href="/Microsoft/bobsql/blame/4796a65f0ac36822ed8dbc89a991f864c625d7bc/demos/msignite2018/pageinfo/pageinfo.sql">View git blame</a></li>
            <li><a class="dropdown-item" id="js-new-issue" role="menuitem" href="/Microsoft/bobsql/issues/new">Open new issue</a></li>
        </ul>
      </details-menu>
    </details>
  
    </div>
  
    </div>
  
    <details class="details-reset details-overlay details-overlay-dark">
      <summary data-hotkey="l" aria-label="Jump to line"></summary>
      <details-dialog class="Box Box--overlay d-flex flex-column anim-fade-in fast linejump" aria-label="Jump to line">
        <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="js-jump-to-line-form Box-body d-flex" action="" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="&#x2713;" />
          <input class="form-control flex-auto mr-3 linejump-input js-jump-to-line-field" type="text" placeholder="Jump to line&hellip;" aria-label="Jump to line" autofocus>
          <button type="submit" class="btn" data-close-dialog>Go</button>
  </form>    </details-dialog>
    </details>
  
  
    </div>
    <div class="modal-backdrop js-touch-events"></div>
  </div>
  
      </div>
    </div>
  
    </div>
  
          
  <div class="footer container-lg px-3" role="contentinfo">
    <div class="position-relative d-flex flex-justify-between pt-6 pb-2 mt-6 f6 text-gray border-top border-gray-light ">
      <ul class="list-style-none d-flex flex-wrap ">
        <li class="mr-3">&copy; 2018 <span title="0.28631s from unicorn-663878969-dm8b9">GitHub</span>, Inc.</li>
          <li class="mr-3"><a data-ga-click="Footer, go to terms, text:terms" href="https://github.com/site/terms">Terms</a></li>
          <li class="mr-3"><a data-ga-click="Footer, go to privacy, text:privacy" href="https://github.com/site/privacy">Privacy</a></li>
          <li class="mr-3"><a href="https://help.github.com/articles/github-security/" data-ga-click="Footer, go to security, text:security">Security</a></li>
          <li class="mr-3"><a href="https://status.github.com/" data-ga-click="Footer, go to status, text:status">Status</a></li>
          <li><a data-ga-click="Footer, go to help, text:help" href="https://help.github.com">Help</a></li>
      </ul>
  
      <a aria-label="Homepage" title="GitHub" class="footer-octicon mr-lg-4" href="https://github.com">
        <svg height="24" class="octicon octicon-mark-github" viewBox="0 0 16 16" version="1.1" width="24" aria-hidden="true"><path fill-rule="evenodd" d="M8 0C3.58 0 0 3.58 0 8c0 3.54 2.29 6.53 5.47 7.59.4.07.55-.17.55-.38 0-.19-.01-.82-.01-1.49-2.01.37-2.53-.49-2.69-.94-.09-.23-.48-.94-.82-1.13-.28-.15-.68-.52-.01-.53.63-.01 1.08.58 1.23.82.72 1.21 1.87.87 2.33.66.07-.52.28-.87.51-1.07-1.78-.2-3.64-.89-3.64-3.95 0-.87.31-1.59.82-2.15-.08-.2-.36-1.02.08-2.12 0 0 .67-.21 2.2.82.64-.18 1.32-.27 2-.27.68 0 1.36.09 2 .27 1.53-1.04 2.2-.82 2.2-.82.44 1.1.16 1.92.08 2.12.51.56.82 1.27.82 2.15 0 3.07-1.87 3.75-3.65 3.95.29.25.54.73.54 1.48 0 1.07-.01 1.93-.01 2.2 0 .21.15.46.55.38A8.013 8.013 0 0 0 16 8c0-4.42-3.58-8-8-8z"/></svg>
  </a>
     <ul class="list-style-none d-flex flex-wrap ">
          <li class="mr-3"><a data-ga-click="Footer, go to contact, text:contact" href="https://github.com/contact">Contact GitHub</a></li>
          <li class="mr-3"><a href="https://github.com/pricing" data-ga-click="Footer, go to Pricing, text:Pricing">Pricing</a></li>
        <li class="mr-3"><a href="https://developer.github.com" data-ga-click="Footer, go to api, text:api">API</a></li>
        <li class="mr-3"><a href="https://training.github.com" data-ga-click="Footer, go to training, text:training">Training</a></li>
          <li class="mr-3"><a href="https://blog.github.com" data-ga-click="Footer, go to blog, text:blog">Blog</a></li>
          <li><a data-ga-click="Footer, go to about, text:about" href="https://github.com/about">About</a></li>
  
      </ul>
    </div>
    <div class="d-flex flex-justify-center pb-6">
      <span class="f6 text-gray-light"></span>
    </div>
  </div>
  
  
  
    <div id="ajax-error-message" class="ajax-error-message flash flash-error">
      <svg class="octicon octicon-alert" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.893 1.5c-.183-.31-.52-.5-.887-.5s-.703.19-.886.5L.138 13.499a.98.98 0 0 0 0 1.001c.193.31.53.501.886.501h13.964c.367 0 .704-.19.877-.5a1.03 1.03 0 0 0 .01-1.002L8.893 1.5zm.133 11.497H6.987v-2.003h2.039v2.003zm0-3.004H6.987V5.987h2.039v4.006z"/></svg>
      <button type="button" class="flash-close js-ajax-error-dismiss" aria-label="Dismiss error">
        <svg class="octicon octicon-x" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.48 8l3.75 3.75-1.48 1.48L6 9.48l-3.75 3.75-1.48-1.48L4.52 8 .77 4.25l1.48-1.48L6 6.52l3.75-3.75 1.48 1.48L7.48 8z"/></svg>
      </button>
      You can’t perform that action at this time.
    </div>
  
  
      
      <script crossorigin="anonymous" integrity="sha512-j7P2Pw3104HznNqyNm7WuCF8Lstcf/sPX5meP6e5RFF177kmi6SAbkZ52A3ttKj0cRHLRrUbk7C1w1xtwh52zA==" type="application/javascript" src="https://assets-cdn.github.com/assets/frameworks-c163002918ede72971a36e0025f67a4a.js"></script>
      
      <script crossorigin="anonymous" async="async" integrity="sha512-BQ1BPwH62J/viBKn/bleEAjzZ/DaqtnkQaXMrATjHEOliLt+QrNg3YQImA7Bucr+fkXyZsF92LJRa5FRb2AcnA==" type="application/javascript" src="https://assets-cdn.github.com/assets/github-89d7cf7f193c8e4621c5bb5a7c34df3e.js"></script>
      
      
      
    <div class="js-stale-session-flash stale-session-flash flash flash-warn flash-banner d-none">
      <svg class="octicon octicon-alert" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.893 1.5c-.183-.31-.52-.5-.887-.5s-.703.19-.886.5L.138 13.499a.98.98 0 0 0 0 1.001c.193.31.53.501.886.501h13.964c.367 0 .704-.19.877-.5a1.03 1.03 0 0 0 .01-1.002L8.893 1.5zm.133 11.497H6.987v-2.003h2.039v2.003zm0-3.004H6.987V5.987h2.039v4.006z"/></svg>
      <span class="signed-in-tab-flash">You signed in with another tab or window. <a href="">Reload</a> to refresh your session.</span>
      <span class="signed-out-tab-flash">You signed out in another tab or window. <a href="">Reload</a> to refresh your session.</span>
    </div>
    <div class="facebox" id="facebox" style="display:none;">
    <div class="facebox-popup">
      <div class="facebox-content" role="dialog" aria-labelledby="facebox-header" aria-describedby="facebox-description">
      </div>
      <button type="button" class="facebox-close js-facebox-close" aria-label="Close modal">
        <svg class="octicon octicon-x" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.48 8l3.75 3.75-1.48 1.48L6 9.48l-3.75 3.75-1.48-1.48L4.52 8 .77 4.25l1.48-1.48L6 6.52l3.75-3.75 1.48 1.48L7.48 8z"/></svg>
      </button>
    </div>
  </div>
  
    <template id="site-details-dialog">
    <details class="details-reset details-overlay details-overlay-dark lh-default text-gray-dark" open>
      <summary aria-haspopup="dialog" aria-label="Close dialog"></summary>
      <details-dialog class="Box Box--overlay d-flex flex-column anim-fade-in fast">
        <button class="Box-btn-octicon m-0 btn-octicon position-absolute right-0 top-0" type="button" aria-label="Close dialog" data-close-dialog>
          <svg class="octicon octicon-x" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.48 8l3.75 3.75-1.48 1.48L6 9.48l-3.75 3.75-1.48-1.48L4.52 8 .77 4.25l1.48-1.48L6 6.52l3.75-3.75 1.48 1.48L7.48 8z"/></svg>
        </button>
        <div class="octocat-spinner my-6 js-details-dialog-spinner"></div>
      </details-dialog>
    </details>
  </template>
  
    <div class="Popover js-hovercard-content position-absolute" style="display: none; outline: none;" tabindex="0">
    <div class="Popover-message Popover-message--bottom-left Popover-message--large Box box-shadow-large" style="width:360px;">
    </div>
  </div>
  
  <div id="hovercard-aria-description" class="sr-only">
    Press h to open a hovercard with more details.
  </div>
  
  
    </body>
  </html>
  
  