This is not automatic, but usually when you have 2 dbs like that, you also have 2 servers. So the speed increase is almost automatic.

Even if you keep it...

It means all the columns required to run the query are in the index.

That means columns from the select, joins, where, group by, having, order by....

are all contained in the...

reread the 1st paragrapgh... can't be much clearer than that.

What are you not understanding?

What problems are you getting? SUM will ignore the null in the total and you'll get accurate data.

I can be the first beta tester if you want :w00t:.

GilaMonster (3/22/2011)

---

Ninja's_RGR'us (3/22/2011)

---

Alright, I was wondering if you have taken that task on and had something...

Alright, I was wondering if you have taken that task on and had something tested.

Since I...

Do you have a version that also handles the stats?

Update stat is missing from the latest version, but this is the best script I know at this point.

http://sqlfool.com/2010/04/index-defrag-script-v4-0/

Right click on the report in the explorer pane, view code.

That will give you the xml source code. Keep in mind that you have 2 instances of the same...

run multiple procs rather than just one.

I don't know your market, but 80K to 100K doesn't seem overpaid at all.

Check this out... that'll give you some market research.

http://salary.com/mysalary.asp

Can you send us the link to the job posting? Without that it's a bit hard to provide more info.

grahamc (3/21/2011)

---

Sort of along the original lines of the thread topic, but whats the contract job market in Toronto like for SQL DBAs?

I have worked in South Africa, England...

Jason Messersmith (3/21/2011)

---

I'm just curious if anyone had updates on their rates? I basically got told that $50 per hour was way too high for someone with 4 years...