Don't suppose you can post the exec plan for the proc you're struggling with?

Then that query had no parameters. Either it had variables or constants that weren't auto parameterised.

Those lines should be right at the bottom of the xml, just a couple lines...

It's in the XML. Right at the bottom you'll find two lines like this.

<ParameterList>

<ColumnReference Column="@PageNo" ParameterCompiledValue="(2)" ParameterRuntimeValue="(2)" />

<ColumnReference Column="@ForumID" ParameterCompiledValue="(8)" ParameterRuntimeValue="(8)" />

</ParameterList>

If you're looking at...

Yup, down in SA. Post...

That's not an objectid. It's...

Mohit (5/4/2009)

---

I understand your points, I think the Microsoft consultant was just suggesting I should seriously look at the fields in questions because there is no doubt for room for...

Luke L (5/4/2009)

---

Or perhaps that seeing the name might be enough to jog your memory, although I wasn't sure since you're from South Africa. Not sure how much...

No, it is covering and the optimiser should, theoretically, be picking it. Might be a bug, might be something subtle that we've missed.

If we flip the query and the index...

Be nice. 😉

I'd have googled it if I'd had a clue what to google for.

Odd. Behaviour doesn't change even if there's a lot more rows added. I'm going to ask some other people, see if I can get an explanation.

The output list of the...

Extended events are new in SQL 2008.

What?

Why are you shrinking your log on a regular basis? It's just going to have to grow again. When it does it's going to slow the system down. Also repeated...

Mohit (5/1/2009)

---

I was talking to Microsoft Tier-3 Support guy about SQL Server; he suggested using the Dash Board there is a 90%+ improvement there will definetly be improvement. He...

There's no automated way. To make the subscriber the publisher you need to drop the subscription, set that server up for replication (creating a distributor) and then create the publication...