Re: Best Practices: Ad Hoc Analysis Front end for Sql Server 2005

Mark Olbert wrote:
As you say, maybe you are using Management Studio wrongly.

If you know SQL then Management Studio is the best way. If you don't know
SQL and don't want to learn it then get one of the end-user tools I already
mentioned.

I do quite a bit of work in SQL, so that's not the problem. Management Studio is a clunky way to do ad hoc analyses. Importing data
is a pain (and, speaking of removing functionality, there's some useful importing capability in SqlServer2000 enterprise manager
which is gone in Management Studio), and the cycle of writing queries, using them, tweaking them, repeat (which happens quite a bit
doing ad hoc work) is nowhere near as smooth as in Access.

But if you're telling me Management Studio is the best there is right now, fine. That just means the best is quite a bit worse than
what I used to have.

- Mark

It sounds to me like you may be using the Query Designer feature. I
don't know anyone who uses that. I write queries in Management Studio
by clicking "New Query", "Connect" and then just type. If you are doing
that then I don't understand why you think the development cycle is
harder. It is only so if you don't know Transact-SQL.

What Import/Export functionality is missing? Click Tasks / Import Data.
You can feedback any bugs / suggestions at the feedback centre:
http://lab.msdn.microsoft.com/ProductFeedback/

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

.

Relevant Pages

  • RE: Cluster setup: Management Studio not installed on 2nd node...
    ... Based on my scope, after installing SQL cluster on both nodes, SQL client ... How to cluster Microsoft SQL Server 2005 by using ... Subject: Cluster setup: Management Studio not installed on 2nd node... ... When I try to install the Management components on the 2nd node it tells ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Management Studio
    ... > ich nur den SQL Configuration Manager, da kann ich die Dienste starten ... > usw. aber wo ist das Management Studio. ... Die mitgelieferte Express Version oder welche SQL Server Version. ... Prev by Date: ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • !!!Attention SQL Server 2005 Gurus :: Management Studio problems!!!
    ... I use Management Studio to develop/maintain a SQL Server 2000 database ... What is the equivalent Management Studio action for the following SQL ... SQL Query Analyzer 2000 has an option to "Script object-level ...
    (microsoft.public.sqlserver)
  • Re: Sql Mobil (SqlCE 3.0) and Full Framework
    ... Yes I'm using Sql2005 Management Studio with replication and that is the ... > SQL Mobile database. ... > would on the device *except* you bring in a reference to the desktop ...
    (microsoft.public.sqlserver.ce)
  • Re: Subscription to SQL 2000 from SQLX 2005?
    ... I am using Management Studio Express CTP, ... I'm working in a test environment where our license is for 1 processor, SQL ... least not according to the documentation, which says that SQL Server Express ... > selecting to push the subscription, the create subscription wizard of SQL ...
    (microsoft.public.sqlserver.replication)
Loading