When I am tuning a "critical" piece of code for a client I just capture profiler trace of the code for a period of time. I will use that...

I have no idea where you got that formula from, but I personally never use PLE any longer for monitoring. I would not be concerned at all about your...

If you want a one-row-one-row combination you could use a cursor on each table and walk through the rows spitting out a new row with all of the relevant fields...

This sounds like a post for the Idera support forums/team. If you can't find a configuration somewhere (app, config file, etc) you could try uninstall/reinstall perhaps.

That's one of my favorites!! 😀

...erg...

Now THERE'S a word I haven't heard since I completed my BS in Physics!! Good one!:hehe:

sqldriver (2/14/2014)

---

TheSQLGuru (2/14/2014)

---

sqldriver (2/14/2014)

---

TheSQLGuru (2/13/2014)

---

The biggest problem I have seen at clients along this type of need is not having a WHERE clause so you only update rows that actually...

sqldriver (2/14/2014)

---

TheSQLGuru (2/13/2014)

---

The biggest problem I have seen at clients along this type of need is not having a WHERE clause so you only update rows that actually HAVE at...

peter.cox (2/14/2014)

---

funnily enough I've been thinking along the same lines, but the joins are so complex, with the tables at the bottom of the script joining four or five others...

Not much to go on here, but first thing I would do is put OPTION (RECOMPILE) on that big mess of a query. If that isn't a repeatable magic...

I have REMOVED indexed from temp tables at clients probably 10 times as often as I have ADDED them to enhance performance. The two main times I have found...

The biggest problem I have seen at clients along this type of need is not having a WHERE clause so you only update rows that actually HAVE at least one...

dndaughtery (2/13/2014)

---

I have a stored procedure that is timing out. I have added indexes but it still isn't working as it should. Any advice is appreciated:

USE [AXInquiry]

GO

/****** Object: StoredProcedure...

sqlTobi (2/13/2014)

---

With plan guides just including a recompile hint the querries work pretty fast with only a few reads.

The like operator is now be evaluated as a seek predicate.

I'm wondering...

Remember too that there is no guarantee that you won't have gaps in identity values for other reasons, such as transaction rollbacks. If you need no gaps, you need...