any idea please......

No there's no option to select all the tables.

can someone show me how to

create a group that has read/write access to all databases, and add him to that group instead of mapping him individually.

sorry about that, but can you please show me the steps or details. I don't know anything about that.

any word on this

do you guys have any links that i can refer that should guide me step-by-step to create filegroup and move the data between filegroups.

I haven't heard about "reindex by filegroup". Please highlight how to do it. and yes i have 1 mdf, 1 ndf and 1 ldf. So how do i...

Thanks Pradeep but how do you maintain such a massive amount of database?

i don't think that's possible. How can the cleanup task be created three times in a single maintenance plan?

still no comments. 17 views

8 views and no comments friend? please help me if you know.

please see the attache3d excel file for details

Ok i have attached the execution plan.

actually the applications is getting hour glasses and so i ran the profiler and correlated with Performance monitor. and got this query taking time.

This counter reported me the issue---

\\****\SQLServer:Lock request\sec...

all the profiles are public and the one i am trying to send emails is set to default profile.