Yes that is the right way to get the estimated execution plan.

Some suggestions.

Can you display execution plans for other stored procs?

Also try getting the entire text of the stored proc...

What is the full definition for dbo.tbl

I tried this

CREATE TABLE dbo.tbl (

ID int,

A bit NOT NULL DEFAULT (0),

B bit NOT NULL DEFAULT (0),

C bit NOT NULL DEFAULT...

It appears that statement_text is what is actually executed, but text contains additional parts of the batch, such as parameters, or IF statement.

Checking your script on my own database, I...

I had expected uppercase to sort before lower because of the ASCII values.

Its useful to get these things cleared up.

I think you're going to need COUNTs and GROUP BY

SELECT Name, Category, COUNT(Category) AS CountCat

FROM ..yourTable..

GROUP BY Name, Category

then add your percentages in by getting the MAX as a subquery...

it looks like dbo.split( @Itm ) is a function that splits a string into table

try looking at the function, work out what input format it is expecting (it probably splits...

Hi Gail,

Just noticed your name in the sig line - and that you're technical reviewer on the book!

and apologies - yours isn't a picture of Obi-Wan either is...

Thanks for the free book, Obi-Wan.

Looks pretty comprehensive from a first skim through, and small enough to read it all (*not* a 1200 page monster - which is good)

I think you mean its 35% of the wait time after excluding all those other waits.

it *may* be negligible in proportion to all waits.

Before looking at hardware you should really...

Its a tricky one, and worth knowing.

There are so many rules about getting minimal logging.

They probably meant VARBINARY(MAX) - which gives you 2GB of binary data - enough for [almost] any image. This is the BLOB method.

its as simple as this. If your...

DBayliss - I looked at your other posts, and I think you've been landed with this task to maintain someone elses questionable code.

Brandie's Idea (2), while not ideal, can be...

It would be possible to build a dynamic query that checks for tablenames, and checks if those tables have the columns corresponding to an agent table, and if so includes...

Here's a very good article that includes Entiy Data Modelling, and goes on to do ASP.NET and Reporting, but the EDM part is first. You just need to install...

Or, Using the actual PIVOT statement.

SELECT recordId,

[description], [NEW], [PEND]

FROM ( SELECT T1.recordId, T1.description, T2.Status, T2.Time

FROM Table1 AS T1 JOIN...