Thanks! This doesn't seem to work quite right when the first value is negative as I get a positive empty entry, but it gets me nearly there, so I'll see...

It's more of a test of how memory optimized tables work more than anything else; it's a simple enough function the existing way of doing it hasn't had any noticeable...

Something like "[ab]+[cd]-[ef]" would create a mini-table that would have a row for "ab", "cd", "ef", and tell you that "ab" and "cd" were positive, and "ef" is negative.

I've...

I've been experimenting a bit with this, and there might be a diminishing returns effect on large tables, or maybe tables of a certain structure.

I tried to run the...

Well this is a newly created SQL Azure VM based on the DS13 model (8 cores, 25600 IOPS, 256MB/sec network bandwidth), and I currently have a storage pool of 6...

Thanks, was looking for something along these lines.

Isn't the first reference to adminfee wrong? The table alias is "x" on this scope, and you don't join anything else that is aliased or called adminfee, so you can't...

It'll vary, but for some of the cases, we might be doing something like loading a customer's historic data, which might be on the scale of hundreds of thousands of...

Hi,

That's fine, it makes sense, but my exact case, I view it as more like if the initial partition is A, then I want to partition switch, but load (A...

Ok I think I have answered my question, have been looking around and I found the below link:

https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

So, I assume if I had a standard instance, and tried to deploy...

I did think that would have been likely, does anyone know if there there are any resources on the internet that might give me a headstart on getting this done,...

Well I simplified it, we do have more granularities. The space saving on this table structure is that it takes around half the space, which is a large consideration, as...

you should be able to left outer join to the table multiple times, which will make the code look cleaner. Something like:

SELECT

CODE,

NAME,

ISNULL(gn1.ONHAND,0) [FORUM AYDIN],

ISNULL(gn2.ONHAND,0) [BURSA CARREFOUR],

ISNULL(gn3.ONHAND,0) [FORUM BORNOVA],

ISNULL(gn4.ONHAND,0) [FORUM...

Weird, I can't seem to use the securables tab of the DB user to assign the stored procedure that was created under this schema to the user, I can add...

Yeah actually that was a false positive, I wasn't actually doing an update as I hadn't populated the test table, that was why it didn't produce an error. Setting the...