You only show the create for the schema and a table, nothing for any of the procedures. Can't help you unless you show us everything.

We need the DDL (CREATE TABLE statement) for the tables involved in the query, including any indexes. Also the actual execution plan, saved and uploaded as a .sqlplan file.

Just...

kirkm 55368 (5/7/2012)

---

Hi Vinu, I had a look but its a little too advanced for me.

Where has has, e.g.

Select *

From Table1 t1

LEFT OUTER JOIN Table2 t2

ON t1.Col1 = t2.Col2

What are...

Use this for your third calculation:

SELECT Start_Date = DATEADD(dd, -1,DATEADD(mm,-3,DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0))),

End_Date = DATEADD(dd, -1,DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0))

Using todays date (20120507) what would be the return values for each call to your function?

Uh, intersect...

select * from B

intersect

select * from A;

Normally would not use the * as I would prefer to explicitly name the columns.

Sean Lange (5/7/2012)

---

I see a couple of issues pretty quickly here. First, the query you posted is not the same query as the plan. The one you posted did not...

The only suggestion I have for you at this time is to setup a server-side trace to see what is happening when this user that isn't firing the trigger does...

Here is one way. There are probably others that maybe faster and/or more effecient.

with TestData as (

SELECT 'W1' AS A, 'WWW' AS B, 'W2' AS C

UNION ALL

SELECT 'X1',...

Okay, can't answer your question as both queries work for me with no issues.

Smash125 (5/6/2012)

---

CREATE TABLE Test

(

ContactID INT,

SalesOrderID INT,

OrderYear DATETIME

)

insert into Test(ContactID,SalesOrderID,OrderYear)

select top 10 ContactID,SalesOrderID,YEAR(OrderDate) as orderyear from AdventureWorks.Sales.SalesOrderHeader

order by ContactID asc

ContactID SalesOrderID,OrderYear

1441322001

1455792002

1463892002

1474542002

1483952002

1494952003

1507562003

2534592003

2589072003

2651572004

Delete fails when i try to delete using...

So have I.

Again, the intervierer is trying to...

sqlqtns (5/5/2012)

---

Hi all

i got interview question like this;

if you have 5000 line stored procedure today i made and it works fine,but next day it works slow,how should i troubleshoot this...