Hi Srinath,

As you need once in a day day referesh, it would be...

Check Whether the Server is experiencing any excessive Comilations and recompilations\sec and also see whether you are getting any CX_PACKET waits which indicates parallelism. Also check for any memory pressures...

Hi DMarvez,

Actuall after the Server Rename and SQL Rename you need to update...

Hi MDP,

You can do that using Performance Dashboard Reports. Just note the number of inserts at...

Users are logins mapped to the dbs.

Users have to be mapped to their respective dbs with minimum required privileges.

Logins should not be mapped to the Master db unless there is...

I would prefer NC Index

SB.

Hi Ghanshyam,

1. Yes

2. 20 GB

AWE is...

SP3 cannot be uninstalled. If required to do so, entire SQL Server has to be uninstalled and reinstalled.

...

Hi

Also check whether the Server got disconnected from the domain. If so add it back to the domain and restart the server.

...

Hi gmamata7,

The data will be moved from the secondary file to the primary file withing the...

Hi STherrien

Available Memory = 128 GB

...

Hi Harry,

Use DBCC Memory Status and Task manager.

http://support.microsoft.com/kb/271624

...

Hi gmamata,

Check this.

http://technet.microsoft.com/en-us/library/ms189493.aspx

Emptying a file

The following...

Try whether you are able to connect to the Target server from any other server in your network.

Also contact your Windows admin and check whether the Server Name...

Hi Sourav,

Try to start the SQL Server Engine and service...