try this..

sp_droppublication @publication='publicationName', @ignore_distributor = 1

You can create publication from backup and use sp_addarticle SP for adding articles.

I would suggest that you figure out the offending query and tune it.

Just use group by in last.

SELECT

[values].value,

SUM(CASE WHEN Q1 = [values].value THEN 1 ELSE 0 END) AS Q1,

SUM(CASE WHEN...

Was this with compress backup enabled or not?

Thanks Lynn. Learned how to do this and will keep that in mind form next time.

Is the compress backup is enabled? Also have to tried local backup in off hours to see if that makes any differences.

I have close to 250 GB DB and...

Its running fine for me. It returned 29877 when I added CONVERT(numeric(14,2),Value) > 0 in where Clause.

My machine is

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)

Jun...

Yes you are right. For Optimizer TVF is like black box.

Simple Single statement TVF can be in lined by SQL but for multi line TVF SQL Server will repeatedly

execute...

Flushing the entire cache, I think is never a good idea. But what I was more interested in to see the execution plan plan for the slow running sql when...

Check the below link...

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/58a1ddf1-90f5-4528-916d-5beb820700dd/

I think you must already have checked all these before but just wanted to ask?

Have you checked the execution plan for long running sqls/ stored procedures? It may be good...

It might help.

http://blogs.technet.com/b/askds/archive/2008/06/13/understanding-kerberos-double-hop.aspx

Lynn Pettis is right. But one variable here is the virtualization of SQL Server. If you have vMotion enabled and due to memory/ CPU ballooning if the Principal or...

Here ...it might help you.

http://blogs.technet.com/b/mdegre/archive/2012/03/19/what-is-parameter-sniffing.aspx