Funnily enough - compared to the last thing I was looking at it's a dream of a query. 🙂

I think that the isnulls will probably cause a bit of...

arun.sas - you are an absolute legend - I don't think I can thank you enough!

Thank you so much!

I think I see the logic...

It looks like my table has NULLs as well... where a NULL is the same as 'Start'. I'm terribly sorry if...

Lee Hilton (7/20/2009)

---

I am not near my workstation to test, but I am curious if the tests were affected by caching? Any time I have two statements that are...

PaulB (7/15/2009)

---

That's a good starting point.

Once you have your lab in place try to...

In that case, you cannot fault Oracle's documentation.

Here...

george sibbald (7/3/2009)

---

I think I would take this from the i/o perspective as that is the usual bottleneck , especially in an OLTP system where concurrency is paramount.

I am not...

I'll remember that the...

Swirl80 (6/15/2009)

---

so in an ideal world where your boss came in and said you can any sql server solution (including DR) you want, what would you go for? Load Balanced?...

Oh man... you're not...

Be careful - some of the comparisons are not entirely accurate!

For instance, it says that Oracle has...

In Oracle, you can assign users to separate temporary tablespaces. Is this possible in SQL Server?

Also a short note on the Undo tablespace. The reason why the undo tablespace is...

mtassin (6/30/2009)

---

GSquared (6/3/2009)

---

An example of a bad clustered index is one on a GUID column that uses newid() instead of newsequentialid(), or one on a varchar column with people's names...

Jules Bonnot (6/4/2009)

---

Thanks for your replies.

i think i will write a little test and see how the heap with identiy performs against the CI with identity when under heavy inserts....

Ah... but how would you get around that? Is there any way of disabling the rounding?