Apologies. Was out of touch last week, but I've adjusted the question to note an INSERT statement and award points back.

Double check your configuration settings for the network. You could have something else open and available. Ideally, we do not expose SQL Servers on the Internet in any...

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...