any help

Thanks

Thanks for replying

kindly, I am confused about this topic

I made a tran mark , and I cant find it in the GUI SSMS to restor the log at this point

What...

-what about this message when I write the transaction mark for the second time

The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is...

Thank you very much, I got it mostly

If I want to stop restoring at a certain log file. what should I do to finish

what I mean is to change the...

Thanks for replying

My book shows that we use "with standby" in two ways, first one for log shipping, the second one for inspection"how" because the book is showing a little...

Thanks for replying

what about "for inspection" usage, how to apply it, and what is the standby file, how to use it

Thanks lot

I restored a 5 GB database in 3.5 minites instead of 5 minites

is that good or it should be shorter ?

but creating database didnt take secondes ?

Thanks lot

Thanks for replying

it works well when I added 2 useres : system and everyone ?

Thank you very much

Thanks for replying

I followed the steps and wrote

USE master;

--Set Trace Flags 3004 and 3605 to On.

DBCC TRACEON(3004,-1);

DBCC TRACEON(3605,-1);

then I created a database by SSMS 1000 MG but it took...

Dear friend

Thanks for replying, is creating database also apply this option because I have created a new database by 50,000 MG but it tooks a very long time.

and sory for...

Thanks for replying

Do you have a script to know the fragmentation size for the whole database not only table by table.

Thanks lot

Thank you very much

Thanks for replying

- what if I have a huge database = 'Tables' , how to know that I need to re-organise or to re-build indexes

-why when re-organise or re-build indexes...

Thank you very much, it works

HI

" Rebuild over 30% fill factor 80%! reorg under 30% "

Kindly,what should I do to know this percentetge for the Database not for a certain table ?

Thanks...