Daniel Loth DanielLoth

## 0 - Tally (numbers) table and Calendar table T-SQL
Refer to other files.

## Program.cs
using Nito.AsyncEx;
using System;
using System.Threading.Tasks;

namespace AsyncEx.Context.ConsoleApp
{
    public class Program
    {
        public static int Main(string[] args)
        {

## Experimenting with CHECK constraint impact.txt
Refer to other files.

## DapperBenchmarks.cs
using BenchmarkDotNet.Attributes;
using Dapper;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Dynamic;
using System.Linq;

namespace Benchmarks.Benchmarks

## ServiceNowAttachmentRetrievalTests.cs
using Microsoft.VisualStudio.TestTools.UnitTesting;
using System;
using System.Collections.Generic;
using System.IO;
using System.IO.Compression;
using System.Text;

namespace UnitTests
{
    [TestClass]

## LargeStringToMultiLine.cs
var bigString = "But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? On the other hand, we denounce with

## 3.sql
;with RowPerForeignKeyColumn as (
select
	--fk.name, fk.is_system_named,
	fkChild.ChildTableName, fkChild.ChildColumnName, fkChild.ChildColumnOrdinal,
	fkParent.ParentTableName, fkParent.ParentColumnName, fkParent.ParentColumnOrdinal,
	ConstraintName = fk.name,
	fkChild.ChildSchema,
	fkParent.ParentSchema --,
	--fkParent.*, fkChild.*
from sys.foreign_keys fk

## Reading List.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                DanielLoth
                / Reading List.md
            
            
              Last active
              January 2, 2018 02:51
            
              
                Reading List
              
          
    In Progress

https://growthlab.com/how-i-made-one-million-luisa-zhou/
https://stackoverflow.com/questions/16945780/decoding-base64-in-batch
Stored procedures (including metadata): https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine
Unread

http://gigi.nullneuron.net/gigilabs/patterns-for-asynchronous-composite-tasks-in-c/

  
## SQL Server - Object dependency queries.sql
IF OBJECT_ID('tempdb.dbo.#tempdep', 'U') IS NOT NULL
  DROP TABLE #tempdep;

CREATE TABLE #tempdep (objid int NOT NULL, objname sysname NOT NULL, objschema sysname NULL, objdb sysname NOT NULL, objtype smallint NOT NULL)


exec sp_executesql N'
INSERT INTO #tempdep
SELECT
tbl.object_id AS [ID],

## All the kings horses and all the kings men.txt
-----BEGIN CERTIFICATE-----
N3q8ryccAARv0zvW0fUAAAAAAAAkAAAAAAAAAJ7EOroM7Zc0a6+nStey+OM7CfYN
jOFPik6bvYw80OCK9XtdvCpjNhqVOcmqH8nm3wSpBid2RCt/kOxnevEbrGAxe4oA
JOFnI+T2J25XphO9QATnd62Sassxl1ci57iiYMpVW3ef3/pFXUpFAqanMl65w6Ie
GKVyZZVr+Rk3esLMNfOKFo73yqUxflnGUfrI/fXRK0WbULgOGWTlIoIZ/4ahEbgP
cNmJNeRq+cXq43O6LXrOZsli2rQymuvO6nBS5uqgE/nFV3aiWMhZIiZUo64rDL2a
l1WYIHKAgI/02hDCOKyBhNIEHq2aRrtxBla/rOtYvmOxttVD1l4ZPYyowcg2AShc
kafOkU4dd5TTucc9dZpHqIRxCwvvhZ3kvmThakEn0LADSDr3B19Hnil2jsYtfkQ3
fq/ldPQJD/DxjGmolifwBlx3Wh5OVDq7u72bMmHOtHjchrc0AFo+0tDeXGH1q9rk
Amqe9bwRjf1fuptEzYqK6lTmEQCiEn+ao/XCqkgaIAvWhG5FFIElWb/tlve9azqN
	using Nito.AsyncEx;
	using System;
	using System.Threading.Tasks;

	namespace AsyncEx.Context.ConsoleApp
	{
	public class Program
	{
	public static int Main(string[] args)
	{
	using BenchmarkDotNet.Attributes;
	using Dapper;
	using System;
	using System.Collections.Generic;
	using System.Configuration;
	using System.Data.SqlClient;
	using System.Dynamic;
	using System.Linq;

	namespace Benchmarks.Benchmarks
	using Microsoft.VisualStudio.TestTools.UnitTesting;
	using System;
	using System.Collections.Generic;
	using System.IO;
	using System.IO.Compression;
	using System.Text;

	namespace UnitTests
	{
	[TestClass]
	;with RowPerForeignKeyColumn as (
	select
	--fk.name, fk.is_system_named,
	fkChild.ChildTableName, fkChild.ChildColumnName, fkChild.ChildColumnOrdinal,
	fkParent.ParentTableName, fkParent.ParentColumnName, fkParent.ParentColumnOrdinal,
	ConstraintName = fk.name,
	fkChild.ChildSchema,
	fkParent.ParentSchema --,
	--fkParent., fkChild.
	from sys.foreign_keys fk
	IF OBJECT_ID('tempdb.dbo.#tempdep', 'U') IS NOT NULL
	DROP TABLE #tempdep;

	CREATE TABLE #tempdep (objid int NOT NULL, objname sysname NOT NULL, objschema sysname NULL, objdb sysname NOT NULL, objtype smallint NOT NULL)


	exec sp_executesql N'
	INSERT INTO #tempdep
	SELECT
	tbl.object_id AS [ID],
	-----BEGIN CERTIFICATE-----
	N3q8ryccAARv0zvW0fUAAAAAAAAkAAAAAAAAAJ7EOroM7Zc0a6+nStey+OM7CfYN
	jOFPik6bvYw80OCK9XtdvCpjNhqVOcmqH8nm3wSpBid2RCt/kOxnevEbrGAxe4oA
	JOFnI+T2J25XphO9QATnd62Sassxl1ci57iiYMpVW3ef3/pFXUpFAqanMl65w6Ie
	GKVyZZVr+Rk3esLMNfOKFo73yqUxflnGUfrI/fXRK0WbULgOGWTlIoIZ/4ahEbgP
	cNmJNeRq+cXq43O6LXrOZsli2rQymuvO6nBS5uqgE/nFV3aiWMhZIiZUo64rDL2a
	l1WYIHKAgI/02hDCOKyBhNIEHq2aRrtxBla/rOtYvmOxttVD1l4ZPYyowcg2AShc
	kafOkU4dd5TTucc9dZpHqIRxCwvvhZ3kvmThakEn0LADSDr3B19Hnil2jsYtfkQ3
	fq/ldPQJD/DxjGmolifwBlx3Wh5OVDq7u72bMmHOtHjchrc0AFo+0tDeXGH1q9rk
	Amqe9bwRjf1fuptEzYqK6lTmEQCiEn+ao/XCqkgaIAvWhG5FFIElWb/tlve9azqN