For licensing questions, you should always talk to your Microsoft representative. People in these forums are techies, not lawyers.

That said, as far as I know, yes, you need a license...

Again:

1) CREATE TABLE statements for your table(s).

2) INSERT statements with sample data, enough to cover all relevant cases.

3) The desired result given the sample.

I will be travelling tomorrow, so if...

I repeat what I said in my previous post:

Generally, when you ask this question like this, it helps if you post:

1) CREATE TABLE statements for your table(s).

2) INSERT statements with...

Not sure why you would create an inline function at all. The reference I gave you is from a larger...

Before we start talking about sargable arguments, maybe we should see if there is anything to sarg for. From what Duncan says, there does not seem to be any.

We have...

If you look at the promotion material from Microsoft, it seems that the really hot stuff - Availability Groups and Columnstore indexes - are only in Enterprise.

However, what really is...

You need a table of numbers, I have an explanation of this concept on

http://www.sommarskog.se/arrays-in-sql-2005.html#tblnum (only read down to the header "An inline function".)

Once you have this table, you can...

sf.onlineforums (9/21/2013)

---

Loading data by date, every week, is the main reason for redesigning partitions to be based on dates. I like your idea of generating an artificial key. Do you...

The important thing is not whether you do DBCC or not, the important thing is that you understand the ramifications of what you are doing.

For instance, if you want to...

Could you post the exact error message?

How do deduce that the first LSNs are the same?

Is the index stored on the partition scheme or not? It if its, the partitioning column is effectively the first column in the index.

If the index is stored elsewhere, the...

You could write a server trigger for CREATE DATABASE that adds this user to the database. I like this better than adding a user to model, because a server trigger...

The almost ANSI-compatible way of writing it is:

UPDATE ZZZDocContProfile

SET DC.[DocumentType] = (SELECT SUBSTRING(STG.[CurDocNum],1,1)

...

If you look closer the in the after-trigger trace, you will find that it is only the first invocation that takes a longer time. Furthermore, if you look close at...

If it is messed up on a nightly basis I would suggest having a trigger to fix the bad data directly. Unless, fixing the source is within your powers.