[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Replacement SQL2008 query analyzer tool

Posted on 2010-08-24
3
Medium Priority
?
1,037 Views
Last Modified: 2012-05-10
I would like to find a standalone query analyzer that will work well with SQL 2008,   I realize I can utilize the tools embedded in the Management Studio, but I miss the ability to have many instances of the query analyzer open at the same time so I can easily toggle between databases and different projects without issues.   It is not uncommon for me to have eight instances of Query Analyzer open at once with dozens of queries running in each.  Additionally I like the small footprint the standalone product provided which is not available using the Management Studio.   Has anyone found a good tool that has been developed to allow for the old school SQL 2000 style query analyzer?  

Thanks,
Mike
0
Comment
Question by:OCUW
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Assisted Solution

by:jdhalverson
jdhalverson earned 500 total points
ID: 33518257
I know you can have multiple instances of Management Studio open and use sqlcmd to run sql scripts against a sql 2008 server there is also this:  http://www.albahari.com/queryexpress.aspx
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 33518262
Just pointing out. You can start multiple instances of SSMS. Maybe this is your solution.

Cheers Marten
0
 
LVL 9

Accepted Solution

by:
sas13 earned 500 total points
ID: 33518659
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

650 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