I totally agree. The complex queries I was talking about perform a lot of different actions, complex business logic is implemented in SP's. These kind of statements (seperate steps/parts of...

wbrianwhite (8/25/2009)

---

Look at the execution plan, look at and think about what you are typing. Having complex queries will benefit from compiling and recompiling a stored procedure. This is because...

wbrianwhite (8/25/2009)

---

If you're talking 1,000+ that is one thing - but 100 is a trivial amount of data to return to the front end, and it should be quick to...

wbrianwhite (8/24/2009)

---

Michael Ross (8/24/2009)

---

Rerunning queries multiple times and clearing the cache? Is that REALLY necessary every time? That just leads me to believe that the developer really...

thanks Michael Ross, I forgot about the DBA. I didn't think about that one, since we don't have one:-D

But the reactions exactly draw out what I mean. To technical! Having...

I totally agree that this is what should be done first! That is even one of the biggest reasons why we always want access to the production systems of our...

The approach that the customer is always right, is totally wrong. Make them think they are right whilst feeding them with your own ideas is the way to go. Programmers...

isn't this a little easier??

CREATE Function GetMonthEnd(@Date DateTime)

Returns DateTime

AS

RETURN dateadd(d,(day(@date)) * -1,@date)

END

I've tried running some procedures from VB and from Query analyzer. No actions where taken on the database and no time (hardly any) was between both executions. Still the one...

Hi there,

Just observing this stream, because I had the same problem a couple of times and I have found no solution.

This also happens when there is no com envolved. When...

NON!!! it will actually not even compile, the sub select does not contain the item table from which the field DID is selected!!!