Thank you Kenneth and Bhuvnesh. I know how Outer Applys and Cross Applys work and did dig various things out of it. What I think is, if I...

Was this an in place or side by side upgrade? In Place upgrades are somewhat tedious and I have done 100s of SQL server migrations\upgrades with all side by side...

Rebuild also requires space and that is in tempdb. so you will have to check the space on tempdb Drive and the growth in size of tempdb while your rebuild...

And, Windows Server 2003 onwards, I think /PAE automatically get added in boot.ini. So you wont have to remove it as it is just fine if OS is 64 bit....

You said that you took below actions.

Actions Taken:

1. Enabled AWE.

2. Input number of locks to 10K

3. Checked blocking sessions - none

What Processor architecture you are on? I mean 32...

For initial setup of any replication like transactional, you need sysadmin permissions. However, most of the things you can do with Database Owner permissions once the replication is setup. Like,...

you can use Database Mail feature of SQL Server to configure and send emails. Operators will help you to send emails to receipients. for DBMail configuration in SQL, you...

HP Polyserve is not just a Cluster software but it does provide a well consolidation feature where 15-20 SQL server instances can be well managed on a well configured server...

On a SQL Server, you can hunt down your event logs (may be security logs) and search for SQL Server service account and find some information related to it as...