thnaks but i wanted the size of all databases present.by using ur script we first have to got to that database then run this script.

hi,but here it is the procedure.in order to make space we either delete older backups or shrink log files.

first we use sqlperf(logspace)

and analysing the result we shrink appropriate log file.and...

yes ...it makes sense.i got to research first and if its still not clear i can post it.

thanks steve.

no ....

i just wanna clear my doubt.i have a interest in this section.thats all.

are my questions that stupid ?

pages deallocated by dbcc repair command

sorry guys...

a lot of questions r going through my mind.and i m depending on u

so sql server before allocating data pages checks what all things to avoid corrupt pages.

or does it maintain a record.

and if there is some data on that deallocated page.

is there...

so execution plans which r there in cache are of no use when we rebuilt indexes.

then is it ok if i clear the cache after this process(rebuilding indexes).will it matter.

what if i again create the cluster index.what will happen then.

when it runs dbcc checkdb with repair option.it mainly de-allocates pages which are corrupt.and when u again run dbcc u will not get any error.so de-allocated pages remain in the...

will the optimiser create a new execution plan or it will use the same one.

thanks

is there a article related to (writing data pages to multiple data files)this part.becoz my doubts r still not cleared.

but if there are 4 data files and there is only one filegroup (primary).now if there is insertion going on.so the data will be divided between 4 files.i mean how...

there could be several reasons

1.problem with application itself

2.there could be blocking on some tables becoz of that it takes a long time to execute.

when your app executes the report it...