JerryNixon

CREATE PARTITION FUNCTION year_partition_function (varchar(4)) AS 
  RANGE FOR VALUES ('2019', '2020', '2021') 
GO

CREATE PARTITION SCHEME year_partition_scheme AS 
  PARTITION year_partition_function ALL TO ([PRIMARY])
GO

CREATE TABLE users
(

JerryNixon

using System.Data;
using System.Data.SqlClient;

internal class Program
{
    static int threads = 0;
    static int records = 0;
    static int batch = 10_000;
    static DateTime started = DateTime.Now;

JerryNixon

SET NOCOUNT ON 

DECLARE @json NVARCHAR(MAX) =
'{ 
  "reading": {
      "source": "A01", 
      "values": [
          { "date": "2022-12-12", "value": 123.456 }
        , { "date": "2022-12-13", "value": 234.567 }
      ]

JerryNixon

using System.Dynamic;
using System.Linq;
using System.Reflection;
using System.Runtime.InteropServices;
using System.Text.Json;
using System.Xml.Linq;

using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Engines;
using BenchmarkDotNet.Running;

JerryNixon

JerryNixon

DROP TABLE IF EXISTS #SSN

CREATE TABLE #SSN (
    ID INT IDENTITY(1, 1) PRIMARY KEY
  , SSN VARCHAR(11) MASKED WITH (FUNCTION = 'partial(0, "XXX-XX-", 4)')
  , SEX BIT
  , BIRTH INT
)

GO

JerryNixon

using Library.Models;
using Library.EF;

namespace Abstractions
{
  public interface IKeyedModel
  {
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }
  }

JerryNixon

DBCC DROPCLEANBUFFERS;
CHECKPOINT;
DBCC FREEPROCCACHE WITH no_infomsgs;
GO

CREATE OR ALTER FUNCTION Range (@start BIGINT, @end BIGINT)
RETURNS @table TABLE (Id BIGINT) AS
BEGIN

  -- Jerry Nixon

JerryNixon

BEGIN TRANSACTION

CREATE TABLE x
(
    Id INT NOT NULL PRIMARY KEY
  , Name VARCHAR(150) NOT NULL
);


WITH generator (Id, Name) AS

JerryNixon

Console.Clear();
Console.CursorVisible = false;

var cat = new Cat();

while (true)
{
    cat.Erase();

    if (Console.KeyAvailable)