Hugo Kornelis (5/19/2015)

---

It actually does (and I should have included it in my article).

Some references:

http://byobi.com/blog/2012/10/column%C2%AD-stores-for-wide-and-sparse-data/%5B/url%5D. (A blog I found when searching the...

Let's please be polite.

To giszzmo,

It's not completely clear what you are trying. It is helpful if you post some DDL and inserts for the data like this:

create table Grades

( SECTION...

I'm not sure I agree UDFs will never be updated. If not, I totally agree. Test once, leave alone.

I want testing for anything that will be refactored.

I'm not sure I'd want the test conditions in a table, but that could work. Potentially managing lots of tests is cumbersome, though I haven't done enough large scale work...

Good job, Lynn. I felt bad for the guy filling in for the DBA. That's a tough spot.

Fair points on testing, but I'll say that this isn't simple. With respect to Jeff and Tom, I don't agree with 100% of anything. At most any scale for software,...

I think you're misunderstanding the way this works.

Imagine that when you run the backup command, it's not you, but that the SQL Server database engine service account does this:

- Logs...

Thanks!

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