jagnew (10/29/2012)

---

I have a dataset for a ticketing system. The dataset contains the Ticket #, Assigned Technician, and the DateTime they were scheduled on that ticket.

Given this information, for each...

Jeff Moden (10/29/2012)

---

Eugene Elutin (10/29/2012)

---

Actually it depends how you take it, at...

That looks fine to me. Ensure statistics are up to date for indexes on Tab2, and check for an index seek in the CI of Tab2 when you insert a...

ioani (10/29/2012)

---

I have a table Tab1 with a column that is a foreign key to the primary key of table Tab2.

I have a stored procedure that selects some data from...

twoeyed (10/26/2012)

---

Thank you all for taking the time to reply and for your valuable inputs.

I have managed to reduce the execution to around 6 minutes through the ideas proposed, which...

Comment out the filter you aren't sure about:

SELECT Db.dbase.name, Db.dbase.ID_Num, Db.dbase.ID_Type, Db.dbase.GroupName, Db.dbase.Region ...

ksr39 (10/23/2012)

---

Hi Experts,

I need a small help in creating non cluster index on a table as we were facing a performance issue. The issue was in one of our production...

EamonSQL (10/24/2012)

---

select from the table using the ROW_NUMBER() function ordering by id and partitioning by value.

Wrap in brackets giving you a derived table.

Run a delete command against the table and...

Jeff's nailed it:

-- If *this* query returns any rows

SELECT 1

from Interface a

INNER JOIN AnotherDb.dbo.Trans b

ON (convert(varchar, a.TICKET_NUM) = b.TICKET_NUM and a.TXN_DT = b.TXN_DT)

where a.P_STATUS <> 'R'

-- and b.TICKET_NUM...

That's what I thought too until recently.

Jeff Moden (10/23/2012)

---

Wait a minute now... are you saying that...

Oops...

CAST(GETDATE() -1 AS DATE)

Yes - cast both sides as DATE

where CAST(Docket_EngFinish AS DATE)...

Try casting both sides of the comparison as date:

WHERE CAST(Docket_Date AS DATE) = CAST(GETDATE() AS DATE) - 1

o1548324 (10/13/2012)

---

haiao2000 thanks for your suggestion it ended up working. What i did was create a cursor and loaded it with each member_id then steped through the cursor and ran...