Hi all

Talking briefly on raid 0+1, anyone have comments on placing all data,log,etc files onto the single fat raid0+1 array?? here I am talking a minimum of 8 drives....

Hi guys

Another option (will try today), is to save as a VB package and allow users to alter via VB, its messy though.

In the end its fair enough...

Andy

Hi Andy, well Im not sure about this article and its validity in some areas.

My only real concern in the title of the article, I believe that is not...

Good article steve. Perhaps worth while mentioning how you can load up sql*server tables from the results of a external command being executed? I cant remember the exact...

Hi there

Yes, I agree and learnt the hard way. This is a real gotcha when your an oracle DBA moving into the SQLServer realm. Basically I now take...

well still cant find the fix, but this command is fantastic! :

DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS

Right on the money Andy.

Cheers

Chris

More info:

a) Server is running NT 4 SP5

b) RAM installed is (not including base dimm)

4x64Mb (banks 1&2)

4x128Mb (banks 3&4)

4x256Mb (banks 5&6)

c) Tried to bump up swap files to 2gig from...

Hi

It all comes down to

a) what your comfortable with

b) where your teams expertise lies, ie. ongoing maintenance

c) simplicity

id go for sp's as Im not a...

Hi

Im not 100% sure on this, but check perfmon out, from memory you can set an event to throw an email or netsend message when the instance is down. ...

Hi all

Some more info I got from a training CD. I have yet to confirm this..

SQL*Server - v7.x

User(connect) 24Kb

Open DB 2880...

Hi

Ive been meaning to post my backup script that does what you asked for. I use xp_cmdshell and do a call out to a small EXE file I use...

Hi

Crank out perfmon and start adding counters. Run this for a few hours every minute. You will be amazed how much information this can give you.

80 concurrent users...

No probs Andy.

Hi there

I have been running this combo for around 8 months todate. No issues what so ever and I have yet to come accross any problems with performance from...