Hi

For the ALTER DATABASE TEMPDB ... command to change the location and size of TEMPDB requires SQL Server Restart.

...

Hi

Automatic Failover is possible only with DB Mirroring. You need to specify the secondary server as Failover Partner in the app connection string.

For...

I was trying to help Virgo out as it was mentioned as urgent.

By the way thanks for the information.

...

Hi

Try to switch to Bulk Logged recovery model and take frequent Transaction Log backups. This would do minimal Logging and truncate the TL.

...

Hi

Read committed snapshot isolation may result in Non-repeatable and phantom reads and also increased TempDB utilization.

...

Hi

1. Total Server Memory is the memory currently in use by SQL Server and it includes both data and procedure cache buffers.

2. Target > Total indicates that SQL Server is...

It is due to procedure cache bloating as sankar mentioned.

...

Use SQL Server Profiler

Thanks

SQLBuddy

Hi

Select "Existing connection" under the "Sessions" event.

You can also use activity monitor to check the SQL Server connections

...

Only transactions that alter the database like INSERT, DELETE, UPDATE, DROP, CREATE are logged as Gail mentioned.

...

Hi

On Server C change the Linked Server security to the option " Be made using Login's current security context"...

Check this link for the actual queries

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

...

Hi Tom,

Check whether SQL Server is experiencing

1. Excessive compilations and...

Hi

Email will not be delivered and it will not bounce back to the DB.

Instead you will get a similar Delivery Failed email back to you.

Your message did not...

Hi

Optimize for ad hoc workloads is available only in SQL Server 2008.

...