The Dixie Flatline (9/29/2010)

---

GilaMonster (9/29/2010)

---

Grant Fritchey (9/29/2010)

---

GilaMonster (9/29/2010)

---

Just found out that the PM promised the users that they can see the reports on monday (as in next week). Fat bloody...

Jeff Moden (9/29/2010)

---

CirquedeSQLeil (9/29/2010)

---

So even though we can demonstrate to him that his approach is slower than another approach or takes more locks or whatever, he just dismisses it as...

scott.pletcher (9/29/2010)

---

I would stick with the more used field (and properly ascending) field. On an index, the most important thing is to match the first column in the index,...

Nevyn (9/29/2010)

---

Grant Fritchey (9/29/2010)

---

I guess my question is, where does the slowdown occur? Is it in the insert? If so, are you getting lots of page splits or is it...

Piling on a bit...

No, neither differential or full backups affect the transaction log.

I guess my question is, where does the slowdown occur? Is it in the insert? If so, are you getting lots of page splits or is it just an I/O...

Jack Corbett (9/29/2010)

---

So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who goes off and does...

Yeah, late to the game, I was going to suggest READ COMMITTED SNAPSHOT as well.

Isolation levels are very different from locking hints. Isolation levels define how transactions will behave...

Stefan Krzywicki (9/29/2010)

---

Oh, I think there's a point to meetings. If you're all working on the same thing and are talking about problems so everyone can think about solutions or...

Yes, READ COMMITTED is the default. Well, I'm stumped then. Something that is just a SELECT shouldn't be grabbing exclusive locks, so the best thing I can suggest is...

GilaMonster (9/29/2010)

---

An extension of...

scott_lotus (9/29/2010)

---

That's a good point. Im sure the query is SELECT only. Added (NOLOCK) to the larger tables used but not the table in question.

1) I thought SELECTS exclusively...

Matt S. (9/29/2010)

---

@Grant

I hear you. I've seen DBAs light up with some glimmer of hope when I'm hired to reign in developers gone wild. It's because I sell my services...

Brandie Tarvin (9/29/2010)

---

GilaMonster (9/29/2010)

---

Got a project manager that holds a weekly meeting in which does the following:

* Asks the developers what they are currently busy with

* Updates his % completed...

Matt S. (9/29/2010)

---

I also partially agree with the comments made against ORMs. I feel that many developers use those tools to generate the DB and that makes me shutter. As...