That's definitely a possibility. Thanks for the...

Events are received and stored in the partitioned table by date. Most of the...

Thanks - That's what I thought but hoped wasn't the case. Without the non-partitioned index it is very expensive to query for an individual item when we don't know the...

Ed Pollack (8/6/2014)

---

Yes! You can definitely create an in memory table using a table type and pass it to a natively compiled stored proc. The only restriction is...

The article is well written and the author must be commended for it.

I tried implementing in-memory tables and compiles stored procedures a couple of months ago, when SQL Server 2014...

Transaction ID was not the best term - I guess I should have used Event ID :-). Event ID is naturally increasing, but there are many changes to an...

Identity as a clustered index was not my first choice. The problem is that this is a high volume, high concurrency OLTP with thousands of data inserts per minute. ...

Thanks everyone for the replies.

In regards to the XML storage as VARCHAR(MAX), we can receive XML that does not go through XSD validation and may not even be a valid...

Thanks, Lynn. That's a nice solution.

I ended up finding the result. Here's the query if others are interested:

;WITH

S AS

(

SELECTDISTINCT value, startpoint

FROM@table S1

WHERENOT EXISTS(

SELECT*

FROM@table S2

WHERES2.value = S1.value

ANDS2.startpoint < S1.startpoint

ANDS2.stoppoint >= S1.startpoint

)

),

E AS

(

SELECTDISTINCT value, stoppoint

FROM@table...

This is inside a stored procedure. Results are not returned to the screen. I'm currently running the procedure in query analyzer to test it, but it's going to be...

There aren't really border values in the data. The partition function would be integer. In the example I gave where there are 10 tenants and one extra partition, I...

I did not mean to do deletes, but to do a switch out, followed by loading directly into the table.

Jeff suggested two staging tables, one for switching out...

What is the advantage of loading data in the staging, non-partitioned table? Wouldn't you obtain the same result by loading the fact data directly into the partitioned table?

Jeff,

I don't disagree with you that I should and will do my own testing should I need to. Unfortunately I don't have the time to run tests on every...