sql server (alternate): Upgrading MY preformance -- sql server (alternate)

Upgrading MY preformance

vncntj NO[at]SPAM hotmail.com
12/31/2003 10:59:50 AM

sql server (alternate): Hello all! I'm a newly appointed database administrator and have been
struggling with my consious about what would make me an excellent
database administrator. I've worked in Access for years and know that
if your comfortable with:
1. writing expressions
2. writing some VBA
3. the basics with Tables, Forms, Queries and Reports.

and you'd be sitting pretty. SQL Server is a little more robust than
Access and i'm not sure where I should start.

I'm comfortable with writing T-SQL statments, backing up, and creating
users. but other than that, i'm a little lost on what else i should
know.

Re: Upgrading MY preformance

John Bell
1/1/2004 12:26:27 PM

Hi

You should take time to read books online:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adm
insql.chm::/ad_mon_perf_00mr.htm

If you wish to persue this further then you may want to buy some books, of
which there are many including among others:

SQL Server 2000 Performance Turning Technical Reference ISBN 0-7356-1270-6
Inside Microsoft SQL Server 2000 by Kalen Delaney ISBN 0-7356-0998-5

Magazines (among others) such as:
http://www.sqlmag.com/
http://www.pinpub.com/html/main.isx?sub=35

Sites (among others):
http://www.microsoft.com/sql/default.asp
http://msdn.microsoft.com/
http://www.sql-server-performance.com/
http://www.sommarskog.se/

John

[quoted text, click to view]