Not directly and not easily.

What you can do is an XQuery against the queries in cache to see which have accessed a given index, but the read values of the...

I think this does what you need.

--test table

CREATE TABLE OrderTest

(id INT,

parentid INT NULL)

--test data

INSERT INTO OrderTest

VALUES

(1, NULL),

(2, NULL),

(3, NULL),

(4, 1),

(5, 1),

(6, 2),

(7, 2),

(8, 3),

(9, 3)

--query

SELECT *

FROM OrderTest

ORDER BY COALESCE(ParentId,Id),...

Still digging through the Thread from three days off,...

Swirl80 (8/6/2010)

---

@Grant:

Not sure what you're refering to? Whats not on the same SP? We're on Service Pack 3 Cumulative Update 4 on live and Service Pack 3 Cumulative Update 5...

I notice they're not at the same SP... since this functionality was introduced with an SP on 2005, maybe you're on the wrong one?

Swirl80 (8/6/2010)

---

@Gila:

If you create this:

CREATE PROCEDURE [dbo].[spProcTest]

AS

BEGIN

CREATE TABLE #qwerty

(

id INT

)

SELECT * FROM #qwerty

END

and get and estimated plan on it then it works. I can 100% guarantee that there is...

Not sure why Get-Content didn't work for you. I tested it several times. Still, glad you solved the problem.

You can't get estimated plans on queries with temp tables because the algebrizer fails on the initial run. The recompile that occurs when temp tables are present is when the...

Yep, exactly. Service Packs are cumulative.

Well, yes & no. There really isn't any way to query all tables at once. But, you could set up a query where you UNION a query against each table,...

For me, the question is, one database or many, why are you splitting them? Do you have different applications with different sets of users and different sets of data and,...

Always remember, if you're in doubt of anything, test it. For an update query like this, I'd suggest wrapping it in a BEGIN TRAN and ROLLBACK TRAN and seeing how...

CavyPrincess (8/5/2010)

---

If you're interested in query-tuning performance, check-out this link. The book is available for free download, but I like paperbacks better, so I actually purchased it. I'm...

Since you're asking, I'll come right out & say it, look at my signature line and try my book on performance tuning.

In addition, I'd strongly recommend getting Itzik Ben-Gan's...

Dynamic Management Views (DMV) to the rescue!

Look up in BOL sys.dm_tran_*. You'll find more information than you can shake a stick at. You can combine this with other DMVs like...