private static final long[] apportion(final long samples) {
    int cores = CPU_COUNT;
    long[] portions = new long[cores];

    //calculate minimum amount of samples per core
    long minSamples = samples / cores;
    Arrays.setAll(portions, index -> minSamples);

    //calculate remaining samples after evenly dividing the minimum amount over all cores
    long remaining = samples - (minSamples * cores);

    //split the remaining samples over the cores
    int coreId = 0;
    while (remaining > 0) {

//split the remaining samples over the cores
for (int coreId = 0; remaining > 0; coreId++) {
    portions[coreId]++;
    remaining--;
}

int remainder = samples - (minSamples * cores);
Arrays.setAll(portions, index -> minSamples + (index < remainder ? 1 : 0))

double average = IntStream.range(0, 100)
    .mapToDouble(index -> sampleCircleArea(100_000))
    .peek(localAverage -> System.out.printf("Loop %d guesses Pi at %.5f%n", i, localAverage))
    .average()
    .getAsDouble();
System.out.printf("Overall calculation is %.5f%n", average);

  SELECT
    Users.Id
  , Posts.CreationDate
  , Comments.CreationDate
  , PostHistory.CreationDate
  , SuggestedEdits.CreationDate
  , SuggestedEdits.ApprovalDate
  , SuggestedEdits.RejectionDate
  , SuggestedEditVotes.CreationDate
  , Votes.CreationDate
  FROM Users
  INNER JOIN Posts
    ON Users.Id = Posts.OwnerUserId
  INNER JOIN Comments
    ON Users.Id = Comments.UserId
  INNER JOIN PostHistory
    ON Users.Id = PostHistory.UserId
  INNER JOIN SuggestedEdits
    ON Users.Id = SuggestEdits.OwnerUserId

SuggestEdits.OwnerUserId

SuggestedEdits.OwnerUserId

public static void main(String[] args) {
    double[] calculations = new double[100];
    long[] nanos = new long[calculations.length];
    for (int i = 0; i < calculations.length; i++) {
        long start = System.nanoTime();
        double calc = sampleCircleArea(10000000);
        nanos[i] = System.nanoTime() - start;
        calculations[i] = calc;

        System.out.printf("Loop %d guesses Pi at %.5f in %.3fms%n", i, calc, nanos[i] / 1000000.0);
    }
    System.out.printf("Overall calculation is %.5f%n", Arrays.stream(calculations).average().getAsDouble());

Initial:
    Overall performance is best 157.987ms and avg. 173.625ms
ThreadLocal:
    Overall performance is best 158.062ms and avg. 173.861ms
Streamified samplePortion:
    Overall performance is best 163.908ms and avg. 179.236ms

  , Users.DisplayName AS [User Link]
  , Users.CreationDate AS UserCreationDate

WHILE @FirstDay < @LastDay
BEGIN
  IF ( SELECT DATEADD(DAY, 1, @FirstDay) NOT IN #UserActiveDays )
    INSERT INTO #ConsecDaysCount (DaysCount) VALUES (@ConsecDaysCounter);
    BREAK
  ELSE
    SET @ConsecDaysCounter = @ConsecDaysCounter + 1;
    CONTINUE
END

USE AdventureWorks2012;
GO
WHILE (SELECT AVG(ListPrice) FROM Production.Product) < $300
BEGIN
   UPDATE Production.Product
      SET ListPrice = ListPrice * 2
   SELECT MAX(ListPrice) FROM Production.Product
   IF (SELECT MAX(ListPrice) FROM Production.Product) > $500
      BREAK
   ELSE
      CONTINUE
END

Not in (select  somecolumn from #table)

CREATE TABLE #ConsecDaysCount ( DaysCount INT );
DECLARE @ConsecDaysCounter INT;
SET @ConsecDaysCounter = 0;
WHILE @FirstDay < @LastDay BEGIN
IF ( SELECT DATEADD(DAY, 1, @FirstDay) NOT IN (SELECT * FROM #UserActiveDays) )
    INSERT INTO #ConsecDaysCount (DaysCount) VALUES (@ConsecDaysCounter);
    BREAK
  ELSE
    SET @ConsecDaysCounter = @ConsecDaysCounter + 1;
    CONTINUE
END;