I get the feeling that you're not sure what are you going into.

As I mentioned, it's like shift from procedural programming to OOP. You build several layers.

For example in windows...

Seems like nobody is able or willing to share some hard experience. What was your decision/rationale with your boss?

The fundamental problem is that between your query (top or max) and your insert, at least one other user can do the same, so you end up with duplicates.

If you...

GSquared (4/21/2008)

---

Since an indexed view is, fundamentally, a separate table, that would work. I'd go with a separate table, because, to me, that's easier to document. But really,...

The OP wrote a vague question. If he/she doesn't take the effort to clear doubts, why do you keep guessing?

Bill Geake (4/21/2008)

---

I really wouldn't want this, even though we probably only have about 1000 devices. Major reasons:

1) Any fault on a user device means a full diagnosis effort; anything...

You use Max(primary_key) to get the next value for insert?

Usually not a good idea. Instead use autoincrement identity type column:

create table X (ID integer identity primary key, data varchar(254))

--you omit...

Check what?

Existence of columns? data? integrity? statistics? relations? or...?

Depending on data and queries, an indexed view could be a perfect solution.

http://msdn2.microsoft.com/en-us/library/aa933145.aspx

I tend to agree. If you're a network admin and manage all desktops, people stop using their brains. If you leave them freedom, they will make mistakes, even very stupid,...

Thanks for all responses. This fact (or common misconception) surprises me.

Pretty useful script, alzdba.

No, not without specific questions.

I could write a book about this and still not add something you haven't thought of.

ORM is excellent for models that don't fit well into matrices...

It all depends on requirements, database model and frontend tool.

If you're porting an existing project to ORM, you should first create low level objects that match database objects and implement...

Based on one case?

It doesn't matter dba or developer. The person matters and there are a lot of different kinds in both baskets. Also, there are many people that are...

Derek Dongray (4/15/2008)

---

The danger is, however, that some people may get the newsletter, read the articles and editorials, answer the QOTD, and never look at the followup discussion as to...