Bu Let's say if the same procedure is under call by different reports in that case can that not have chances of deadlock? I think every process will call the...

If you have Integration services installed, you can quickly use that to export the jobs. But while importing the jobs to the new server, don't forget to change the connection...

Thanks Gail.

One more request, could you please elaborate a bit against point no.1?

Thanks Gail.

Hi Lynn

You are asking for the table structures.

Well, can you guide me please, if there has to be something specific I need to look at ?

against both the tables,...

Thanks Lynn.

As on today, the queries which I find are running against are joining between two/three/four tables....with the specific column in question to be filtered with some data!

Hi Paul

If I am wrong I believe partitioning the table helps in improving the performance because we are placing the ranges of the data in individual File groups....so instead of...

Can you please help me addressing the below queries?

How detrimental it would be for Replication/Db-Mirror and reports running against the tables?

1. I have a table which is quite large....and client...

Hi Gail,

The table has more than 35 million+ records and of which while trying to extract the results against the particular columns (the columns holds values as : 0,1 and...

Sorry, couldn't understand the justification

Many thanks....................

Many thanks for this point too.

Unfortunately, at server level the fill factor is set as default (=0). And I can't change it.........since it has been working since long time!

If I need to run 1272 indexes in batches, then I will have to go by doing this in a manual process....

Do you think this is what can be good?

1....

Hello,

I want to consider two aspects --

1. LDF file should not grow too much...so that at Production server, my drive doesn't run out of space.

2. The size of the log...

which mode will offer the overall improvement:

Rec Model with "Full" or "Bulk-Logged" ?

Considering the fact that ... my database is a VLDB with highly fragmented indexes!

Under the bulk-logged recovery model, if a log backup covers any bulk operations, the log backup contains both log records and the data pages that were changed by bulk operations....