Doh! Good catch and glad it's working.

The thing you could have done is set a very low fill factor and there would be lots of free space on pages, but as you changed data or added...

There are also numerous scripts here on this site for backups that you can go through, see how they work, experiment, etc.

You don't need to create the blank database, just do the restore.

The command looks OK, what I might suggest is that you run the SQL you need, get that...

w3schools is a good place. SQL In A Nutshell is a good book, or really any basic SQL book will help you get started.

It's not your account that needs access to the share, it's the SQL service account.

Add more memory?

You can't tune dbcc. It has to run through all rows in all tables and that will eat up memory to complete.

I'd like to be with you, but I'd also hate to see a big crash. Don't forget the guys with 6 or 7 zeros in their pockets don't suffer. It's...

That's not a bad idea. Maybe we can go with more per page.

VFP isn't heavily used, but when it is, it's been fairly popular. I'm not sure it's worth learning, but if you know it, there are probably positions out there for...

I'm not sure what you mean with 64 columns. Are you saying a column for each 15 minute segment of a day?

If you're looping in ASP, why not track the...

I'll give Oracle one thing. they seem to have found a way to convince management to pay more for DBAs on average!

Matt,

thanks for the note. I'll check that out.

Kambugu, if you have a question, please ask it in the appropriate forum, and state what you are looking for. Do not...

Thanks, Barry. It seems that schools here have started calling it President's Day, celebrating both Washington and Lincoln, but it's listed as Washington's Birthday in the federal calendar. 🙁

The holiday...

you might need to better define exactly what you need and for how many instances. that will help you determine things.

the quest tools work well, but for real time monitoring...