Siesta

Divining rod

Brandie Tarvin (5/3/2010)

---

You can't rely just on writes, though. Excessive reads could also be causing an issue. Especially if there's a RBAR problem in the query. Bad use of indexing...

Gianluca Sartori (5/3/2010)

---

I see that this thread is still alive, so I'm throwing some more 0.02 € in.

Adam Machanic wrote a great monitoring procedure that could help you tracking down...

Steve Jones - Editor (5/2/2010)

---

I've seen a couple incidents of plagiarism lately on different sites. Not all from this site, but a few places that have copied info from MSDN/Technet,...

Lynn Pettis (5/2/2010)

---

How about this one regarding ethics?

On freelancer.com, some one has posted a job looking for an experienced programmer to develop an SQL injection script for godfather points in...

Yes.

keywestfl9 (5/1/2010)

---

yes it helped to finish my task. thank you all for the help

They want to do for another report in access the same thing,i will try and post it...

Mike Seattle (5/1/2010)

---

Could you please explain why? I mean, why is that line causing an error and what...

It catches all of us...

Nice script.

The difference in size may also be that the sp_spaceused is reporting on clustered indexes where the sp_mstablespace may not be.

Agreed

Also try to run an updatestats

Since that query relies on a MS provided system stored proc and sp_spaceused is a system stored proc, I would venture that some stats are messed up somewhere.

Try this query...