I would ignore the where completely unless I'd know only a small % of the rows would get updated.

This will do a table scan anyways. So you might as...

If he never heard of it then it's new to him and new to 2k5 vs 2k ;-).

New "feature". Order bys are ignored in the views.

Nothing you can do except use order by from outside the view =>

Select Whatever From dbo.View ORDER BY Column

Let's make it 3 :-D.

No seriously, I'd go with either of those 2 before me 😉

Michael Valentine Jones (8/22/2011)

---

According to this link, all of the following upgrades are supported for both x86 and x64:

http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx

From:

SQL Server 2008 Enterprise Evaluation

To:

SQL Server 2008 Web

SQL Server 2008 Workgroup

SQL...

Never lost that bet...

Check if you have maintenance plans or ssis packages.

You have something doing a large import or index being maintained.

The logs just won't grow a lot without 1...

You can but you won't see a huge speed improvement from this and it'll be a little harder to read for the juniors.

Turn the 2 updates into a select, the...

I'd bet a large sum of money that you have a reindexing job running during the night.

use this to update only the indexes that need it : http://sqlfool.com/2011/06/index-defrag-script-v4-1

I've never seen a maintenance window so tight that you had to think it through so hard.

Granted I have only a small db to maintain here but even updating 100%...

There's not much to tune here.

Index are there to <mostly> support filtering or order operations. Neither of which you ar doing here.

I can take a quick look and the...

Grant Fritchey (8/22/2011)

---

One more for when you get back to the office. Another thing you might consider trying (and boy, oh boy, would I test this one to a fare...

That's pre-screening to...

Grant Fritchey (8/22/2011)

---

If you do a little searching, I posted the questions I used to ask on phone interviews, if you think that will help. But the in person interview......

Why not network here?? What are you looking for Chris? I'm sure 1 of us can recommend someone!

Uninstall.

SQL Server 2008 (32-bit, x64 and IA64) Evaluation

No Upgrade Support

http://msdn.microsoft.com/en-us/library/ms143393.aspx