Just did some testing on this - It seems you can remove a single plan from the cache, if you know the plan handle.

DBCC FREEPROCCACHE (plan_handle)

If it's a stored procedure you can use sp_recompile proc_name.

I'm not sure about removing a single query from the plan cache. Perhaps you could put the query in the stored...

As far as I know - as of 2005 a service pack cannot be uninstalled - I might be wrong here.

If possible, backup the entire image of the server before...

GilaMonster (6/18/2013)

---

It's not that...

Restoring a database from an older version to a newer version (as in your case) shouldn't be a problem. As you've said, you just need to change the compatibility level....

GilaMonster (6/14/2013)

---

It's not that it's unreliable, it's that it can...

If you have a query that takes 10 hours to execute, that doesn't necessarily mean that it's slow - It could be normal for your system.

There is no set...

Yes - More or less.

Have a look here, might help you

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

jitendra.padhiyar (6/14/2013)

---

Hello Masters,

I had SQL Server 2005 SP3 on my server and from yesterday I got an alert that "Buffer cache hit ratio is less than 10%" I monitored it...

xp_servicecontrol 'querystate', 'SQLSERVERAGENT'

I don't think there is a good or bad. It depends on your queries.

This is why creating benchmarks is so important. Then you have something to compare your profiler...

GilaMonster (6/13/2013)

---

You might want to edit that query, as it has filters and sorting that was no where in either of the queries the OP posted. It's a query on...

basavarajyn (6/13/2013)

---

Hi,

When I ran Database Engine Tuning Advisor, it suggests to create a non-clustered index on the column where a clustered index is already present.

Can somebody give me some...

Try this

SELECT top 20

SUBSTRING(t.text, ( s.statement_start_offset / 2 ) + 1,

( ( CASE statement_end_offset

WHEN -1 THEN DATALENGTH(t.text)

ELSE s.statement_end_offset

END - s.statement_start_offset ) / 2 ) + 1)

AS statement_text,

text,

objtype,

cacheobjtype,

usecounts,

last_execution_time,

total_worker_time,

total_worker_time / execution_count AS...

That's up to you