Test

Wow, quite the story and glad your son is doing well.

I completely agree. This wasn't as much about life,...

I'm trying to learn to do better at writing things down in a planner. But then I get too busy to write it all down and things lapse or...

"I walked outside to take the call during a break and was told I wasn"t responding quick enough to the call. The emergency? A test of how quickly I'd...

Just add it in:

SELECT t2.VID, t2.OrdDate, t2.Prg1,
       CASE WHEN t2.RowNum = 1 THEN VIDCount ELSE NULL END AS VIDCount
FROM (
 ...

They will. And there's...

Over the years of learning the hard way in database work, I grew to get a little better at good satisficing (perhaps manually importing some data short-term until it...

Excellent article, ...

I absolutely love it when the challenge at hand requires a graceful and carefully engineered solution, but I also find it gratify to simply craft something that...

We don't, though you could certainly disconnect a network and see if anything fails or if you can track anything.

Part of the QotD is knowing defaults. This was left off, as many people do this and the default is to allow NULLs.

As a good practice, however, I agree. You...

I don't know either. I have  2 hr meeting today, actually one that should be good, but a few more in the last week weren't. We do have some monthly...

I have no idea. Can you repro in another db and share some DDL?

I think this is likely to become more of an issue in the future. Hopefully, we find some better solutions that don't dampen the enthusiasm for using OSS stuff in...

The question has been adjusted. My mistake for miswording things.

Perhaps, but I'm not sure that's the case. A lot of things we thought were private in the past, actually weren't private. What happened was the data was too hard...