Solved

SQL:  How to Create an Explain Plan

Posted on 2014-02-25
3
249 Views
Last Modified: 2014-02-26
Hello:

How do you create an explain plan (.sqlplan file) for a T-SQL query?

TBSupport
0
Comment
Question by:TBSupport
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 39887774
Query | Include Execution Plan menu
Query | Execute menu
Click on Execution plan tab
File | Save Execution Plan As ... menu.
0
 
LVL 1

Author Comment

by:TBSupport
ID: 39889277
Is there a way to do this, without having to run the SQL query?  The query has been running for four hours, now.

TBSupport
0
 
LVL 1

Author Comment

by:TBSupport
ID: 39889701
Disregard....I figured it out.  Thanks, for your help!

TBSupport
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL server is using more virtual memory. 5 84
get column names from table in vb.net 8 27
Sql Server group by 10 26
SQL Improvement  ( Speed) 14 26
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question