Skip to content

Instantly share code, notes, and snippets.

View apeterson-BFI's full-sized avatar

Anthony Peterson apeterson-BFI

1 follower · 1 following
  • Burnette Foods, Inc.
  • Traverse City, MI
View GitHub Profile
@apeterson-BFI
apeterson-BFI / fragresults.txt
Created February 7, 2017 14:48
Fragmentation results
OBJECT_ID index_id index_type_desc index_level avg_fragmentation_in_percent avg_page_space_used_in_percent page_count
1429580131 2 NONCLUSTERED INDEX 0 99.446704637917 48.331504818384 18435
85575343 2 NONCLUSTERED INDEX 0 99.2857142857143 56.5833703978256 140
1429580131 7 NONCLUSTERED INDEX 0 99.2558043828664 60.7504694835681 29159
@apeterson-BFI
apeterson-BFI / query.csv
Created February 7, 2017 15:38
New Query
1429580131 NULL NULL 2 NONCLUSTERED INDEX 0 99.446704637917 48.3434642945392 18435
85575343 NULL NULL 2 NONCLUSTERED INDEX 0 99.2857142857143 56.5833703978256 140
1429580131 NULL NULL 7 NONCLUSTERED INDEX 0 99.2558043828664 60.7563627378305 29159
315148168 NULL NULL 2 NONCLUSTERED INDEX 0 99.235547061634 57.7584754138868 2093
2130106629 NULL NULL 2 NONCLUSTERED INDEX 0 99.2097701149425 58.632876204596 1392
1429580131 NULL NULL 4 NONCLUSTERED INDEX 0 99.1877830594752 57.5127131208302 26717
1438628168 NULL NULL 2 NONCLUSTERED INDEX 0 99.1785965735743 74.5238942426489 4261
898102240 NULL NULL 2 NONCLUSTERED INDEX 0 99.0733876945886 50.9609093155424 2698
1374627940 NULL NULL 4 NONCLUSTERED INDEX 0 99.009900990099 54.0733135656041 101
1374627940 NULL NULL 5 NONCLUSTERED INDEX 0 99.009900990099 54.0733135656041 101
@apeterson-BFI
apeterson-BFI / query2.csv
Created February 7, 2017 15:47
85575343 NULL NULL 2 NONCLUSTERED INDEX 0 99.2857142857143 56.5833703978256 140
1429580131 NULL NULL 7 NONCLUSTERED INDEX 0 99.2558043828664 60.7563627378305 29159
315148168 NULL NULL 2 NONCLUSTERED INDEX 0 99.235547061634 57.7584754138868 2093
2130106629 NULL NULL 2 NONCLUSTERED INDEX 0 99.2097701149425 58.632876204596 1392
1429580131 NULL NULL 4 NONCLUSTERED INDEX 0 99.1877830594752 57.5127131208302 26717
1438628168 NULL NULL 2 NONCLUSTERED INDEX 0 99.1785965735743 74.5238942426489 4261
898102240 NULL NULL 2 NONCLUSTERED INDEX 0 99.0733876945886 50.9609093155424 2698
1374627940 NULL NULL 4 NONCLUSTERED INDEX 0 99.009900990099 54.0733135656041 101
1374627940 NULL NULL 5 NONCLUSTERED INDEX 0 99.009900990099 54.0733135656041 101
@apeterson-BFI
apeterson-BFI / query3.csv
Created February 7, 2017 16:16
Query 3
1429580131 NULL NULL 2 NONCLUSTERED INDEX 0 99.446704637917 NULL 18435
85575343 NULL NULL 2 NONCLUSTERED INDEX 0 99.2857142857143 NULL 140
1429580131 NULL NULL 7 NONCLUSTERED INDEX 0 99.2558043828664 NULL 29159
315148168 NULL NULL 2 NONCLUSTERED INDEX 0 99.235547061634 NULL 2093
2130106629 NULL NULL 2 NONCLUSTERED INDEX 0 99.2097701149425 NULL 1392
1429580131 NULL NULL 4 NONCLUSTERED INDEX 0 99.1877830594752 NULL 26717
1438628168 NULL NULL 2 NONCLUSTERED INDEX 0 99.1785965735743 NULL 4261
898102240 NULL NULL 2 NONCLUSTERED INDEX 0 99.0733876945886 NULL 2698
1374627940 NULL NULL 4 NONCLUSTERED INDEX 0 99.009900990099 NULL 101
1374627940 NULL NULL 5 NONCLUSTERED INDEX 0 99.009900990099 NULL 101
@apeterson-BFI
apeterson-BFI / query3.csv
Created February 7, 2017 16:16
Query 3
85575343 NULL NULL 2 NONCLUSTERED INDEX 0 99.2857142857143 NULL 140
1429580131 NULL NULL 7 NONCLUSTERED INDEX 0 99.2558043828664 NULL 29159
315148168 NULL NULL 2 NONCLUSTERED INDEX 0 99.235547061634 NULL 2093
2130106629 NULL NULL 2 NONCLUSTERED INDEX 0 99.2097701149425 NULL 1392
1429580131 NULL NULL 4 NONCLUSTERED INDEX 0 99.1877830594752 NULL 26717
1438628168 NULL NULL 2 NONCLUSTERED INDEX 0 99.1785965735743 NULL 4261
898102240 NULL NULL 2 NONCLUSTERED INDEX 0 99.0733876945886 NULL 2698
1374627940 NULL NULL 4 NONCLUSTERED INDEX 0 99.009900990099 NULL 101
1374627940 NULL NULL 5 NONCLUSTERED INDEX 0 99.009900990099 NULL 101
@apeterson-BFI
apeterson-BFI / updatereceipt.sql
Last active March 24, 2017 15:00
Update receipt status on Void Check - GMS2
/* update Receipts on Check to O, X, or V */
UPDATE r1
SET [Status] =
CASE
WHEN MaxSeq.MaxSeqNo % 2 = 1 THEN -- ends in a void
CASE r1.SequenceNo
WHEN MaxSeq.MaxSeqNo THEN 'V'
WHEN MaxSeq.MaxSeqNo - 1 THEN 'V'
ELSE 'X'
END
@apeterson-BFI
apeterson-BFI / VoidCheckProcedure.sql
Created March 27, 2017 13:31
VoidCheckProcedure SP errors on Close cursor
ALTER PROCEDURE VoidCheckProcedure
@checkID int
AS
BEGIN
BEGIN TRANSACTION;
BEGIN TRY
/* update status of Orig Check to V */
UPDATE [Check] SET [Status] = 'V' WHERE Check_ID = @checkID;
@apeterson-BFI
apeterson-BFI / Day4.fs
Created December 4, 2018 13:38
Advent of Code day 4
module Day4 =
open Day1
open Day2
open Day3
open System.IO
open System.Text
open System.Text.RegularExpressions
open Utils
open System.Collections.Generic
open System.Linq
@apeterson-BFI
apeterson-BFI / Day5.fs
Created December 5, 2018 13:11
Advent of Code day 5
namespace AdventOfCode
module Day5 =
open System
open System.IO
open System.Text
open System.Text.RegularExpressions
open Utils
open System.Collections.Generic
open System.Linq
@apeterson-BFI
apeterson-BFI / Day6.fs
Created December 6, 2018 13:25
Advent of Code day 6
namespace AdventOfCode
module Day6 =
open System
open System.IO
open System.Text
open System.Text.RegularExpressions
open Utils
open System.Collections.Generic
open System.Linq