Gary7512 (5/29/2010)

---

Thanks Paul, I will take note of what you're telling me. It does seem like a good magic solution, but I suppose some fables warn the use of magic...

Sorry, but that sentence does not make sense to me. 🙁

If you mean that you have to include...

With the best will in the world, it's impossible to suggest an appropriate set-based solution without knowing more about what the complex financial calculation does. I realise you had...

Why don't you have a decent crack at it first?

See how you get on.

Gary7512 (5/29/2010)

---

My colleague who is more technical than me says: "The way it works is that the Hyper-V VSS writer on the host tells VSS in the guest to get...

Perhaps some demo code will make the issues clearer to see:

CREATE PARTITION FUNCTION

PF_Date (DATETIME)

AS ...

You should certainly consider MERGE (if you are using SQL Server 2008) but you need to be careful with either method if there is concurrent activity on the destination table....

Known bug, fixed in SQL11, will not be fixed in 2008 or 2005:

https://connect.microsoft.com/SQLServer/feedback/details/416197/the-missing-index-feature-suggests-an-index-which-is-already-present#details

Lesson: don't use dynamic cursors!!!

Confused by the link?

See:

http://www.sqlskills.com/BLOGS/PAUL/post/Missing-index-DMVs-bug-that-could-cost-your-sanity.aspx

Nice (but quite shocking!) question. I'm not at all embarrassed to say I got this one wrong.

In the same way that 2+2=5 for sufficiently large values of 2? 😛

Good to know the Y2K problem is still alive and well 😀

You corrected the bug that ColdCoffee and Kingston missed, but all the solutions presented so far use a form which cannot seek using an index. The best they can...

Side note:

It's not often worth persisted expressions like this - this optimiser very frequently chooses to recalculate the value from the base columns instead - particularly if the computed value...

Use an XML format file and OPENROWSET BULK. This allows you to modify the bulk load stream without losing any of the benefits of bulk loading - it will...