Tom,

If you played any part in creating Oracle packages, thank you.

My other beef is that if you need to tweet the query by changing the join from an (implicit) inner join to left outer or right outer due to a...

Did your fine organization implement an ungodly number of triggers as a part of an application release? To the point that when you brought up a valid reason to implement...

I can’t speak as to the ANSI standards. I never knew that implicit joins existed until about 5 years ago despite being introduced to SQL 20 years ago. It was...

Are summary executions off the table?

Don’t make me post some examples. The issue isn’t so much the implicit join but rather understanding the criteria in the WHERE statement when it contains the join information as...

Young man (or woman),

Implicit joins are evil. Always. Even in examples or practice exercises. Repent of your wicked ways.

Dear SQL Demigods,
Are there any concerns with using this CAST? If the value needs to be displayed in a manner a bit more legible. It hasn't caused me any...

Before I posted, I googled around and found a good many articles/posts that basically said to 'Never, never, never, never' shrink the file because of what it does to the...

Thanks for the responses. In Googling around, it's interesting to see the responses to the issue. I'll probably keep the true .net errors for 90 days and the advisory messages...

Appropriately that pineapple-jalapeño casserole is yellow, the same color as the Yellow Screen of Death which ELMAH conveniently captures. Deleting the past 2 years of errors (some legitimate ASP.Net errors,...

I'm incredibly bad at math and doing conversions, but I make a killer Pineapple/Jalapeno caserole.

Thanks. I wasn't certain about if I should post it in both or not.

I need to create a chart in Excel that totals records by weekending date. The catch is that the data may not naturally create the weekending date. For example, the...