Frequently Asked Questions
About Paste The Plan

Q: Are there any restrictions on plans I can upload?
Max upload size is 2MB. Larger plans give browsers fits during upload & rendering.

Q: What was this built with?
HTML-Query-Plan, JavaScript code that runs in AWS Lambda, data stored in AWS DynamoDB and S3, and illustrations from Eric Larsen.

Q: Where do I report bugs?
There are no bugs, only features we haven’t documented yet. Okay, maybe there’s actually some known bugs:

  • On some mobile browsers, lines between plan operators don’t show up
  • Plans that don’t pass validation by SQL Server won’t work (we validate it too)

To report additional bugs, contact us and include your browser, operating system, the link where you got the error, and a screenshot.

Q: I lost my URL. Can you look it up for me?
Just paste the plan again, and we’ll give you the same URL again. If you lost the plan, unfortunately, it’s gone with the sands of time. You can’t go home again. Maybe, in the future, we might implement login functionality so you can see the history of all the plans you’ve loved before pasted.

Q: Can you tell me why my query is slow?
No, but you can take your link and go to our favorite Q&A sites, and other members of the community can help you out.

Q: I’m a developer. Can I access the API directly to push plans to the web?
Not yet, but that’s on our future roadmap. In the meantime, contact us with information about the project you’re working on, and we may be able to help.

Q: I’ve got another question. How do I contact you?
Use this spiffy form to email us.

Q: What are the terms of use?

Paste The Plan
Terms of Use
Effective Date: July 2, 2019

The following terms OF USE (the “TERMS OF USE”), along with the BRENT OZAR PLF, LLC D/B/A BRENT OZAR UNLIMITED (“OZAR”) TERMS AND CONDITIONS (brentozar.com/training/refund-and-cancellation-policy-for-training/), and the Privacy Policy (brentozar.com/privacy-policy/), govern your use of PASTE THE PLAN (DEFINED BELOW). Any CAPITALIZED term used herein has the meaning set forth in the OZAR TERMS AND CONDITIONS, unless otherwise specified. THESE TERMS OF USE ARe in additon to the OZAR TERMS AND CONDITIONS.  in the event of any conflict between the terms of use and the OZAR TERMS AND CONDITIONS, the terms of use shall govern and control.

 Ozar has developed a content creation site (“Paste The Plan”) that allows parties to share query plans and collaborate with respect to the development of content of such query plans.

PLEASE REVIEW THESE TERMS OF USE CAREFULLY BEFORE USING PASTE THE PLAN BECAUSE THEY AFFECT YOUR RIGHTS.  BY USING PASTE THE PLAN, YOU ACCEPT THESE TERMS OF USE AND AGREE TO BE LEGALLY BOUND BY THEM. BY AGREEING TO THESE TERMS OF USE AND USING PASTE THE PLAN, YOU AND OZAR AGREE THAT SUCH USE CONSTITUTES A WRITTEN AMENDMENT TO THE OZAR TERMS AND CONDITIONS AND SPECIFICALLY REFLECTS THE AGREEMENT OF THE PARTIES REGARDING THE CREATION OF JOINTLY OWNED INTELLECTUAL PROPERTY.

  1. Ozar Terms and Conditions

The following sections of the Ozar Terms and Conditions are hereby incorporated and made a part of these Terms of Use: 1-7, 9-13. Use of the Paste The Plan constitutes your acceptance of these Terms of Use and your affirmation of the Ozar Terms and Conditions.

  1. Content Supplied by You

You represent, warrant, and agree that no content posted or otherwise shared by you on Paste The Plan, violates or infringes upon the rights of any third party, including copyright, trademark, privacy, publicity, or other personal or proprietary rights, breaches or conflicts with any obligation, such as a confidentiality obligation, or contains libelous, defamatory, or otherwise unlawful material.

Ozar may, but is not obligated to, review the content posted or otherwise shared by you on Paste The Plan and may delete or remove it (without notice) in its sole discretion. 

  1. Intellectual Property

The text, graphics, logos, layouts, designs, interfaces, software, data and other content on Paste The Plan and regardless of whether such content was, in whole or in part, created or developed through your use of Paste The Plan (“Paste The Plan Content“) may be protected by national and local intellectual property laws, rules and regulations in the U.S. and in other countries. By agreeing to these Terms of Use and using the Paste The Plan, you agree to comply with all such laws, including the use of any applicable copyright, trademark or other legal notices or restrictions required thereby.

Ozar may provide access in Paste The Plan to content or materials previously created by Ozar or with respect to which Ozar has ownership rights or interests (“Ozar Content”), for the purpose of encouraging collaborative use and development of such by Ozar. The posting of, or provision of access to, the Ozar Content shall not in any way modify or impair Ozar’s right, title or interest in and to the Ozar Content.

  1. License

In consideration for Ozar allowing you to access Paste The Plan, you agree that Ozar will have a non-exclusive, perpetual, worldwide, irrevocable, royalty-free, fully paid, fully sublicensable license to use, access, and create derivative works of all Paste The Plan Content regardless of ownership.

  1. Digital Millennium Copyright Act (DMCA)

(a) Filing a Notice Alleging Copyright Infringement

All claims alleging copyright infringement for materials posted on Ozar’s website should be promptly sent in the form of written notice to Ozar’s Designated Agent for DMCA Notices at help@brentozar.com or:

Brent Ozar Unlimited
PO Box 29502, ECM #45779
Las Vegas, NV 89126-9602

Specific requirements for proper notification of claimed infringement are set forth in the DMCA (see 17 U.S.C. § 512(c)(3)). Valid notification must be a written communication that includes all of the following elements:

  1. Signature of copyright owner or person authorized to act on behalf of the owner;
  2. Identification of copyrighted work claimed to be infringed;
  3. Identification of the material claimed to be infringing or to be the subject of infringing activity and information reasonably sufficient to permit the service provider to locate the material;
  4. Information reasonably sufficient to permit the service provider to contact the complaining party (address, phone number and, if available, email address);
  5. A statement that the complaining party has a good faith belief that use of the material in the manner complained is not authorized by the copyright owner, its agent, or the law; and
  6. A statement that the information in the notification is accurate, and under penalty of perjury, that the complaining party is authorized to act on behalf of the owner of the exclusive right allegedly being infringed.

It is the policy of Ozar that upon receipt of a valid DMCA notice Ozar will remove or disable access to allegedly infringing material. 

(b) Repeat Infringer Policy

If Ozar becomes aware that one of our users is a repeat copyright infringer, it is our policy to take reasonable steps within our power to terminate that user.

  1. LIMITATION OF LIABILITY

TO THE FULLEST EXTENT PERMITTED BY APPLICABLE LAW, OZAR IS NOT RESPONSIBLE OR LIABLE WHATSOEVER IN ANY MANNER FOR ANY CONTENT POSTED ON OR AVAILABLE THROUGH PASTE THE PLAN (INCLUDING CLAIMS OF INFRINGEMENT RELATING TO THAT CONTENT), FOR YOUR USE OF PASTE THE PLAN, OR FOR THE CONDUCT OF THIRD PARTIES ON OR THROUGH PASTE THE PLAN.

  1. Miscellaneous

These Terms of Use, in conjunction with the Ozar Terms and Conditions and including all additional terms, conditions, and policies on Paste The Plan, constitute the entire agreement between you and Ozar and supersede all prior agreements with respect to Paste The Plan. Nothing in these Terms of Use affects any non-waivable statutory rights that apply to you. The invalidity or unenforceability of any provision of these Terms of Use shall not affect the validity or enforceability of any other provision of this Agreement. You authorize us to disclose information concerning you and your activities as necessary to comply with applicable laws or respond to court order, subpoenas, or other lawful requests, or if we believe doing so would protect your safety or that of another person or protect the security of Paste The Plan, or as otherwise described in the Ozar Privacy Policy (brentozar.com/privacy-policy/).

If you do not agree to these Terms of Use, you must immediately stop using Paste The Plan. Any Paste The Plan Content will continue to be governed by Sections 3 and 4 of these Terms of Use.

If you have questions or concerns about these Terms of Use or Paste The Plan, please contact us at help@brentozar.com or:

Brent Ozar Unlimited
PO Box 29502, ECM #45779
Las Vegas, NV 89126-9602