...

Regarding Erics suggestion, thats definitely a nifty idea. In our case, I'd be a bit concerned about the amount of data growth that we would produce this way but...

Yes, because of the way ColumnStore data is organized, it is great for read performance but poor for write performance. However, the most efficient way to mitigate something (in this...

One option is to create a table or view that contains the set of values, and then inner join on col_1 and/or col_b.

This would abstract the set of values from...

Performance has a lot to do with page caching and how much memory has been allocated for use by SQL Server. Logical reads (prefetched from memory) are much faster than...

...

Eric, maybe I didn't understand your meaning then when you said:

"so for everyone to mount a flag in their front yard seems to me like a form of virtue...

Whatever happened to the emoji feature? Sometimes I feel like we post something and the underlying emotion is taken out of context.

I have no problem with the USA flag, but I wouldn't mount it in my front yard, for much the same reason that I only wear...

Best of luck. If you have some spare time, please build me a tool that easily, simply, and quickly, subsets data for test systems with minimal customization or programming....

I have no problem with the USA flag, but I wouldn't mount it in my front yard, for much the same reason that I only wear company branded...

I'm proud of my...

• This reply was modified 3 years, 4 months ago by  Eric M Russell.

Flag waving and fireworks on July 4 is perfectly fine. However, it should also be a time for us to reflect on where we stand on keeping the nation unified...

Actually, time was never really frozen for me personally during the pandemic in 2020. Yes, I minimized my face to face interaction with people outside my household, but it was...

Where I work, we have a customer support call center application and also a mobile app where customers can login and look at their account info and payment history. Initially,...

In the realm of politics, statistics are just lies expressed in numbers and colors.

It's good to see AI and Big Data applied to something useful in terms of societal impact - rather than the usual marketing and political applications. Something else that would...