Thanks for taking the time for that feedback, Hugo. I appreciate it.

Running totals are no excuse for using cursors... not even for display.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

So far as the "bin packing" thing...

Hi Hugo,

Do you have an example of when that might...

Your turn, Pal... how about some feedback. We need at least 2...

nisan.al (7/24/2008)

---

Tempdb suppose to be growing until there is no more space available.

So there are two options:

1. some definition are wrong - check if tempdb deifintions are set to ...

So, do you have a grip on generating the test data or do you still need a bit o' help on that?

Thanks, Jonathan...

pockeyfan (7/22/2008)

---

Here is the error message:

Number (208) Severity (16) State...

Heh... I missed that data marts were involved. 😉

If you want the object ID from the name, why not just use...

SELECT OBJECT_ID('objectnamehere')

There are several system functions that will help keep you from redeveloping the wheel... just look them...

Ummm... let's do a small test on the "bad" machine... if you open a "Command Prompt" window, type DIR and press {Enter}, does it return anything? And, no, not...

If transactional replication does not replicate truncations, then there is no need to audit inserts to rebuild a truncated table because you can always get it back from the replicated...

Ah... I get it now... you want to test/compare every combination of 1 to 10 characters (36 characters total) of the old UDF against the new UDF. (36¹¹)-1 is...

Thanks for the feedback...

By the way, being a bit of a code formatting and documentation freak, I really like your tagline on your posts. 😉

rbarryyoung (7/23/2008)

---

1) Recovery: Audit table is supposed to serve as a means to reconstruct a pre-existing table/database. Audit table is stored in a different DB & disk or...

Lester Policarpio (7/21/2008)

---

Good Day,

I want to ask how to troubleshoot this kind of problem. I'm handling many servers everyday (select, update, delete). I created...