473,320 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Preferred SQL tools for sql*server?

Hi All,

I am new this week to sql*server / query analyzer, coming from years
of an oracle / TOAD background. Does anyone have any tools they
prefer for writing and executing sql code other than query analyzer?

Thanks!

Mike
Jul 20 '05 #1
1 1342
Mike,
I really like the SQL Query Analyzer that ships with MSSQL Server 2000,
but some of my group has started to use mssqlXpress (www.xpressapps.com),
since we are many times working with very large databases. This tool's
biggest feature is it's version control, but it also does things like:
- group objects in folders to make it easier to find
- search for text throughout all objects (nice for finding everywhere a
table is accessed, for example)
- pick table, field and variable names from an Intellisense-like list as you
type code

Also, if you are new to SQL Server, you might check out our SQL Server 2000
videos at http://www.TechnicalVideos.net. They include lots of info on
tuning and performance as well as many other SQL Server 2000 topics. We
also have ASP.NET and Flash MX 2002 videos.

Hope this helps,
Chuck Conover
www.TechnicalVideos.net


"Ixnay" <ms******@yahoo.com> wrote in message
news:21**************************@posting.google.c om...
Hi All,

I am new this week to sql*server / query analyzer, coming from years
of an oracle / TOAD background. Does anyone have any tools they
prefer for writing and executing sql code other than query analyzer?

Thanks!

Mike

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: DTB | last post by:
I am looking for the SQL Server 2000 Licensing Setup Utility Program and cannot find it. Everything I read says, goto Control Panel->Administrative Tools->SQL Server License Utility. When I go...
1
by: PaulM | last post by:
Scenario: 2 x win2k pro machines 1 x windows 2000 server In a workgroup not domain Problem: I have SQL2000 installed on my new server (SERVER001), I now need SQL Mail working.
14
by: diskoduro | last post by:
Hi!! Years ago I built a database to control the production of a little factory. The users wanted to work in a Windows Net workgroup so I created an mdb with all the tables and data an after...
2
by: Ma³y Piotruœ | last post by:
Hello, (sorry for my English...) Could you help me please with installing SQL Servera 2005 Express Edition. I downloaded files: SQLEXPR.EXE - Microsoft SQL Server 2005 Express Edition...
6
by: antonyliu2002 | last post by:
I was able to view table content easily before, but after I reinstalled everything, I cannot find the option to view table content in MS SQL Server Express. I can define table with no problem. ...
6
by: Cirene | last post by:
From my experience/undertanding SQL Server (and SQL Express) is the preferred db to use with Visual Studio and is very nicely integrated with it. It works well with the built in membership, etc......
3
by: nagmvs | last post by:
Hai when i try to connect dataabse to my vs 2005 project it shows one error : An error has occurred while establishing a connection to the remote server...this failure may be caused by the fact...
0
by: johnyjj2 | last post by:
Hello! I'd like to run mssql script (file with extension sql). I installed Microsoft SQL Server 2008 and run in Command Prompt: C:\Documents and Settings\useruser>osql -Usa -Ppassword -i...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.