Re: Query Analyzer in Sql Server 2005
Raj (Raj@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I know that the Query Analyzer is merged with an tool in 2005.
So which edition of Sql Server 2005 I need to install to have Query
Analyzer on my machine?
SQL 2000. :-)
As the other posters have pointed out there is a new tool for SQL 2005,
but whether you like it is a matter of taste. So having a QA around as
backup if you freak out on Mgmt Studio is not a bad idea.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
Relevant Pages
- Re: Very slow query
... with lots if information in Books Online, Books, Courses, the Net etc. ... While testing the query in QA, use the "Show Estimated Query Plan" feature. ... This is what I suggest you also pick up using Profiler. ... Tibor Karaszi, SQL Server MVP ...
(microsoft.public.sqlserver.programming) - Re: Database Engine Tuning Advisor suggestion to replace syntax.
... What you said was what I first planned to say, but then I read the Books Online which implies that the batch is indeed reused, so I held back from saying that. ... the query optimizer will probably match the Transact-SQL statement in the second execution with the execution plan generated for the first execution. ... SQL Server does not have to compile the second statement." ...
(microsoft.public.sqlserver.tools) - Immer noch Probleme mit dem Debugger
... Client (Query Analyzer) und SQL Server nicht auf der gleichen Maschine ... Gezielt gesetzte Haltepunkte waren dem Debugger ...
(microsoft.public.de.sqlserver) - Re: Many to one Select
... It still possible to define a query that has maximum of columns needed, ... INSERT statements with sample data. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver) - Re: long SQL lines for osql
... It works great in Query ... Analyzer, but when run through osql it takes errors on lines that are ... One thing to keep in mind, is by default OSQL runs with QUOTED_IDENTIFIER ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver) |
|
