It's tl;dr.  Here's a way to open that piece of JSON tho.  At the end of the day JSON is based on key value pairs.  If you don't provide OPENJSON...

This feels almost like an undocumented "feature" (similar to quirky updates)... I know I would be a bit hesitant in how I used this and would probably continue...

The way I came across this functionality was as a...

You're using C# to do things which could also (better, some might say) be done in SQL Server.  You could use xp_DirTree to read filenames from a folder and use...

There is a MERGE statement which does some data consolidation is being run very 10-15 mins. I dont know why. They are giving weird reasons saying its a business...

Easy. Exactly the rabbit hole we all fall into sometimes.

If life was easy, would any of us have a job? After all, some in politics imply with a couple...

We're trying to identify groupings in events, no?  You've yet to describe or list the exact output you're looking for from the query.  Route 810030 has Grp 10, 16, and...

One way to select intervals where the drop off grouping is hierarchically preferred to the pick up grouping could be to divide the data into two groups: Group1 = BookingID's...

• This reply was modified 4 years, 2 months ago by Steve Collins.

Old thread on a 7 year delay!  Minor correction to the earlier response tho.  For generic SQL statements the default is OFF, however, for TRIGGERS it's ON.  The documentation only...

Http verb-specific route handlers in .NET 6 filled the last missing piece of the data access puzzle

Now that the Briefcase in SSC actually works I'm able to find old bookmarked threads.  This was a good one

https://www.sqlservercentral.com/forums/topic/replace-table-with-staging_table-approach

When there is no name provided for an array you could use OPENJSON without specifying a schema and then refer to the array as '[value]' (with appropriate table/tvf alias'ing) in...

The trigger "prevents" (assuming READ COMMITTED only)...

Speculating regarding temporal tables what if you defined ORIGINAL_LOGIN() as the default value of a column in the base table and use a trigger to prevent it from being overridden...

Here's the screenshot!  Congratulations again Jeff Moden and THANK YOU for everything 🙂