I think Jeff is right in that coding comments can be good documentation. They might not be all you want, but they can cover things from the tech perspective. Whether...

Agree with Ed. Not sure what you mean, but I'd think CAL makes sense here.

Do you have other triggers? Can you filter these out? Maybe rename them to be a pattern that can be ignored?

GilaMonster (5/14/2015)

---

Question for the people here...

Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

This is what's on the main page: http://download.microsoft.com/download/B/4/E/b4e604d9-9d38-4bba-a927-56e4c872e41c/SQL_Server_2014_Licensing_Guide.PDF

It's not clear, and buried a bit down in there, but says 4 core min.

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...