Is there a SET XACT_ABORT command in the procedure?

The phenomenon is known as parameter sniffing.

See http://msdn.microsoft.com/en-us/library/cc966425.aspx#XSLTsection133121120120 for a full explanation, and workarounds.

SELECT Table2.PId,

Table2.SSN,

Table2.Name

FROM Table2 T2

WHERE NOT...

peleg k (3/17/2010)

---

i have a query like this:

SELECT StartDate,R1,SUM(Total),ROW_NUMBER() OVER(ORDER BY StartDate ) AS 'id'

FROM [MonthlySummary] (NOLOCK)

Group by [StartDate],R1

Order by StartDate,R1

is there a way...

Mr J (3/17/2010)

---

thanks Paul, i already purged the tempdb so its not goin to be much information within it until it blows out again next time. So i guess I'll...

Sorry, typo. Meant sys.dm_exec_sql_text:

SELECT S.session_id AS [SESSION...

Setup:

--meters

DECLARE @Meters

TABLE (

ParentId INTEGER,

MeterId INTEGER,

...

Confirmed...but is it working now? If not, these are the steps I followed on 2008, XP SP3:

Enable filestream from SSMS (right-click server in object explorer, properties,...

So, if you apply to sys.dm_exec_sql_text, does that give you any more clues?

You should be able to see if it is related to initialization or ongoing replication operations.

How is replication...

Remote server calls from a trigger should be avoided at all costs. The trigger runs inside an implicit transaction, which has to escalate to a distributed transaction if it...

Gianluca Sartori (3/17/2010)

---

Last week somebody at my shop ran a query with a mad cross join over a 27 million rows table.

Tempdb (unlimited growth) went up to 130 Gb...

It is supported, but that does not mean you will not come across any issues 😉

SQL Server 2005 does not have to be a default instance BTW.

See Working with Multiple...

What sort of replication do you have on the server?

What makes you think the space in tempdb is used by replication?

Information on using the dynamic management views to identify big...

Sandhya,

Statistics are always created and updated with an...

Have you...