I think I hear an echo in my head.

How do you know which payment goes with which pledge?

I have 2 ideas.

1) If you MUST use this schema, then I would probably write a stored procedure that asked for the accountid and pledgeID, and perform an insert into...

The point of the question was to get folks to learn about the fact that while sp_update_jobschedule is available, it is not the best answer, as it is only available...

Thanks Jason. And yes, it IS addictive. I can't get enough of this site.

http://technet.microsoft.com/en-us/library/ms187354(SQL.90).aspx

I submitted a suggestion and I don't believe it's trivial. I caught a few of my DBA buddies off guard with it. And Steve, I truly appreciate what...

Well, now I have a weekend project.

I got this question right. But, it had a POORLY WORDED answer. You do NOT ask a question and then pose a "true/false" answer. You make a...

Yes, this is another wonderful trick question that we'll have to deal with in everyday life as a DBA.

Perhaps, in some countries, where there are 100 million Oracle DBAs and...

I am beginning to wonder about the wording of the questions and answers on this site. Some answers are so downright cheeky that I am forced to answer other...

I agree. I know you can't backup snapshots, but then why wouldn't you take another snapshot so that it is fresher than an older snapshot with a fuller sparse...

It would be great to be able to see the pictures that were uploaded. Perhaps my firewall is blocking them, but I don't think so. Seems like some...

Just needed to dump those training wheels. I missed the paradigm about how to return n number of vars for n number of columns on my first several tries....

In the least, you can take a very very cursory look at how the query optimizer has been viewing queries involving the table in question by downloading and using the...