Eric M Russell (5/18/2015)

---

When initially creating a stored procedure, I'll sometimes copy / paste text from the functional specification into the header comments.

Also, it helps to include the RFC#...

Gary Varga (5/18/2015)

---

So untrue.

The key in code comments are what gets commented. You shouldn't document...

David.Poole (5/18/2015)

---

We must not lose site of why documentation should be written. It is to impart useful knowledge to the poor sod who will end up maintaining your code....and...

Jeff Moden (5/17/2015)

---

Heh... I look at the recommendations for "scripting" languages with a bit of disgust. There are so many things that SQL Server does very well through T-SQL...

I'd rather be harsh now than having them be unable to find a...

briancampbellmcad (5/15/2015)

---

I'm not sure what you mean by a 'drive' on the server... all I can get to is \\belmont\c$ and the \\belmont\Databases\Data which is where I see BCCrestore.mdf and...

There could be, in that if the workload is high, you might get some better throughput to separate LUNs for each db. However I doubt it. Many times you aren't...

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