well you may have a flavour of SSRS and SSIS Bussiness Intelligence

but specifically in DBA track, i think you may go for multi RDBMS

@ MIke : yes you are right , i know this methode but this way we have to restore full database. i was asking is there any other way to...

humm i see. so, there is no fix criteria.

thanks to all of you for comments and information.

@ Ali : Agreed, i dont do it as regular practice 🙂

but asking for times when there is no more space left in drive

so, this is the only...

one more thing regarding exams

how many questions i have to answer correctly atleast.

I want to make sure all questions carry equal marks and can we skip and retake...

@ vultar

yes i did, after backup tlog get truncate but it didnt get shrink.

I just want to do this because we were running out of space on that...

i tried on microsoft website but i didnt find course content there...

so, it means i have to specify some size too

ok i will try your suggestion

Thanks, but i am not expert enough to use cursors

i will try maintainance plan to clean up Tlog prior to yesterday...

so, it means if i do Transactional log backup ONLY , it will truncate logs, am i right ???

and there is no need to run dbcc shrinkfile

i read in...

@ Gail :

yes his scripts are good and working but i dont get what i was looking for

when i run this script , the first one

select Object_name(object_id)AS 'Table',index_id,ROUND(avg_fragmentation_in_percent,2)...

@Gail : buddy it is still not clear to me

can you please help me out

share the link please

@ Gail :

thanks for your answer, i just want to know does shrink affect free space on pages, it is clear now Thanks

as you asked why you want to shrink...

yes sure 🙂

i will look at notifications and service broker.

never read about service broker before, its in my study plan but a bit far.

thank