Help needed to learn SQL

[Former Member]

Hi,

My new client has SQL database on Wndows2k.I am working as a Basis Consultant and new to SQL.

Can anybody help me with necessary docs,links,ebooks etc to gain mastery over SQL databse ? Any help regarding know-how of SQL db from BASIS perspective will be extremely helpful.

Points guarranteed.

Thanks,

s<i><b>A</b></i>mik.

[former_member185954 · Accepted solution]

Hi Samir,

You can start by learning , how SAP Tools can control MSSQL database.

http://help.sap.com/saphelp_erp2005vp/helpdata/en/25/1a47363d088e7be10000009b38f889/frameset.htm

Regards,

Siddhesh

[former_member185954]

Yes from the SAP standpoint only Architecture Details , Optimization / Performance and Backup / Recovery procedures are required.

Regards,

Siddhesh

[Former Member]

Hi Siddhesh,

Any link on "important SQl queries" that can be run from Query Analyzer,some basic queries,e.g. how to check version of a database etc.

Thanks,

s<i><b>A</b></i>mik.

[former_member185954]

Hi,

Start SQL Query Analyzer with admin privledges and give this query:

SELECT @@VERSION

GO

Or else, check this link, for another way:

http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag

[former_member185954]

Another suggestion is that with the current information you have , you should go on exploring on your own , I am sure you will find lot of interesting stuff available on various websites provided by me and others.

Regards,

Siddhesh

[Former Member]

Hi,

Thanks for the query.It worked.

Regards,

s<i><b>A</b></i>mik.

[former_member185954]

Hi Samik,

Glad it worked, if your question is answered, you should mark this question as answered.

Regards,

Siddhesh

[former_member185954]

Hi Samik,

Or else you could also download Complete SQL 2000 Express server which is available for free.

You can install the documentation which is very very good and is the official document.

See the feature list here:

http://www.microsoft.com/sql/editions/express/features.mspx

And download it from here:

http://go.microsoft.com/fwlink/?LinkId=64064

While installing , select custom/advanced install and then make sure you select documentation files, it is very useful.

Regards,

Siddhesh

[Former Member]

Hi Siddhesh,

Many thanks for your reply.Just one clarification.

How useful will it be,since the express edition is of 2005,whereas I'm workin on SQL 2000?Also,we are using SQL Enterprise Manager,not Server mangment studio.

I'd like to know about the Query Analyzer,what are the useful queries for maintenance and administering SQL db.

ANy reply will be very helpful.

Thanks,

s<i><b>A</b></i>mik.

[former_member185954]

Hi,

Long ago there was a SQL Server 2000 express edition also available under the name of MSDE, however they (microsoft) are discontinuing MSDE so that's all you have.

The documentation must be the same, you can check this link, its SQL SERVER 2000 specific:

http://msdn2.microsoft.com/en-us/sql/aa336280.aspx

Regards,

Siddhesh

[Former Member]

Samik,

There are some great websites out there that SQL Professionals use. I would recommend the following:

www.sswug.org (This one has a great list server that is reviewed by a number of SQL Server MVP’s)

www.SQLServerCentral.com

www.sqlpass.org/ (number one professional association)

I would also look to see if there is a local user group.

Regards,

Chris