ok here is the code. it gets a little nasty and relies on there always being 5 elements to each series and an id.

--SET up some sample data

DECLARE @String...

Mighty Excrement

windows vista

some what on topic: http://www.sqlservercentral.com/Forums/Topic1294729-392-1.aspx i am starting to get to the end of my knowledge on this one. also am i at least looking in the right...

pamozer (5/3/2012)

---

If it were the indexes on the PracticeID wouldn't it be an issue in the query as well as the stored procedure? I eliminated the practiceId parameter all...

can you post the execution plans for each query. i think since ISNULL() is not SARGABLE it is causing an index scan which is slow to begin with. ...

I think this is a big issue but im new to performance tuning so i may get a lesson as well.

this section of code in each where clause (or most...

pamozer (5/3/2012)

---

I have a stored procedure that never finishes. I run the query inside the stored procedure and it takes 17 seconds.

Any thoughts? I tried using with recompile...

Steve Jones - SSC Editor (5/3/2012)

---

Your subquery 1 after the WHERE clause looks to be pulling lots of data for the NOT IN. I think that's your problem. You need...

marksquall (5/3/2012)

-Actually that is what I read already in other post that you cannot update/delete all tables with one single query, each table has it's own dedicated [font="Courier New"]UPDATE[/font] query...

vinu512 (5/3/2012)

---

capn.hector (5/2/2012)

---

the problem with that query is the IN list contains the max interview date...

Im having some dificulty understanding what you want out. also readily consumable DDL and Sample data would help us out a lot. please see my signature for the...

after running your SP and getting the error check @@TRANCOUNT and see what you have. i would guess you have a commit in the code some where it should...

You stated the DB was 4 TB before the purge what about after. as GSquared has eluded to if you have a massive amount of data to delete it...

a2zwd (5/2/2012)

---

Hi

I have a field in my table which has values in minutes.

I need to convert to hours. I am doing this as

CAST(col1/60 AS VARCHAR(6)) + ':' + CAST(col1%60.0...