SQL-DBA (4/27/2012)

---

I think many people are missing the point, or let's say use case, of this article. Users are not always rationale, nor do they necessarily have SSMS installed....

Encryption is an extremely useful layer in what should be a multi-layered approach to data security, and when there is any doubt whatsoever about the sensitivity of the data, it...

Great article. I think a solid grounding in set theory would be very helpful for many DBAs.

If I may respectfully offer a couple of minor corrections and clarifications though:

Your...

I have run into this problem off and on, and once even wrote a solution to it ( http://www.sqlservercentral.com/scripts/Print/63240/%5B/url%5D ). After struggling with it myself a few times, I...

I have to agree with you. Taking steps to ensure that disk space is not wasted is definitely beneficial.

But there is a counterbalancing point: Disk space is normally cheaper...

A fantastic article. I think I would rather approach this particular problem in pure T-SQL (or bringing it into something more suited for thorough statistical analysis, depending on the...

I must apologize. This was meant to be a reply and not a new topic. Is there someway to delet this?

agree with some, but not all of the conlusions. There is value in standardizing the things that it makes sense to standardize.

With that said, first this is an attitude that...

mortenmaate (9/8/2010)

---

Thanks a lot for the great overview !

One thing I would like to mention additionally: Look a the SQL Server version. In my experience many companies upgrade their SQL...

It is definitely good to have this pointed out since a lot of people do not realize it, and this was well written and clear.

From my standpoint, it tends to...

This provides an excellent overview of the current MPP situation, thank you for providing it.

fahey.jonathan (8/9/2010)

---

The use of the term "schema" in this article is confusing because the term has a specific meaning in SQL Server which differs from its use here. Perhaps...

Hugo Kornelis (8/9/2010)

---

It's an interesting technique - but not one I would recommend!

The simple version has this caveat: it works "as long as they share the same primary key and...

My knowledge of Oracle is limited, but I understood that a Materialized View was always accurate to the second, just as an Indexed View always is in SQL. If...

This was a rather interesting article. But it made me think of two things I think are worth noting.

First, when dealing with complicated queries over large datasets that do...