JerryNixon

-- configure recommended DB option
ALTER DATABASE CURRENT SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT=ON;
GO

-- validate tier
IF (DatabasePropertyEx(DB_Name(), 'IsXTPSupported') = 0)
BEGIN
  PRINT 'This database does not support in-mem database.'

JerryNixon

public static class Menu
{
	/// <summary>
	/// Displays a menu of options on the console and waits for the user to make a selection.
	/// </summary>
	/// <param name="x">The x-coordinate of the top-left corner of the menu box.</param>
	/// <param name="y">The y-coordinate of the top-left corner of the menu box.</param>
	/// <param name="items">The options to display in the menu.</param>
	/// <returns>The selected option as a string.</returns>
	public static void Draw(int x, int y, string current, string[] items)

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