This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
OlderNewer