Your opinion managing Databases

[meny21]

Hi Guys,

Here, all of us when we would like to manage tables instead of use SQL Entreprise Manager or Query Analizer sometimes we use Access (Linking tables by SQL).

This is because sometimes is more easy to work with this tables (Filtering, ordering, copying this data to excel very simple, etc....) as you know more visual.

The big question here is:
Access consume a lot of our server, do you know another applications that can connect to SQL databases and tables and then work with them more visual in windows?

What do you think guys which software or application you recommend?

Thanks a lot for any suggestions

Manuel

 

[AlexCuse]

I recommend sticking with query analyzer. After a while you will get more proficient typing things like this:

select * from table order by (whatever you want to order by) WHERE thisfield = (whatever you want it to equal)

when you want to look at a whole table, filter, etc...

Access is a dog when it comes to looking at large tables. I doubt anything else would do much better, because it is doing the work on your local PC rather than on the server.

A wise man once said
"The only thing normal about database guys is their tables".

 

[SQLSister]

I'm with Alex. Never use Access and linked tables unless it is your user interface. It can be a performance killer once your tables get large.

You need to learn to write the sql directly in Query analyzer as even the tool in Enterprise manager can create performance problems if you are writing an action query of some type because Enterprise manager actally is doing far more steps than you would think based on the code it is creating for you. Visual tools are crutches that generally mean you don't really understand what is you are trying to do. Often this results in poorly performing code or code which does not actually give the correct results (using the wrong kind of join for instance) becasue you don't understand the theory behind how to query the database.

Questions about posting. See faq183-874