This sounds like parameter sniffing. Take a look at the links below:

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/

PS Many thanks to Gail for these articles.

PPS Pinning tables is a thing of the past as of...

Multiple objects can have borders. Check for rectangles with borders around your textbox. It might be worthwhile to open the code for the report and do a search...

There should be some border properties on each of the objects that can be changed

I would start here.

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

Lookup ROW_NUMBER in books online for more information

IF OBJECT_ID('TempDB..#SectionMaster') IS NOT NULL DROP TABLE #SectionMaster

CREATE TABLE #SectionMaster

(SectionID INT NOT NULL PRIMARY KEY CLUSTERED,

SectionName VARCHAR(50) NOT NULL,

Position INT NOT...

Reading comprehension is a big part of being DBA.

This is the very first link I hit on Google.

http://blogs.msdn.com/b/chadboyd/archive/2007/07/17/so-you-think-you-know-sql-administration-part-i.aspx

SQL Server Central also has a stairways series from Andy Leonard.

http://www.sqlservercentral.com/stairway/72494/

I would also recommend not using a global temp table. There are some edge cases where they might be necessary but as a general rule of thumb I would...

Try this:

IF object_id('TEMPDB.DBO.##test') IS NOT NULL drop table ##test

create table ##test

(counted int)

Since you have indexes on your temp table, the results from your select need to be sorted according to the index. That sort operation is the "cost of the...

When you restore the secondary, use "WITH MOVE <Logical File Name> to <Physical File Name>" to point the new data file to a different physical location.

SELECT UPPER(cpt4_id)

FROM #TRANS T

INNER JOIN #outpatient_service OS ON T.auth_id = OS.auth_id AND

OS.key_id = (SELECT MIN(key_id)

FROM #outpatient_service OS2

WHERE OS.auth_id = OS2.auth_id)

WHERE T.auth_id = @auth_id

SQL Server 2008 R2 / SQL Server 2012 can do this with a data driven subscription in SSRS.

Can you explain a little more about your situation? Do you not have the same amount of disk space available on disk for your principal server vs your log...

I would start by limiting the amount of data in your lookup transformations. Check your queries and make sure that they are only returning the columns you need for...