NP it's a common question so it must be hard-ish to find the answer.

Have you intalled he script I sent you?

Small index can't be defraged.

http://sqlfool.com/2011/06/index-defrag-script-v4-1

What are the indexes on the table Arueck?

This shouldn't scan!

Jeff Moden (12/21/2011)

---

Aspet Golestanian Namagerdi (12/21/2011)

---

Actually I stopped the Log shipping Backup job and also I disable the replication jobs but still every 10 minutes,slowness happens on SQL statments...

Replication is not my forte but that would be suspect #1 on my list now.

Easy test is to stop replication for 25 minutes if this has no hill effects (which...

So what runs every 10 minutes on your server?

If you can post the new plan we can look it over to see if we can improve it further. 5 seconds is still slow in my book 😉

She's a Dev, so am I. Doesn't mean we can't kick butt there...

Neither exam or interview (too many points and visits in this case).

Looks like the old syntax of left join. Not the standard anymore.

I never said I dreaded them, but then again I don't work with a team of devs, so the "bad" uses just don't happen here.

assistan11 (12/20/2011)

---

Hi Ninja,

It's Navision version 4 without SP.

I can assure you it's from single table.

I tried to conceal our company name but missed a part of it (", PT") in...

SB is not my forte so I'll be in listen mode most likely.

What version of MS Dynamics Nav is this?

It looks like you have a cross join in that query (FROM tbl1, tbl2 and then no where condition to make a join)

I...

That screams index rebuild / reorg or big ETL.

salary.com might give you those answers.

My answer is whatever someone's willing to pay you after the interview, and more importantly on ongoing basis after they get to know you better.