Where is the SQL Query Analyzer in SQL Server Management Studio 2012

sql-server visual-studio-2012 ssms-2012
user2516685 picture user2516685 · Jul 18, 2014 · Viewed 82k times · Source

I have some SQL thats getting run and it is taking to long to return the results / parse / display, etc. application.

I have SQL Server Management Studio 2012 installed.but i am not able to find SQL Query Analyser. Any Input will be appreciable.

Answer

Mez picture Mez · Jul 18, 2014

Take a look at this link http://consultingblogs.emc.com/jamiethomson/archive/2008/07/10/query-analyzer-or-management-studio.aspx

The Query Analyzer (QA) was the query tool provided with SQL Server up until SQL Server 2000. In SQL Server 2005 and above it was superseded by SQL Server Management Studio (SSMS). If you would like to detect any performance problems in some of your queries you can use the execution plan to determine what is the culprit.  

Are 2 links which definately can get you going. Also take a look at this introduction to SSMS 2012 which also can be useful https://www.youtube.com/watch?v=YipAwZ3Riok

Related questions

update the database from package manager console in code first environment

Code First Environment I'm trying to update the database from package Manager console.If my Domain class change, I have to drop and create the database,Instead of dropping the Database how can i update the database. I have already …

Read More
EF5: Cannot attach the file ‘{0}' as database '{1}'

I'm encountering the exact issue as described here (read section "Cannot Attach to Deleted MDF File"), but the solution to the problem is not told there... In short the issue is that after deleting the .mdf file, the following exception …

Read More
SQL Server 2012 installation Reporting Services Catalog error

I'm installing SQL Server 2012 at the moment and when I was about to run the installation, this error pops up: On clicking the first failed test, which is "Reporting Services Catalog Database File Existence", this is what i get: On …

Read More