With large updates - the "committing to disk" part of the process can actually take some time.

Also some operations like truncate happen on the disk and those data pages just...

Ditto - thanks for the feedback!

In the failover concept, the passive failover node (meaning, a node that is used for NOTHING other than being the backup), then you don't need to license it separately. ...

SQLServerLifer (3/13/2008)

---

Yes, it's called the HAVING clause...

SELECT COUNT(*) AS total

,last_name

,first_name

FROM account_contact

WHERE account_id = '11997'

...

Grant Fritchey (3/14/2008)

---

Oh, we had freon too. Did you know that...

Well - there goes the "clean and professional" part....:w00t:

I can't say I can top that by any stretch of the imagination. I do have some strange ones:

- I...

Jeff Moden (3/13/2008)

---

Indexed multi-table view... multi-table SELECT... which one will you call UPDATEable? Neither in all likely hood. An update would have to be something separate... paging isn't...

Nick M. (3/13/2008)

---

The need to return the EntityRef identity value from the Entity table to insert into the Address and EntityCustomAttribute table. As FK's they cannot be null, and...

Jeff Moden (3/13/2008)

---

Make the UDF accept the table name as an additional parameter and pass it. Just remember that UDF's can't do Inserts, Updates, or Deletes on tables nor...

The indexed view might work...as long as it's not needed to be updatable (since we're now talking multi-table view and all). Especially if you manage to "precalculate" the paging...

Yup - that's another good one. I'll have to experiment. It's not that I don't see how it could be used: it's more like I've somehow managed to...

you'd have to set up some kind of automation wrapper around the app (or driving the app)....

Well - it was a cute idea...

Well - I'm pretty darn sure that we're not "messing" with the numbers, since the sub-query is doing the tallying.

Have you checked if anyone has null values (or values not...

(Since...