from TBadmUser#

where UserId = @userid

...

jyurich (11/3/2010)

---

Am I the only one using Microsoft's Entity Data Model (EDM) technology as an ORM for modeling as well as for the data access layer? This is a part...

Jeff Moden (11/1/2010)

---

Hi Brian... I know who David Ziffer is... he wrote the article. I've probably missed it in one of your posts on this thread but who are...

RobertYoung (11/1/2010)

---

wbrianwhite (11/1/2010)

---

RobertYoung (10/31/2010)

---

wbrianwhite (10/30/2010)

---

I have a hard time believing this. How would a code generator know enough about...

Jeff Moden (11/1/2010)Heh... there're a couple of dozen people on this site alone who are capable of pulling off huge multi-row inserts from a GUI via a stored procedure. ...

RobertYoung (10/31/2010)

---

wbrianwhite (10/30/2010)

---

I have a hard time believing this. How would a code generator know enough about your application...

I have a hard time believing this. How would a code generator know enough about your application structure, data...

Jeff Moden (10/30/2010)

---

@David Ziffer

I have a question based on the following snippet from the article...

First, I whole-heartedly agree with the principle of storing the same AuditDate when adding a "group"...

David Ziffer (10/29/2010)

---

RobertYoung (10/29/2010)

---

And do you have terabyte+ data because someone never bothered with defining normalized data? Are you doing text processing? There is no de-normalize for performance....

And do you have terabyte+ data because someone never bothered with defining normalized data? Are you doing text processing? There is no de-normalize for performance. It doesn't...

RobertYoung (10/29/2010)

---

ron.buchanan.us (10/29/2010)

---

If you are going to insult a design of which you know little about, at least elaborate. I...

Not really. A history trigger is a far better choice. The stored proc can only ensure...

http://blogs.msdn.com/b/sqlazure/archive/2010/07/27/10043069.aspx

Just a note, non-clustered indexes (what you make when you do a covered index) reduce the performance of your writes. This is because on insertion or updates, the...

It's amazing how often you don't need to worry about re-writing SQL when all that's needed is a new index, or updated statistics. If either of these two meet your...

Make sure your where clause is SARG-able or indexes won't help:

http://weblogs.sqlteam.com/dang/archive/2009/03/07/Low-Hanging-Fruit-of-Sargable-Expressions.aspx