Re: query plan in clear text



stig (_nospam_stigerikson@xxxxxxxx) writes:
> coming from postgresql, i am used to textual references to most of the
> things i do with the database. i feel a little lost with all the
> graphical.

Here are some good news: you don't have to use it. Use Query Analyzer
for all your tasks, and leave Enterprise Manager to rot in a corner.

Personally, I do almost all tasks from Query Analyzer, and about the only
graphical thing there is the query plan. The only thing I do from
Enterprise Manager is to deal with jobs.




--
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: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2000 Books On-Line
    ... Help topics associated with the Help icon are for Microsoft Management ... To open Books Online from Enterprise Manager, from the tool bar select View ... SQL Server Documentation Team ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot connect to Query Analyzer
    ... On the account, Try adding the local account you created to ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: database diagrams
    ... Script your tables in Query Analyzer, instead of using Enterprise Manager to ... "design" them. ... Take a look at the create table statement in Books Online. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cannot connect to Query Analyzer
    ... A few things to check on the issue with Query Analyzer: ... Find the file on your PC named SQL Server Enterprise ... In terms of the startup account, ... Enterprise Manager, ...
    (microsoft.public.sqlserver.connect)