Hi Len

Me? or the other guy??

I manage a large web based app, plus some smaller apps..

2000 users, 300 online approx

1x 4way webserver, includes com+ business components

1x 4way dbserver, ss2k ee,...

Yo

Maintenance plans are the way to go if your new to it all, they are simple and you cant go wrong.

Do a FULL each night on all databases.

Do you require...

Dont get anyone started on this 🙂

See my link below...

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi there

haha.. sounds like you wanted to winge to someone but you dont have another dba there to bash heads with

Yep, sql server is nothing like...

Hi

Im a little confused with the total # disks, can you tell us this number and their size, ie. 5 disks @ 36Gb etc. Can you also mention...

Hi there

The admin comment, this is a classic case of "roles and responsibilities" that have been lost and forgotten. I dont trust any sys admin to do their job,...

Hi

I tend to take this article as relating purely to production server envs only, although, it brings up some interesting chnge control and testing problems when you dont have a...

Hi

Australian Market (AU$, around 66

Fulltime SQL Server DBA - $45 to $95k

Fulltime Oracle DBA - $55 to $110

Contract Rates - SQL Server DBA - $55/hr to $88/hr

Contract Rates - Oracle...

great article...

Hi

Did you read my sample chapter? I highly recommend it.

I would say most run an active/active. I would run say the reporting DB (logshipped or a nighly copy...

Hi

A bulk of sql servers memory usage is the buffer cache. Therefore, the core aim of any dba is to maximise the effectiveness of the cache, this has a...

Hi there

Ive had widely varying results as well between query analyser and code in stored procs and also views. Its all to do with parameter substitituon and meta data...

Hi

If your talking a "SQL Server" (aka database) cluster, you cant, simple as that. Only one server at a time.

If your talking webservers or app servers, you can:

a) ...

Hi Steve

Interesting problem. I ran a forum post on a similar issue I had some time back. My issue was similar, in the fact that some queries were...

Hi

I would have seperate accounts, and lock away privs through roles (mix of db and user defined). Much easier to "remove" developers or disable accounts as they come and...