1. Lets say the transaction normally runs for 8 hrs, how long will the rollback take.

--It depends on the number of rows the transaction is dealing with,and not with the...

Can you give some more info?

While you insert the huge data the table will be locked for that time.

You cannot run T-sql statements in all DBs at once.You have to do it one-by-one.

Also you cannot have a where clause in Alter table statement.You may go through dynamic sql...

Scan density is low .It should be closer to 100%.Index rebuild is required once.The pages scanned will be decreased and thus your scan density increases.Fragmentation is good(less than 20% is...

Restart the server once.If any changes are made to the logins by your administrator will get updated.

Hi Bang,

One more question here.I posted this in different thread but got no reply .

If we add a .ndf file to a database,will it be logged?Will that change get...

will i lose any data in conversion of datatype.

no ..you just need to change that in related sps,functions.

Do we also need to change datatype of a view after...

Try sp_depends 'Table Name Used in the cursor' .You'll get all the stored procedures which are using this table.

Use Windows local admin to start the agent

Thank You.....So,iam just moving the clustered index to different drive.We have index rebuild job every week....Will it cause any effect on the indexes after moving??

can anyone help me out here ??

We cannot add one more drive now.My question here is we have moved clustered index to different drive and non-clustered are sitting on the old drive.Do I need to move...

The filegroup is on different drive.We want to lessen the disk i/o and so we are doing this.