If I understand your solution, yes I would expect to see performance problems. Far worse, you're going to have data integrity issues. Even if you contrive to load and manage...

Steve Jones - SSC Editor (1/27/2014)

---

Never had SQL run for 18 years, but I have had it run for 2. The problem I've most often seen with long running SQL...

Saying "it's not the platform" is not at all the same thing as saying that a given application can be ported to a different platform without issues. Anyone who...

Very true Steve. Part of SQL Server's problem is also its strength. By making SQL Server "easy" MS has ensured that there will be many "accidental DBA's" working...

This is one of those knowledge from hard experience things...nice of you to share.

Frankie-464050 (6/16/2011)

---

Licensing: We have SQL Enterpise licensed our physical VM node sockets and this has allowed us to bring up as many SQL servers as the licensed nodes...

I completely agree that VM should be seriously considered for development and QA environments.

In production environments one of the constant challenges I've faced is server sprawl. The...

codebyo (5/31/2011)

---

Mad Myche (5/31/2011)

---

The SELECT statement may be part of DML, it all depends on the context and who makes the decision. A straight Read-Only SELECT does no manipulation so...

Two points:

First off the author, and a number of posts have suggested that "other SQL DBMS systems" are optimized for cursors and that it's only SQL Server that is not....

Thanks, and your're welcome. I'm glad to know that the article was useful.

Are the two tables in the same filegroup? Apart from the possibility that the two are on different disks (or arrays) and one is much slower or busier than...

Thanks, I've been pretty busy at work and home (but aren't we all?) The truth be told, I guess I just blew it off so long that I got...

I might agree with Marvin's sentiment IF there were an accepted nomenclature for the concept addressed in the article. Yes, at a high level, it's just normalization. But...

True enough, I know quite a bit about database design, and next to nothing about you, but what I do know about you is more than enough.

There is no need...

Andrei Marculescu (3/3/2010)

---

Essentially the author is telling us that some time ago he was one of the worst DB developers out there and lately he has started to learn some...