Danny Holcombe (8/27/2010)

---

>> Event trigger on the witness to fire off a command line to kill all pooled connections on the web server.

Andrew,

Do you know of another solution for classic...

In some recent testing I found that with a document only about 30 columns...

If your tables have ids in order you may get better performance by selecting ids in order rather than using TOP. If your tables have date columns you can...

Gail - does it still make a difference to sql server if your query predicate is in the same order as the columns in the index? I noticed index...

AFAIK, the data that was minimally logged during the current log interval. Like...

Be careful with that. It's only accurate to the minute. So 23:59:30 = 0:00:00 when using smalldatetime and that...

WayneS (6/28/2011)

---

wbrianwhite (6/28/2011)

---

I'm not sure why you're keeping this in a cursor at all. The report looks simple enough to just write the entire report as a big select...

I'm not sure why you're keeping this in a cursor at all. The report looks simple enough to just write the entire report as a big select statement. ...

By definition it is impossible to change a TABLE valued function to a SCALAR function. One returns a table. One returns an int or a string.

You...

David Ziffer (11/11/2010)

---

Brian: Let me illustrate the benefits of the RAP approach with a scenario. Let's say you and I both implement the same application and we have the same...

I imagine that you are accustomed to the traditional model in which all versions of every record are stored in the same table as the most recent version, and...

David Ziffer (11/5/2010)

---

Brian: Your comments suggest to me that you are accustomed to an archiving model that is entirely different from RAP's archiving model, and that you are presuming that...

Er, my case statement is a little off. Too many whens :ermm:

David Ziffer (11/4/2010)

---

wbrianwhite (11/4/2010)

---

wbrianwhite (11/4/2010)

---

Several problems. 1, what is @AsOf is a future date? Your function returns nothing from live or archive table. 2, the select max...

wbrianwhite (11/4/2010)

---

from TBadmUser#

where UserId = @userid

...