It cost too much

Thanks guys! You got it right.:-P

Thanks so much!

Can I set

@frag >30 and pages 1000 then rebuild

@frag between 5 and 30 and pages 1000 then reorganize

Would it be correct?

Thanks,

I will investigate this. You are correct, it's remote SQL Server 2005 and a legacy application with ODBC connection

Hi Paul,

thank you for your help. I just solved it too 😛

Declare @tmp_student TABLE (ClassID int, StudentID int )

Insert into @tmp__student (ClassID, StudentID) ...

select ClassID, StudentIDs from @tmp_student AS A...

Gosta, thanks!

it helped me a lot. I completed it and set it up on the server for my boss to test.

What would I do without you guys...:-P

Thanks a lot Jack. I will look into it.

Thanks!

This will work..

Thank you, Bob!

I am going to investigate it...

Unfortunately they need to keep weekly snapshots of the report for the statistical purposes so I still need to upload excel files.. SharePoint is a completely new area for me,...

OK guys,

thank you so much to everybody for help and advices. I fixed the situation with the log file today and didn't ruin anything. It's a good day.

I am told to do it right now do I am in the same situation like my co-worker that dropped the database... but I still have a question regarding a...

Thanks for the script, it's just great!

And if I set up a db into the simple recovery mode, then it will empty the log, and after that I will be...

And another question. If log is full and so huge that there is no space to back it up, would it help to shrink it first and then back it...

What should I do if I want to become an entry level DBA?

What book to read (online?), what to study, is there any short course that would teach you basics...