Michelle Gutzait (4/15/2009)

---

... And I was wondering... 🙂

What are your thoughts about Adam Machanic's article:

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx ?

I tried to compare Adam's code to other options and came up with this...

Bob, did you notice? We should hit 3500 posts soon!

No. Actually I think the tech writer of the article Bruce ranted about fits the description I mentioned.

Let me throw another monkey into the wrench. Over a year ago we were upgrading our PeopleSoft HR system from version 8.8 to 9.0, and this required an upgrade...

For some Technical Writers the term is an oxymoron. 😉

TRUNCATE TABLE does not fire triggers defined on a table, so no.

Jeffrey Williams (4/15/2009)

---

Okay - I am just wondering if Lynn has finally hit his limit. I'm just a bit surprised - and shocked - and the response :w00t:

http://www.sqlservercentral.com/Forums/Topic697843-146-1.aspx#bm697863

Really -...

J-F Bergeron (4/15/2009)

---

I have seen a script where someone set up a "Database level trigger" and caught the sql text that was being sent to the server.

He used it...

JacekO (4/15/2009)

---

This the big IF. This sp is a...

Also, let me google that for you

If I may, you may want to take a few minutes and read this: The Flip Side.

Unfortunately, there is no context with regard to this error, so actually no, I can't tell you how to fix this.

If sys.sp_reset_connection being executed by one application is causing your global temporary table to be dropped for another application, your other choice is to install a separate instance of SQL...

I have an idea on why the difference between SQL Server 2000 and SQL Server 2005.

One SQL Server 2000, the database engine scanned Table2 once. On SQL Server 2005,...

Here are the statistics io and time results from mine and Chris's fast queries:

(7203 row(s) affected)

Table 'Table2'. Scan count 1, logical reads 168, physical reads 0, read-ahead reads 0, lob...