Can anyone provide a solution???

Gail,

Please refer my attachement. Im just executing this GRPmainsc_Sp_initSr_Act. Its getting too much of time . Im using a view in this SP .I have...

Gail,

Actually it is not blocking . Its taking too much of time. It is a simple select from table.

Paul,

How many indexes can be created in SQL 2008???

should i shrink before taking backup????

Im taking fragmentaion percentage in this DMV sys.dm_db_index_physical_stats.

wat column i shd make use in sys.dm_db_index_operational_stats.Any article on sys.dm_db_index_operational_stats???

Im not using Maintenace plan. Im using a SP which reorganize or rebuild the indexes depending on the fragmentation level.

Thks for your time . Will Update statistics also increase the log size?

Paul,

We are using standard editions. I cant make use of 4th and 5th point since it is not supported .Already i have increased the bandwidth from 1Mbps to 2 Mbps.Im...

Hi Paul,

I have configured log shipping. My bandwidth is just 2 Mbps.Yesterday i rebuild and reorganized the indexes which made log backup to increase gradually which in turn increased the...

Nice article Gail.Thks.

Paul,

Yes it is because of Intellisense.Its not causing any problem. i feel uncomfortable while running traces.Anyways I filtered in application name.I guess there is no way...

My database dint go to Suspect mode. I just want to know the possibilities.Anyway thanks.

Thks. can u tell me those factors????

Hi ,

My question is can i update the same table like below in another session....without commiting or rollbacking the session 1.

update tabb1...