Here's the info we recieved from Microsoft:

Based off the case that we had opened with MS, the best recommendation we have from PSS is to monitor MTL using "DBCC...

Holy Cats! We just ran into MemToLeave issues to. I had no idea what a limit there was on the servers due to memory management prior to hitting that problem.

I...

I can't believe you've got me working in Access to try this out, but here goes...

I did it by simply converting the data for both columns to a string, then...

I'm no Oracle expert, but I thought that was set in the TNSNAMES file.

We've been using Quest Stealth Collector to get aggregate information out of Profiler data on the fly and with history. If there was a way to make this tool more...

Just a guess, but when I used the configuration wizard, it stored the Oracle password as "******" instead of the actual value. When I edited that to an actual password...

Despite having had the ability to cascade delete for years, I haven't set it up, not one single time. It is too scary and completely out of control. At the...

Cascading deletes are a different requirement than that if a parent is deleted, so must the children. The question is one of automated actions vs. intentional actions. With DRI in...

There's a nice little task that was created for just this purpose at SQLIS.com (http://www.sqlis.com/default.aspx?23). I've used, not in production yet, and it works very well.

There are also some decent little samples out at SQLIS.com

Not an Integration Services question, but... You get a new error log each time SQL Server is restarted. However, in order to keep the size of the logs smaller, you...

I'd report this one to Microsoft.

I tried, but I can't replicate the behavior. Any other clues?

And so, your code is flawless, always. And the next guy who writes some code against your system, he too doesn't need data integrity checks because his code is perfect....

This is a pretty amazing thread. What I haven't heard anyone mention or emphasize are the business requirements that the data is modeling. Surely the database design has to meet...

I sure can't tell you how to measure quality. We do try to add quality as a requirement in the code we right. We're following the test driven development methodology...