chandan_jha18 (9/23/2013)

---

Purging data in batches can be considered but considering that the website is a 24*7 environment, there will be locking issues at times plus high CPU and log...

Beside this...

Brandie Tarvin (9/24/2013)

---

But it doesn't explain why the second update (which does much the same thing on different columns) is able to use its index. It does an Index Scan...

Often These maintenance tasks run at Off-Peak hours.(during nights). so avoid these kinds of...

Yes .

From above pasted link

--Query to check the job history error messages if any

SELECT *

FROM [msdb].[dbo].[sysjobhistory]

WHERE [message] like '%Operating system error%'

--Query to check the Log Shipping errors

SELECT *

FROM...

What was the issue here ?

This will help http://www.mssqltips.com/sqlservertip/2553/different-ways-to-monitor-log-shipping-for-sql-server-databases/

Are you saying that every database having connection issue or any specific ?

Check the statuses of all databases

select state_desc, * from sys.databases

Can you post exec plan along with...

HOw much memory currently being consumed by each instance ? that can give you rough...

Can we take help of Resource...

You have kept your question at WRONG tab ..Sql Server 2005 . you soould have been used the "Sql 2012" tabs to get the hits.:-)

https://www.google.co.in/?gws_rd=cr&ei=5U9BUvDsEMKHrgf_9oFo#q=sql+server+2008+memory+troubleshooting

Hit the first link .

Why did you use tuning advisor ... did you experience any perfoemance issue with your code/query ?

Post that Query along with table defintion and execution plan

thanks for reply.

But is this difference because of IN and...