Viewing 15 posts - 1,381 through 1,395 (of 6,033 total)
The expected answer would be similar to the following, although any equivalent and simple set based solution would suffice.
SELECT CustomerID
, COUNT(*) AS ContactCount
July 3, 2017 at 1:56 pm
The following is not really a database design question, but more of a baseline SQL query question. It's simple enough that a core SQL developer could easily rattle off the...
July 3, 2017 at 1:54 pm
Hell, even today there is no broad consensus on when exactly we should start dancing in the streets to celebrate the arrival of the Age Of Aquarius. Some New Age...
July 3, 2017 at 11:22 am
July 3, 2017 at 11:14 am
So, how to establish a timeline for when data corruption first occurred?
Off the top of my head, the first place I'd look would be error logs, both...
June 29, 2017 at 7:43 am
June 28, 2017 at 8:50 am
June 28, 2017 at 8:23 am
Windowing functions like RANK(), ROWNUMBER(), LAG / LEAD were a giant leap forward. Other more niche functions related to temporal data types and xml / json / regex parsing would...
June 28, 2017 at 7:45 am
Some internet service providers allow other customers to piggy back on your wifi router for use as a hotspot, which makes profiling individuals based on their personal browsing history problematic....
June 27, 2017 at 11:14 am
June 27, 2017 at 10:49 am
Is data classification something that you work with often?
How do you decide the data classes and does this impact your administration of the database?
When it...
June 27, 2017 at 7:58 am
June 26, 2017 at 1:53 pm
To begin with, according to scientists only about 1.2 % of the human genome is for encoding proteins. I'm sure that eventually scientists can identify a much smaller subset of...
June 26, 2017 at 1:35 pm
June 26, 2017 at 10:14 am
June 26, 2017 at 9:06 am
Viewing 15 posts - 1,381 through 1,395 (of 6,033 total)