Thanks very much for your replies --

SQLNYC

Hi Gail and Joe - thanks so much for your replies.

Just wanted to be clear that this is not my code --

Joe - I completely agree that this database...

Thanks very much Jeff and Lynn.

Best,

SQLNYC

Hi Steve,

Thanks very much for your reply - much appreciated.

We only want to execute the stored procedure for specific databases.

My concern was that there might be some issue...

Gail - please forgive my terminology. I did indeed modify existing indexes with INCLUDE.

Best wishes,

SQLNYC

Those are the two different values that I've been testing with. The 345 is for a single Employee, returning 48 rows. The other value brings back a group of Employees,...

Gail - here is the plan with the MAXDOP hint. I was able to create all of the indexes you suggested except for one on the CheckTaxes table.

SQLNYC

Hi Gail,

Thanks so much for your help.

I tried MAXDOP(1), and there was only a slight difference in execution time. Both were ~1500ms.

Here is the definition for PersonalID -...

Just updated stats with FULLSCAN on the relevant tables. Unfortunately this did not make any improvement.

Thanks SomewhereSomehow and Gail for your great effort. I have attached the execution plans.

Yes, the OPTIMIZE FOR UNKNOWN works.

SQLNYC

Looking at execution plans is not foreign to me, but I'm no guru. Is there a way to determine why the optimizer chose a given path?

Thanks --

SQLNYC

Hi Eugene,

Thanks for your help.

ANSI NULLs was set to on in my EM, as was QuotedIdentifiers. I set QuotedIdentifiers to OFF, and then checked the proc. They were both...

Thanks for the replies.

My understanding about parameter sniffing is that the optimizer uses the plan that was compiled after first use, which may not be optimal for subsequent uses....

Thanks very much to all who have replied. This hornet's nest of a database that I've inherited has every conceivable worst practice. Nested view joining is just one of the...

GSquared - thanks so very much for the advice and the link. Exactly what I was looking for, but despite searching often, I couldn't find something like this.

Much obliged...