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

Until and unless the transaction logs are not truncated, it will work fine because log reader agent works by monitoring the transaction log of each database configured for transactional replication...

very good information :-

http://www.brentozar.com/archive/2012/08/sql-server-dba-interview-qa-part-answers/

We are running SQL Server 2008 R2 and I am putting my case together to move to SQL Servre 2012 in from of management. We are 24*7 SaaS company and...

Are you trying to restore on a top of database which already exists?

If yes then use:-

Alter database <DBNAme> set offline with rollback immediate

go

alter database <DBNAme>set online

go

restore command