Current licensing says 2 core packs. With their verbiage, it's confusing. The licensing PDF does say minimum of 4 cores, so my apologies.

Good luck here. I think you're in a tough spot now, and certainly a "Case" won't necessarily help.

One thing we did years ago with a DW was have an "as...

EE at $4k / 2 core? Really? I thought it was closer to $7k/core, min of two. The open price is $14k/core.

I think $4k/2 core is more Standard pricing.

https://www.microsoft.com/en-us/server-cloud/products/sql-server/Purchasing.aspx

cheers. If that answered what you need, please mark it (or other posts) as answers for future readers.

You can query DMVs for fragmentation. Do this before and after.

Note that unless this is a read only database, you need some free space for maintenance.

https://msdn.microsoft.com/en-us/library/ms188917.aspx

Are you sa or db_owner? These are separate things. If you are sa/sysadmin, you have rights. If you are the db_owner, then you can see properties.

Netflix started with relatively little bandwidth from their end. They can compete, or Steve's Video Service can compete, because few people use it. A 5Mbps home connection works. As the...

Not in the middle. I've done it at the beginning to avoid exports if disk space was low.

Use a PoSh script to check disk space, then fail the step if...

Does the pattern [ADR*XYZ*] always hold?

If so, when you put this in a table, you can always use PATINDEX/CHARINDEX to find the beginning and offset to the beginning of your...

I'm for neutrality in terms of not prioritizing traffic based on source. However, I don't think that this means Google or Netflix can't pay for higher connection speeds to send...

Jeff Moden (5/11/2015)

---

In that case, I recommend major CYA efforts on the part of the DBAs because that's where the blame will end up if audits fail, audit data is...

I think for the DBAs/developers, who perform the ETL stuff, we do need to think about knowing JSON, XQuery, and more to help us transform data into formats that we...

Agree with the first half. There is work to be done. However, for many, many people, I think...

Sean Redmond (5/12/2015)

---

At all of the presentations that I have been to, it has been presented to the world as a finished product. There is also an element that...

Sean Redmond (5/11/2015)

---

Hi Steve,

How often do we get a version that can promise a 10x improvement to a system? I see In-Memory-OLTP as the biggest change, or, at least,...