From one perspective, it really doesn't matter which method you choose as long as you're consistent. However, if you choose pluralism, it becomes difficult to maintain consistency.

For example, I have...

That's a good point and worth pursuing.

I just upgraded to the latest version and it has the same functionality. I thought perhaps it had to do with an automatic switch to the results pane, but that...

Nice article! I have been lucky enough to have visited 8 of those cities. I look forward to expanding my list!

Redshift is based on an earlier version of Postgres. It was modified to be a columnar database, but it doesn't have many of nice features and functions that were added...

Glad to see that I'm not alone in my confusion here! None of the answers fit the actual situation. As I expected, I got a result set from each table.

As Eric Russell pointed out back in 2016, I've used a hybrid approach before where the data is written to a file for performance and in case the server crashed,...

Eric,

In you situation, your essentially extracted the customer-centric data into a single document per customer then used a document database for that very purpose. Good use there considering the data...

• This reply was modified 4 years, 5 months ago by Aaron N. Cutshall.

I think that NoSQL environments have their use cases and shine well in those. I think the biggest problem is when we try to use NoSQL tools to replace RDBMS...

I also consider that to be mostly a "marketing for Microsoft" site.  Consider the number of hits the bloody community put on the "dark theme" request in SSMS and...

In order to use one of the other data types we have to use a different type specification. While you can use all of those listed datatypes in RAISERROR...

I checked my answer against the Microsoft Docs and it states:

argument

Are the parameters used in the substitution for variables defined in msg_str or the message corresponding to msg_id. There can be 0 or...

I have to admit that this is an opportunity to be more inclusive than to just SQL Server. In addition to on-prem SQL Server, I also work on both SQL...

I began presenting for SQL Saturday in 2012 with focus on fundamental skills to help guide new people and to help refresh skills for more seasoned folks. This has been...

Yep, that's because they still don't accept responsibility! I've been in similar situations...