Sorry, misread your post. It's the SQL Server service account that needs access, not the user you're connected as, or the Agent service account.

Have you actually logged on as that account and physically tried creating folders and files under that path?

I can't think of anything at the SQL side that would cause...

Power View is the SSRS/Sharepoint components, and no, it's not licensed in Standard Edition. The change in 2014 is that it's now compatible with multidimensional models.

The BI Semantic Model (multidimensional)...

bas_vdl (5/15/2014)

---

HowardW (5/15/2014)

---

bas_vdl (5/15/2014)

---

Hi HowardW,

Thanks for your input. You're right about the fact that the ip ranges are not overlapping. The query you suggest is very slow. In my first...

bas_vdl (5/15/2014)

---

Hi HowardW,

Thanks for your input. You're right about the fact that the ip ranges are not overlapping. The query you suggest is very slow. In my first post I...

As others have said, you can't avoid a scan if you're returning all rows, however, the naming of your tables does suggest there may be a better way.

1) IP to...

I haven't used partitioning with heaps, but with temporal audit tables, I'd tend to make them clustered on the datetime field anyway and this would then become the natural partitioning...

gbritton1 (5/9/2014)

---

I'm not sure this will always give you what you want. It may not even give the same answer on subsequent runs. The reason is that your...

The syntax you've posted works with a simple select query, so I think you'll need to post an example of something that actually produces the error...

The scenarios that are supported are listed here:

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

The main caveat for Eval edition is:

Upgrading from Evaluation Enterprise (a free edition) to any of the paid editions is supported for stand-alone...

You need to speak to your network team.

Typically, when implementing a proxy, you lock down your firewall to only allow outbound connections when they're routed via the proxy (or people...

Do you use Filestream or Full Text Indexes?

Difficult to answer that really. If you could make use of the new features in 2014 and aren't a particularly risk-averse company, test it and go with that.

If you're a...

I'm not aware of any big breaking changes. Are you using any assemblies outside of the supported ones?

Not sure of the exact message you're getting, but the first thing that...

There may be some marginal gains to be had by some optimising indexes etc. to support the sorts and joins (possibly at the expense of an OLTP application's performance), but...