2023-07-14 21:18:29,539 | INFO | 171: Unzipping file: input/sample_files.zip 2023-07-14 21:18:29,889 | INFO | 179: Extracted file to: outputs/sample_files 2023-07-14 21:18:29,889 | INFO | 191: File outputs/sample_files/pig 2023-07-14 21:18:29,889 | INFO | 212: Nested folder outputs/sample_files/pig 2023-07-14 21:18:29,889 | INFO | 191: File outputs/sample_files/pig/limit.pig 2023-07-14 21:18:29,889 | INFO | 191: File outputs/sample_files/pig/order-by.pig 2023-07-14 21:18:29,889 | INFO | 191: File outputs/sample_files/pig/multi-delimiter.pig 2023-07-14 21:18:29,890 | INFO | 191: File outputs/sample_files/pig/distinct.pig 2023-07-14 21:18:29,890 | INFO | 191: File outputs/sample_files/pig/lookup.pig 2023-07-14 21:18:29,890 | INFO | 191: File outputs/sample_files/pig/join.pig 2023-07-14 21:18:29,890 | INFO | 191: File outputs/sample_files/pig/from-vim.pig 2023-07-14 21:18:29,890 | INFO | 191: File outputs/sample_files/pig/strip-quote.pig 2023-07-14 21:18:29,890 | INFO | 191: File outputs/sample_files/pig/count-words.pig 2023-07-14 21:18:29,890 | INFO | 191: File outputs/sample_files/pig/filter-by.pig 2023-07-14 21:18:29,891 | INFO | 191: File outputs/sample_files/pig/count.pig 2023-07-14 21:18:29,891 | INFO | 191: File outputs/sample_files/pig/stream-shell-script.pig 2023-07-14 21:18:29,891 | INFO | 191: File outputs/sample_files/pig/get-twitter-names.pig 2023-07-14 21:18:29,891 | INFO | 191: File outputs/sample_files/pig/stream-python.pig 2023-07-14 21:18:29,891 | INFO | 191: File outputs/sample_files/pig/load-store.pig 2023-07-14 21:18:29,891 | INFO | 191: File outputs/sample_files/pig/group-by.pig 2023-07-14 21:18:29,892 | INFO | 191: File outputs/sample_files/pig/data-bag.pig 2023-07-14 21:18:29,892 | INFO | 191: File outputs/sample_files/py 2023-07-14 21:18:29,892 | INFO | 212: Nested folder outputs/sample_files/py 2023-07-14 21:18:29,892 | INFO | 191: File outputs/sample_files/py/pyspark-create-dataframe.py 2023-07-14 21:18:29,892 | INFO | 191: File outputs/sample_files/py/pyspark-select-columns.py 2023-07-14 21:18:29,892 | INFO | 191: File outputs/sample_files/py/pyspark-drop-column.py 2023-07-14 21:18:29,893 | INFO | 191: File outputs/sample_files/py/pyspark-broadcast-dataframe.py 2023-07-14 21:18:29,893 | INFO | 191: File outputs/sample_files/py/pyspark-update-column.py 2023-07-14 21:18:29,893 | INFO | 191: File outputs/sample_files/py/pyspark-rename-column.py 2023-07-14 21:18:29,893 | INFO | 191: File outputs/sample_files/py/pyspark-timestamp-date.py 2023-07-14 21:18:29,893 | INFO | 191: File outputs/sample_files/py/pyspark-unix-time.py 2023-07-14 21:18:29,894 | INFO | 191: File outputs/sample_files/py/pyspark-rdd-wordcount-2.py 2023-07-14 21:18:29,894 | INFO | 191: File outputs/sample_files/py/pyspark-read-json.py 2023-07-14 21:18:29,894 | INFO | 191: File outputs/sample_files/py/pyspark-join.py 2023-07-14 21:18:29,894 | INFO | 191: File outputs/sample_files/py/pyspark-window-functions.py 2023-07-14 21:18:29,894 | INFO | 191: File outputs/sample_files/py/pyspark-repartition-2.py 2023-07-14 21:18:29,895 | INFO | 191: File outputs/sample_files/py/python-pandas.py 2023-07-14 21:18:29,895 | INFO | 191: File outputs/sample_files/py/pyspark-sql-case-when.py 2023-07-14 21:18:29,895 | INFO | 191: File outputs/sample_files/py/pyspark-split-function.py 2023-07-14 21:18:29,895 | INFO | 191: File outputs/sample_files/py/pyspark-date-string.py 2023-07-14 21:18:29,895 | INFO | 191: File outputs/sample_files/py/pyspark-when-otherwise.py 2023-07-14 21:18:29,896 | INFO | 191: File outputs/sample_files/py/pyspark-lit.py 2023-07-14 21:18:29,896 | INFO | 191: File outputs/sample_files/py/pyspark-parallelize.py 2023-07-14 21:18:29,896 | INFO | 191: File outputs/sample_files/py/pyspark-string-date.py 2023-07-14 21:18:29,896 | INFO | 191: File outputs/sample_files/py/pyspark-change-string-double.py 2023-07-14 21:18:29,896 | INFO | 191: File outputs/sample_files/py/pyspark-rdd-broadcast.py 2023-07-14 21:18:29,897 | INFO | 191: File outputs/sample_files/py/pyspark-string-timestamp.py 2023-07-14 21:18:29,897 | INFO | 191: File outputs/sample_files/py/pyspark-count-distinct.py 2023-07-14 21:18:29,897 | INFO | 191: File outputs/sample_files/py/pyspark-rdd.py 2023-07-14 21:18:29,897 | INFO | 191: File outputs/sample_files/py/pyspark-dataframe-repartition.py 2023-07-14 21:18:29,897 | INFO | 191: File outputs/sample_files/py/pyspark-maptype-dataframe-column.py 2023-07-14 21:18:29,897 | INFO | 191: File outputs/sample_files/py/pyspark-python-dataframe.py 2023-07-14 21:18:29,897 | INFO | 191: File outputs/sample_files/py/pyspark-rdd-map.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/pyspark-types.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/pyspark-current-date-timestamp.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/pyspark-read-csv.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/pyspark-rdd-to-dataframe.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/spark-repartition-2.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/pyspark-shape-dataframe.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/pyspark-collect.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/pyspark-empty-data-frame.py 2023-07-14 21:18:29,898 | INFO | 191: File outputs/sample_files/py/pyspark-date-timestamp-functions.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-withcolumn.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-struct-to-map.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-create-dataframe-dictionary.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-rdd-actions.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-sampling.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-sparksession.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-dataframe-flatMap.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-convert-map-to-columns.py 2023-07-14 21:18:29,899 | INFO | 191: File outputs/sample_files/py/pyspark-mappartitions.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-udf.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-dataframe.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-rdd-reduceByKey.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-time-diff.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-left-anti-join.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-explode-array-map.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-add-new-column.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-orderby.py 2023-07-14 21:18:29,900 | INFO | 191: File outputs/sample_files/py/pyspark-groupby-sort.py 2023-07-14 21:18:29,901 | INFO | 191: File outputs/sample_files/py/pyspark-string-to-array.py 2023-07-14 21:18:29,901 | INFO | 191: File outputs/sample_files/py/currentdate.py 2023-07-14 21:18:29,901 | INFO | 191: File outputs/sample_files/py/pyspark-expr.py 2023-07-14 21:18:29,901 | INFO | 191: File outputs/sample_files/py/pyspark-filter.py 2023-07-14 21:18:29,901 | INFO | 191: File outputs/sample_files/py/pyspark-column-functions.py 2023-07-14 21:18:29,901 | INFO | 191: File outputs/sample_files/py/pyspark-row.py 2023-07-14 21:18:29,901 | INFO | 191: File outputs/sample_files/py/pyspark-array-string.py 2023-07-14 21:18:29,901 | INFO | 191: File outputs/sample_files/py/pyspark-explode-nested-array.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/pyspark-rdd-wordcount.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/pyspark-fulter-null.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/pyspark-groupby.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/pyspark-column-operations.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/pyspark-convert_columns-to-map.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/pyspark-datediff.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/pyspark-pivot.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/pyspark-cast-column.py 2023-07-14 21:18:29,902 | INFO | 191: File outputs/sample_files/py/timediff.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pyspark-show-top-n-rows.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pyspark-distinct.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pyspark-repartition.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pandas-pyspark-dataframe.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pyspark-create-list.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pyspark-rdd-flatMap.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pyspark-union.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pyspark-orderby-groupby.py 2023-07-14 21:18:29,903 | INFO | 191: File outputs/sample_files/py/pyspark-join-two-dataframes.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-aggregate.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-filter-null.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-print-contents.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-loop.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-drop-null.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-range-partition.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-filter2.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-add-month.py 2023-07-14 21:18:29,904 | INFO | 191: File outputs/sample_files/py/pyspark-arraytype.py 2023-07-14 21:18:29,905 | INFO | 191: File outputs/sample_files/py/pyspark-repace-null.py 2023-07-14 21:18:29,905 | INFO | 191: File outputs/sample_files/py/pyspark-partitionby.py 2023-07-14 21:18:29,905 | INFO | 191: File outputs/sample_files/py/schema.py 2023-07-14 21:18:29,905 | INFO | 191: File outputs/sample_files/py/pyspark-structtype.py 2023-07-14 21:18:29,905 | INFO | 191: File outputs/sample_files/py/convert-column-python-list.py 2023-07-14 21:18:29,905 | INFO | 191: File outputs/sample_files/.DS_Store 2023-07-14 21:18:29,905 | INFO | 191: File outputs/sample_files/txt 2023-07-14 21:18:29,905 | INFO | 212: Nested folder outputs/sample_files/txt 2023-07-14 21:18:29,905 | INFO | 191: File outputs/sample_files/txt/glen_berry_diagnostic_queries_links.txt 2023-07-14 21:18:29,906 | INFO | 191: File outputs/sample_files/shell 2023-07-14 21:18:29,906 | INFO | 212: Nested folder outputs/sample_files/shell 2023-07-14 21:18:29,906 | INFO | 191: File outputs/sample_files/pyspark 2023-07-14 21:18:29,906 | INFO | 212: Nested folder outputs/sample_files/pyspark 2023-07-14 21:18:29,906 | INFO | 191: File outputs/sample_files/R 2023-07-14 21:18:29,906 | INFO | 212: Nested folder outputs/sample_files/R 2023-07-14 21:18:29,906 | INFO | 191: File outputs/sample_files/R/mssql2csv.R 2023-07-14 21:18:29,906 | INFO | 191: File outputs/sample_files/R/Benchmark_TSQL.R 2023-07-14 21:18:29,906 | INFO | 191: File outputs/sample_files/xml 2023-07-14 21:18:29,906 | INFO | 212: Nested folder outputs/sample_files/xml 2023-07-14 21:18:29,906 | INFO | 191: File outputs/sample_files/xml/ShredDeadlockGraph_Sample2.xml 2023-07-14 21:18:29,906 | INFO | 191: File outputs/sample_files/xml/ShredDeadlockGraph_Sample1.xml 2023-07-14 21:18:29,907 | INFO | 191: File outputs/sample_files/sh 2023-07-14 21:18:29,907 | INFO | 212: Nested folder outputs/sample_files/sh 2023-07-14 21:18:29,907 | INFO | 191: File outputs/sample_files/sh/sample_call.sh 2023-07-14 21:18:29,907 | INFO | 191: File outputs/sample_files/sh/test_twitter.sh 2023-07-14 21:18:29,907 | INFO | 191: File outputs/sample_files/sh/file_config.sh 2023-07-14 21:18:29,907 | INFO | 191: File outputs/sample_files/sh/final_call.sh 2023-07-14 21:18:29,907 | INFO | 191: File outputs/sample_files/sh/api_call.sh 2023-07-14 21:18:29,907 | INFO | 191: File outputs/sample_files/hive 2023-07-14 21:18:29,907 | INFO | 212: Nested folder outputs/sample_files/hive 2023-07-14 21:18:29,907 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_pricing_exception_type_transformation.sql 2023-07-14 21:18:29,908 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_dental_area_transformation.sql 2023-07-14 21:18:29,908 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_rate_transformation.sql 2023-07-14 21:18:29,908 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_drg_x_group_transformation.sql 2023-07-14 21:18:29,908 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_provider_rate_transformation.sql 2023-07-14 21:18:29,909 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_age_range_x_group_transformation.sql 2023-07-14 21:18:29,909 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_member_rate_transformation.sql 2023-07-14 21:18:29,909 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_provider_rate_attachment_transformation.sql 2023-07-14 21:18:29,909 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_relative_value_unit_detail_transformation.sql 2023-07-14 21:18:29,910 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_prcdr_usg_x_prcng_excptn_transformation.sql 2023-07-14 21:18:29,910 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_modifier_indicator_transformation.sql 2023-07-14 21:18:29,910 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_drg_mbr_age_vald_transformation.sql 2023-07-14 21:18:29,910 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_member_rate_attachment_transformation.sql 2023-07-14 21:18:29,910 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_age_range_transformation.sql 2023-07-14 21:18:29,911 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_prcdr_clinic_visit_transformation.sql 2023-07-14 21:18:29,911 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_facility_type_status_transformation.sql 2023-07-14 21:18:29,911 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_prvdr_drg_rate_factor_transformation.sql 2023-07-14 21:18:29,911 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_ref_operator_transformation.sql 2023-07-14 21:18:29,912 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_prcdr_x_mdfr_indicator_transformation.sql 2023-07-14 21:18:29,912 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_modifier_x_group_transformation.sql 2023-07-14 21:18:29,912 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_bill_classification_span_transformation.sql 2023-07-14 21:18:29,912 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_program_x_rac_priority_transformation.sql 2023-07-14 21:18:29,913 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_pricing_exception_base_transformation.sql 2023-07-14 21:18:29,913 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_sp_ssp_x_grp_transformation.sql 2023-07-14 21:18:29,913 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_diag_prcdr_crosscoder_transformation.sql 2023-07-14 21:18:29,914 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_groups_x_lookup_domain_transformation.sql 2023-07-14 21:18:29,914 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_other_detail_transformation.sql 2023-07-14 21:18:29,914 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_indicator_transformation.sql 2023-07-14 21:18:29,914 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_diagnosis_indicator_transformation.sql 2023-07-14 21:18:29,915 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_program_x_rac_transformation.sql 2023-07-14 21:18:29,915 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_code_range_x_group_transformation.sql 2023-07-14 21:18:29,915 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_facility_type_x_group_transformation.sql 2023-07-14 21:18:29,915 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_reference_inactivation_status_transformation.sql 2023-07-14 21:18:29,916 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_treatment_type_transformation.sql 2023-07-14 21:18:29,916 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_bill_type_x_group_transformation.sql 2023-07-14 21:18:29,916 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_taxonomy_rate_attachment_transformation.sql 2023-07-14 21:18:29,916 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_x_fund_detail_transformation.sql 2023-07-14 21:18:29,917 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_diag_age_range_transformation.sql 2023-07-14 21:18:29,917 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_tenant_transformation.sql 2023-07-14 21:18:29,917 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_functional_area_transformation.sql 2023-07-14 21:18:29,917 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_ansthsa_cost_factor_transformation.sql 2023-07-14 21:18:29,918 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_prcdr_age_range_transformation.sql 2023-07-14 21:18:29,918 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_treatment_type_indicator_transformation.sql 2023-07-14 21:18:29,918 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_groups_transformation.sql 2023-07-14 21:18:29,919 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_geo_unit_x_group_transformation.sql 2023-07-14 21:18:29,919 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_submit_facilty_transformation.sql 2023-07-14 21:18:29,919 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_diagnosis_status_transformation.sql 2023-07-14 21:18:29,919 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_holiday_master_transformation.sql 2023-07-14 21:18:29,919 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_diagnosis_detail_transformation.sql 2023-07-14 21:18:29,920 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_modifier_transformation.sql 2023-07-14 21:18:29,920 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_period_type_transformation.sql 2023-07-14 21:18:29,920 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_reference_association_status_transformation.sql 2023-07-14 21:18:29,921 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_drg_rate_factor_transformation.sql 2023-07-14 21:18:29,921 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_store_transformation.sql 2023-07-14 21:18:29,921 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_dental_area_x_dental_area_transformation.sql 2023-07-14 21:18:29,921 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_holiday_exclusion_transformation.sql 2023-07-14 21:18:29,922 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_correct_code_initiative_transformation.sql 2023-07-14 21:18:29,922 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_revenue_x_clm_type_transformation.sql 2023-07-14 21:18:29,922 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_indicator_option_x_specialty_transformation.sql 2023-07-14 21:18:29,922 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_length_of_stay_transformation.sql 2023-07-14 21:18:29,923 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_submit_facilty_span_transformation.sql 2023-07-14 21:18:29,923 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_unit_of_measurement_transformation.sql 2023-07-14 21:18:29,923 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_region_transformation.sql 2023-07-14 21:18:29,924 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_status_transformation.sql 2023-07-14 21:18:29,924 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_program_x_modifier_transformation.sql 2023-07-14 21:18:29,924 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_treatment_type_detail_transformation.sql 2023-07-14 21:18:29,924 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_roster_detail_transformation.sql 2023-07-14 21:18:29,925 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_diagnosis_x_group_transformation.sql 2023-07-14 21:18:29,925 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_ctgry_x_group_store_transformation.sql 2023-07-14 21:18:29,925 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_category_transformation.sql 2023-07-14 21:18:29,925 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_program_x_group_transformation.sql 2023-07-14 21:18:29,925 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_taxonomy_rate_transformation.sql 2023-07-14 21:18:29,926 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_clsfctn_desc_transformation.sql 2023-07-14 21:18:29,926 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_x_group_store_transformation.sql 2023-07-14 21:18:29,926 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_modifier_crosswalk_transformation.sql 2023-07-14 21:18:29,927 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_diag_related_group_transformation.sql 2023-07-14 21:18:29,927 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_drg_rate_transformation.sql 2023-07-14 21:18:29,928 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_relative_value_unit_transformation.sql 2023-07-14 21:18:29,928 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_diagnosis_transformation.sql 2023-07-14 21:18:29,928 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_reference_additive_transformation.sql 2023-07-14 21:18:29,929 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_durable_medical_equipment_transformation.sql 2023-07-14 21:18:29,929 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_modifier_detail_transformation.sql 2023-07-14 21:18:29,929 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_facility_prvdr_rate_transformation.sql 2023-07-14 21:18:29,930 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_specialty_x_group_transformation.sql 2023-07-14 21:18:29,930 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_sbmt_fclty_bill_clsfctn_transformation.sql 2023-07-14 21:18:29,931 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_facility_type_transformation.sql 2023-07-14 21:18:29,931 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_dental_area_type_association_transformation.sql 2023-07-14 21:18:29,931 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_drg_indicator_transformation.sql 2023-07-14 21:18:29,932 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_group_rate_attachment_transformation.sql 2023-07-14 21:18:29,932 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_drg_pricing_exception_transformation.sql 2023-07-14 21:18:29,932 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_drg_detail_transformation.sql 2023-07-14 21:18:29,933 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_modifier_status_transformation.sql 2023-07-14 21:18:29,933 | INFO | 191: File outputs/sample_files/hive/udprdsftcore.udp_d_bill_classification_transformation.sql 2023-07-14 21:18:29,934 | INFO | 191: File outputs/sample_files/sql 2023-07-14 21:18:29,934 | INFO | 212: Nested folder outputs/sample_files/sql 2023-07-14 21:18:29,934 | INFO | 191: File outputs/sample_files/sql/Database_Mail_Problems.sql 2023-07-14 21:18:29,935 | INFO | 191: File outputs/sample_files/sql/AutoGuessingForeignKeyConstraints.sql 2023-07-14 21:18:29,935 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_pricing_exception_type_transformation.sql 2023-07-14 21:18:29,935 | INFO | 191: File outputs/sample_files/sql/SpaceusedByTable.sql 2023-07-14 21:18:29,935 | INFO | 191: File outputs/sample_files/sql/dbo.usp_RandomWait.sql 2023-07-14 21:18:29,935 | INFO | 191: File outputs/sample_files/sql/CheckSpectreMeltdownStatus.sql 2023-07-14 21:18:29,935 | INFO | 191: File outputs/sample_files/sql/Trace_Flag_8602.sql 2023-07-14 21:18:29,935 | INFO | 191: File outputs/sample_files/sql/dbo.sp_Snapshot.sql 2023-07-14 21:18:29,936 | INFO | 191: File outputs/sample_files/sql/Wait_Statistics.sql 2023-07-14 21:18:29,936 | INFO | 191: File outputs/sample_files/sql/Line_Of_Codes_In_database.sql 2023-07-14 21:18:29,936 | INFO | 191: File outputs/sample_files/sql/Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql 2023-07-14 21:18:29,936 | INFO | 191: File outputs/sample_files/sql/Windows logins not in AD.sql 2023-07-14 21:18:29,936 | INFO | 191: File outputs/sample_files/sql/SQL Server 2008 Diagnostic Information Queries.sql 2023-07-14 21:18:29,936 | INFO | 191: File outputs/sample_files/sql/dbo.usp_TopologicalSort.sql 2023-07-14 21:18:29,937 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_dental_area_transformation.sql 2023-07-14 21:18:29,937 | INFO | 191: File outputs/sample_files/sql/Indexes_Script_Out.sql 2023-07-14 21:18:29,937 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_rate_transformation.sql 2023-07-14 21:18:29,937 | INFO | 191: File outputs/sample_files/sql/Pattern_Match.sql 2023-07-14 21:18:29,937 | INFO | 191: File outputs/sample_files/sql/dbo.usp_SSIS_ScriptEnvironment.sql 2023-07-14 21:18:29,937 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_drg_x_group_transformation.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_provider_rate_transformation.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_age_range_x_group_transformation.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/CPU_Utilization.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/VLF_Info.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/Get_Database_Size_With_Graph.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/dbo.usp_bcpTableUnloadBatchMode.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/dbo.sp_helpme.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/How_old_your_backups.sql 2023-07-14 21:18:29,938 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_member_rate_transformation.sql 2023-07-14 21:18:29,939 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_provider_rate_attachment_transformation.sql 2023-07-14 21:18:29,939 | INFO | 191: File outputs/sample_files/sql/Delete_Login_And_All_Users.sql 2023-07-14 21:18:29,939 | INFO | 191: File outputs/sample_files/sql/Jobs_Detailed_History.sql 2023-07-14 21:18:29,939 | INFO | 191: File outputs/sample_files/sql/MAXDOP_recommendation.sql 2023-07-14 21:18:29,939 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_relative_value_unit_detail_transformation.sql 2023-07-14 21:18:29,939 | INFO | 191: File outputs/sample_files/sql/dbo.usp_SQL_Server_System_Report.sql 2023-07-14 21:18:29,939 | INFO | 191: File outputs/sample_files/sql/dbo.usp_SearchOnAllDB.sql 2023-07-14 21:18:29,940 | INFO | 191: File outputs/sample_files/sql/dbo.usp_SetFileGrowth.sql 2023-07-14 21:18:29,940 | INFO | 191: File outputs/sample_files/sql/RenameDefaultConstraints.sql 2023-07-14 21:18:29,940 | INFO | 191: File outputs/sample_files/sql/Simulate_Permissions_Logins_Change.sql 2023-07-14 21:18:29,940 | INFO | 191: File outputs/sample_files/sql/Checking_Your_Backup_Paths_Exist_and_Automatically_Create_it.sql 2023-07-14 21:18:29,940 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_prcdr_usg_x_prcng_excptn_transformation.sql 2023-07-14 21:18:29,940 | INFO | 191: File outputs/sample_files/sql/dbo.usp_checkAllDatabases.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/Save_Error_Log_To_Table.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_modifier_indicator_transformation.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_drg_mbr_age_vald_transformation.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/dbo.sp_DBA_job_notification.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/Data_Dictionary_Information.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/Memory_Consumption_By_Object.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_member_rate_attachment_transformation.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_age_range_transformation.sql 2023-07-14 21:18:29,941 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_prcdr_clinic_visit_transformation.sql 2023-07-14 21:18:29,942 | INFO | 191: File outputs/sample_files/sql/Which_Indexes_are_not_Used.sql 2023-07-14 21:18:29,942 | INFO | 191: File outputs/sample_files/sql/Overview_HADR_AlwaysOn_Local_Replica_Server.sql 2023-07-14 21:18:29,942 | INFO | 191: File outputs/sample_files/sql/SplitFileGroup.sql 2023-07-14 21:18:29,942 | INFO | 191: File outputs/sample_files/sql/Server_Parameters.sql 2023-07-14 21:18:29,942 | INFO | 191: File outputs/sample_files/sql/Finding_Host_Names_for_Failed_login_attempts.sql 2023-07-14 21:18:29,942 | INFO | 191: File outputs/sample_files/sql/Suspect_Database_Pages.sql 2023-07-14 21:18:29,942 | INFO | 191: File outputs/sample_files/sql/dbo.usp_TableUnpivot.sql 2023-07-14 21:18:29,943 | INFO | 191: File outputs/sample_files/sql/Find_Synonyms_for_nested_objects_in_the_different_databases.sql 2023-07-14 21:18:29,943 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_facility_type_status_transformation.sql 2023-07-14 21:18:29,943 | INFO | 191: File outputs/sample_files/sql/Date_Format_Cheat_Sheet.sql 2023-07-14 21:18:29,943 | INFO | 191: File outputs/sample_files/sql/Get_Table_Hierarchy.sql 2023-07-14 21:18:29,943 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_prvdr_drg_rate_factor_transformation.sql 2023-07-14 21:18:29,943 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_ref_operator_transformation.sql 2023-07-14 21:18:29,943 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_prcdr_x_mdfr_indicator_transformation.sql 2023-07-14 21:18:29,943 | INFO | 191: File outputs/sample_files/sql/Current_Running_Tasks_and_Server_Info.sql 2023-07-14 21:18:29,944 | INFO | 191: File outputs/sample_files/sql/SQL_Server_Defaults.sql 2023-07-14 21:18:29,944 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_modifier_x_group_transformation.sql 2023-07-14 21:18:29,944 | INFO | 191: File outputs/sample_files/sql/Backup_Restore_WhatΓÇÖs_My_Status.sql 2023-07-14 21:18:29,944 | INFO | 191: File outputs/sample_files/sql/dbo.usp_Object_Search.sql 2023-07-14 21:18:29,944 | INFO | 191: File outputs/sample_files/sql/Get_CPU_Usage_Per_Database.sql 2023-07-14 21:18:29,944 | INFO | 191: File outputs/sample_files/sql/How_much_will_it_cost_or_save_to_rebuild_that_index.sql 2023-07-14 21:18:29,944 | INFO | 191: File outputs/sample_files/sql/dbo.usp_Kruskal.sql 2023-07-14 21:18:29,944 | INFO | 191: File outputs/sample_files/sql/SQL_Azure_Approximate_Datetime_Restart.sql 2023-07-14 21:18:29,945 | INFO | 191: File outputs/sample_files/sql/dbo.sp_Defrag_Indexes.sql 2023-07-14 21:18:29,945 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_bill_classification_span_transformation.sql 2023-07-14 21:18:29,945 | INFO | 191: File outputs/sample_files/sql/CPU_Utilization_Graphical_form.sql 2023-07-14 21:18:29,945 | INFO | 191: File outputs/sample_files/sql/dbo.usp_FindDbObjects.sql 2023-07-14 21:18:29,945 | INFO | 191: File outputs/sample_files/sql/Generate_BIML_Script.sql 2023-07-14 21:18:29,945 | INFO | 191: File outputs/sample_files/sql/Trace_Flag_460.sql 2023-07-14 21:18:29,945 | INFO | 191: File outputs/sample_files/sql/dbo.sp_IndexAnalysis-v11.sql 2023-07-14 21:18:29,946 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_program_x_rac_priority_transformation.sql 2023-07-14 21:18:29,946 | INFO | 191: File outputs/sample_files/sql/Compress_Tables_And_Indexes.sql 2023-07-14 21:18:29,946 | INFO | 191: File outputs/sample_files/sql/dbo.sqlg_ParseDiskskpXml.sql 2023-07-14 21:18:29,946 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_pricing_exception_base_transformation.sql 2023-07-14 21:18:29,946 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_sp_ssp_x_grp_transformation.sql 2023-07-14 21:18:29,946 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_diag_prcdr_crosscoder_transformation.sql 2023-07-14 21:18:29,946 | INFO | 191: File outputs/sample_files/sql/SQL Server 2017 Diagnostic Information Queries.sql 2023-07-14 21:18:29,946 | INFO | 191: File outputs/sample_files/sql/dbo.usp_LogError.sql 2023-07-14 21:18:29,947 | INFO | 191: File outputs/sample_files/sql/Find_and_fix_that_troublesome_Windows_Power_setting.sql 2023-07-14 21:18:29,947 | INFO | 191: File outputs/sample_files/sql/Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql 2023-07-14 21:18:29,947 | INFO | 191: File outputs/sample_files/sql/Query_Store_Export.sql 2023-07-14 21:18:29,947 | INFO | 191: File outputs/sample_files/sql/Find_Weak_Passwords.sql 2023-07-14 21:18:29,947 | INFO | 191: File outputs/sample_files/sql/Finding_Blocking_Queries.sql 2023-07-14 21:18:29,947 | INFO | 191: File outputs/sample_files/sql/dbo.sp_sizeoptimiser.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/LatchStats.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/Get_latches_Objects.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/dbo.usp_bcpTableUnload.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/Fix_The_Broken_Dependencies_On_All_Objects.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/dbo.usp_LoadTableBlobs.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/New_Default_Database_Assignment_For_Any_Login_Missing_Their_Default_Database.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_groups_x_lookup_domain_transformation.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/GenerateTSQLTimeSlices.sql 2023-07-14 21:18:29,948 | INFO | 191: File outputs/sample_files/sql/SQL Server 2005 Diagnostic Information Queries.sql 2023-07-14 21:18:29,949 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_other_detail_transformation.sql 2023-07-14 21:18:29,949 | INFO | 191: File outputs/sample_files/sql/Failed_SQL_Server_Agent_Jobs_With_Restart_Command.sql 2023-07-14 21:18:29,949 | INFO | 191: File outputs/sample_files/sql/Read_Default_Trace.sql 2023-07-14 21:18:29,949 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_indicator_transformation.sql 2023-07-14 21:18:29,949 | INFO | 191: File outputs/sample_files/sql/dbo.sp_generate_merge.sql 2023-07-14 21:18:29,949 | INFO | 191: File outputs/sample_files/sql/Adding_Trace_Flags_To_Startup_Parameters.sql 2023-07-14 21:18:29,949 | INFO | 191: File outputs/sample_files/sql/IN_Memory_Example_2014.sql 2023-07-14 21:18:29,950 | INFO | 191: File outputs/sample_files/sql/dbo.sp_DropIndexes.sql 2023-07-14 21:18:29,950 | INFO | 191: File outputs/sample_files/sql/dbo.PerformanceGraph.sql 2023-07-14 21:18:29,950 | INFO | 191: File outputs/sample_files/sql/PIVOT_Columns_generator.sql 2023-07-14 21:18:29,950 | INFO | 191: File outputs/sample_files/sql/Find_Non_Sargable_Queries.sql 2023-07-14 21:18:29,950 | INFO | 191: File outputs/sample_files/sql/UnPivot_Output_Restore_Headeronly.sql 2023-07-14 21:18:29,950 | INFO | 191: File outputs/sample_files/sql/dbo.usp_GetUntrustedForeignKeys.sql 2023-07-14 21:18:29,950 | INFO | 191: File outputs/sample_files/sql/Find_Maximum_Float_Values.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/Table_Count_Fast_Alternatives.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/Create_2_Million_Tables.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/SQL Server 2016 SP1 Diagnostic Information Queries.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/dbo.usp_PrintError.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/dbo.sp_AllocationMetadata.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_diagnosis_indicator_transformation.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/Trace_Flag_2371.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/Who_dropped_database.sql 2023-07-14 21:18:29,951 | INFO | 191: File outputs/sample_files/sql/tempdb_Information.sql 2023-07-14 21:18:29,952 | INFO | 191: File outputs/sample_files/sql/Get_SQLServer_Startup_Parameters.sql 2023-07-14 21:18:29,952 | INFO | 191: File outputs/sample_files/sql/QueryActiveDirectory.sql 2023-07-14 21:18:29,952 | INFO | 191: File outputs/sample_files/sql/Get_Statistics_Details.sql 2023-07-14 21:18:29,952 | INFO | 191: File outputs/sample_files/sql/MaxServerMemoryCalculator.sql 2023-07-14 21:18:29,952 | INFO | 191: File outputs/sample_files/sql/dbo.sp_foreign_key$batch_drop_and_recreate.sql 2023-07-14 21:18:29,952 | INFO | 191: File outputs/sample_files/sql/Simulate_SQL_Server_Users_Hack.sql 2023-07-14 21:18:29,952 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_program_x_rac_transformation.sql 2023-07-14 21:18:29,952 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_code_range_x_group_transformation.sql 2023-07-14 21:18:29,953 | INFO | 191: File outputs/sample_files/sql/Find_SQL_Server_Integer_Columns_to_Make_Skinnier.sql 2023-07-14 21:18:29,953 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_facility_type_x_group_transformation.sql 2023-07-14 21:18:29,953 | INFO | 191: File outputs/sample_files/sql/dbo.usp_RunCheckAllUntrustedForeignKeys.sql 2023-07-14 21:18:29,953 | INFO | 191: File outputs/sample_files/sql/Get_Latest_Success_and_Failure_Login.sql 2023-07-14 21:18:29,953 | INFO | 191: File outputs/sample_files/sql/IN_Memory_Example_2017.sql 2023-07-14 21:18:29,953 | INFO | 191: File outputs/sample_files/sql/dbo.sp_Example_RegisterAssembly_PDFCLR.sql 2023-07-14 21:18:29,953 | INFO | 191: File outputs/sample_files/sql/Truncate log file.sql 2023-07-14 21:18:29,953 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_reference_inactivation_status_transformation.sql 2023-07-14 21:18:29,954 | INFO | 191: File outputs/sample_files/sql/Find_Not_Used_Legacy_Tables.sql 2023-07-14 21:18:29,954 | INFO | 191: File outputs/sample_files/sql/FindingImplicitColumnConversionsInPlanCache.sql 2023-07-14 21:18:29,954 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_treatment_type_transformation.sql 2023-07-14 21:18:29,954 | INFO | 191: File outputs/sample_files/sql/Fast_alternative_to_sp_WhoIsActive.sql 2023-07-14 21:18:29,954 | INFO | 191: File outputs/sample_files/sql/Find_Foreign_Key_Chains_For_Tables.sql 2023-07-14 21:18:29,954 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_bill_type_x_group_transformation.sql 2023-07-14 21:18:29,954 | INFO | 191: File outputs/sample_files/sql/Find_Status_of_SQL_Server_Statistics.sql 2023-07-14 21:18:29,955 | INFO | 191: File outputs/sample_files/sql/Blocked_Session.sql 2023-07-14 21:18:29,955 | INFO | 191: File outputs/sample_files/sql/Database_Mail_Configuration.sql 2023-07-14 21:18:29,955 | INFO | 191: File outputs/sample_files/sql/Index Breakdown.sql 2023-07-14 21:18:29,955 | INFO | 191: File outputs/sample_files/sql/Get_SQL_Server_Backup_Directory.sql 2023-07-14 21:18:29,955 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_taxonomy_rate_attachment_transformation.sql 2023-07-14 21:18:29,955 | INFO | 191: File outputs/sample_files/sql/dbo.usp_String_Search.sql 2023-07-14 21:18:29,955 | INFO | 191: File outputs/sample_files/sql/IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql 2023-07-14 21:18:29,955 | INFO | 191: File outputs/sample_files/sql/dbo.sp_WhatsupQueryStore.sql 2023-07-14 21:18:29,956 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_x_fund_detail_transformation.sql 2023-07-14 21:18:29,956 | INFO | 191: File outputs/sample_files/sql/DynamicallyGenerateDMAStatement.sql 2023-07-14 21:18:29,956 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_diag_age_range_transformation.sql 2023-07-14 21:18:29,956 | INFO | 191: File outputs/sample_files/sql/Test_job.sql 2023-07-14 21:18:29,956 | INFO | 191: File outputs/sample_files/sql/tempdb_usage.sql 2023-07-14 21:18:29,956 | INFO | 191: File outputs/sample_files/sql/Get_SQL_Server_NUMA_Memory.sql 2023-07-14 21:18:29,956 | INFO | 191: File outputs/sample_files/sql/PowerSavingCheck.sql 2023-07-14 21:18:29,957 | INFO | 191: File outputs/sample_files/sql/dbo.sp_PrintString.sql 2023-07-14 21:18:29,957 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_tenant_transformation.sql 2023-07-14 21:18:29,957 | INFO | 191: File outputs/sample_files/sql/SQL_Server_Fixed_Role_Permissions.sql 2023-07-14 21:18:29,957 | INFO | 191: File outputs/sample_files/sql/Get_Create_or_Alter_Index_Progress.sql 2023-07-14 21:18:29,957 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_functional_area_transformation.sql 2023-07-14 21:18:29,957 | INFO | 191: File outputs/sample_files/sql/dbo.usp_DBA_Rename_Database.sql 2023-07-14 21:18:29,958 | INFO | 191: File outputs/sample_files/sql/dbo.sp_helpExpandView.sql 2023-07-14 21:18:29,958 | INFO | 191: File outputs/sample_files/sql/dbo.sp_FailedJobs.sql 2023-07-14 21:18:29,958 | INFO | 191: File outputs/sample_files/sql/Who_dropped_altered_database_object.sql 2023-07-14 21:18:29,958 | INFO | 191: File outputs/sample_files/sql/Partial_Restore_Demo.sql 2023-07-14 21:18:29,958 | INFO | 191: File outputs/sample_files/sql/Which_databases_were_backed_up_and_when.sql 2023-07-14 21:18:29,958 | INFO | 191: File outputs/sample_files/sql/Restore_Database_Dynamic_SQL.sql 2023-07-14 21:18:29,958 | INFO | 191: File outputs/sample_files/sql/When_SQL_Server_Was_Installed.sql 2023-07-14 21:18:29,958 | INFO | 191: File outputs/sample_files/sql/Drop_all_objects_in_schema.sql 2023-07-14 21:18:29,959 | INFO | 191: File outputs/sample_files/sql/Queries_vulnerable_to_SQL_injection.sql 2023-07-14 21:18:29,959 | INFO | 191: File outputs/sample_files/sql/Disabling_Jobs_Schedules.sql 2023-07-14 21:18:29,959 | INFO | 191: File outputs/sample_files/sql/SQL Server 2016 Diagnostic Information Queries.sql 2023-07-14 21:18:29,959 | INFO | 191: File outputs/sample_files/sql/Auto_Generate_Database_Documentation.sql 2023-07-14 21:18:29,959 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_ansthsa_cost_factor_transformation.sql 2023-07-14 21:18:29,959 | INFO | 191: File outputs/sample_files/sql/Show all permissions in a database.sql 2023-07-14 21:18:29,959 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_prcdr_age_range_transformation.sql 2023-07-14 21:18:29,959 | INFO | 191: File outputs/sample_files/sql/dbo.sp_help_permissions.sql 2023-07-14 21:18:29,960 | INFO | 191: File outputs/sample_files/sql/Compare_2_tables_by_column_names.sql 2023-07-14 21:18:29,960 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_treatment_type_indicator_transformation.sql 2023-07-14 21:18:29,960 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_groups_transformation.sql 2023-07-14 21:18:29,960 | INFO | 191: File outputs/sample_files/sql/dbo.sp_Depends.sql 2023-07-14 21:18:29,960 | INFO | 191: File outputs/sample_files/sql/dbo.sp_BenchmarkTSQL.sql 2023-07-14 21:18:29,960 | INFO | 191: File outputs/sample_files/sql/Queries_with_parallelism.sql 2023-07-14 21:18:29,960 | INFO | 191: File outputs/sample_files/sql/Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql 2023-07-14 21:18:29,960 | INFO | 191: File outputs/sample_files/sql/Reseed_Identity_Column_Value_To_Last_Value.sql 2023-07-14 21:18:29,961 | INFO | 191: File outputs/sample_files/sql/Using_OPENROWSET_to_Query_Excel.sql 2023-07-14 21:18:29,961 | INFO | 191: File outputs/sample_files/sql/Code_Reuse_With_Dynamic_SQL_and_Temp_Procedures_Example.sql 2023-07-14 21:18:29,961 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_geo_unit_x_group_transformation.sql 2023-07-14 21:18:29,961 | INFO | 191: File outputs/sample_files/sql/Get_Table_and_Index_Storage_Size.sql 2023-07-14 21:18:29,961 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_submit_facilty_transformation.sql 2023-07-14 21:18:29,961 | INFO | 191: File outputs/sample_files/sql/SQL Server 2016 SP2 Diagnostic Information Queries.sql 2023-07-14 21:18:29,961 | INFO | 191: File outputs/sample_files/sql/Table_Parameters.sql 2023-07-14 21:18:29,962 | INFO | 191: File outputs/sample_files/sql/dbo.sp_GenerateMerge.sql 2023-07-14 21:18:29,962 | INFO | 191: File outputs/sample_files/sql/dbo.usp_CopyLogins.sql 2023-07-14 21:18:29,962 | INFO | 191: File outputs/sample_files/sql/Monitor_Deadlocks_with_Extended_Events.sql 2023-07-14 21:18:29,962 | INFO | 191: File outputs/sample_files/sql/Which_Filegroup_is_that_Partition_Using.sql 2023-07-14 21:18:29,962 | INFO | 191: File outputs/sample_files/sql/MaxDop_2016_and_higher.sql 2023-07-14 21:18:29,962 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_diagnosis_status_transformation.sql 2023-07-14 21:18:29,962 | INFO | 191: File outputs/sample_files/sql/Read_errorlog.sql 2023-07-14 21:18:29,962 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_holiday_master_transformation.sql 2023-07-14 21:18:29,963 | INFO | 191: File outputs/sample_files/sql/dbo.usp_GenerateRandomPassword.sql 2023-07-14 21:18:29,963 | INFO | 191: File outputs/sample_files/sql/Current_Running_Queries.sql 2023-07-14 21:18:29,963 | INFO | 191: File outputs/sample_files/sql/Check_Reserved_Words_For_Object_Names.sql 2023-07-14 21:18:29,963 | INFO | 191: File outputs/sample_files/sql/Recover_Deleted_Data_Proc.sql 2023-07-14 21:18:29,963 | INFO | 191: File outputs/sample_files/sql/Job_AG_Resume_Data_Movement.sql 2023-07-14 21:18:29,963 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_diagnosis_detail_transformation.sql 2023-07-14 21:18:29,963 | INFO | 191: File outputs/sample_files/sql/Visualizing_VLF.sql 2023-07-14 21:18:29,963 | INFO | 191: File outputs/sample_files/sql/MisleadingSQLServerPerformanceCounters.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_modifier_transformation.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_period_type_transformation.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/Which_sp_configure_Options_Clear_the_Plan_Cache.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/dbo.sp_SQLskills_helpindex.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/dbo.sp_SQLskills_ExposeColsInIndexLevels.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/Cached_Data_Per_Object_in_Memory.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/ShredDeadlockGraph.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/Extract_Scale_Part_From_Decimal_Number.sql 2023-07-14 21:18:29,964 | INFO | 191: File outputs/sample_files/sql/dbo.sp_ChangeDatabaseOwnerShip.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/dbo.usp_SearchStoredProcedureText.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/GoogleJobTimeline.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/dbo.sp_ctrl3.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/FindDBConnectionLeaks.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/Dynamic_GRANT_Generation.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/Count character matches.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_reference_association_status_transformation.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_drg_rate_factor_transformation.sql 2023-07-14 21:18:29,965 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_store_transformation.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/Generate_Restore_Script_From_Backup_Folder.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_dental_area_x_dental_area_transformation.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_holiday_exclusion_transformation.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/SQLServer_Memory_Information.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/Databases_Report.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/dbo.usp_SQLskillsAnalyzeLog.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/Get_Identity_Column_Information.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/What_Agent_Job_is_Running.sql 2023-07-14 21:18:29,966 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_correct_code_initiative_transformation.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/dbo.sp_estindex.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/Jobs_Find_And_Replace_Text.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/Find_Synonyms_for_nested_objects_in_the_same_database.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/Trace_Flag_8726.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/dbo.sp_BlitzInMemoryOLTP.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_revenue_x_clm_type_transformation.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_indicator_option_x_specialty_transformation.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/Trace_Flag_8727.sql 2023-07-14 21:18:29,967 | INFO | 191: File outputs/sample_files/sql/dbo.usp_BulkUpload.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/Configure_SQL_Agent_Alerts.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/Sort_SQL_Server_Tables_into_similarly_sized_buckets.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/Find_Object_Dependecy.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_length_of_stay_transformation.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/dbo.usp_PrintDebug.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/Foreign_Key_batch_rename.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/Ring_Bufer_Analyze.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/Checkpoint_XE.sql 2023-07-14 21:18:29,968 | INFO | 191: File outputs/sample_files/sql/Foreign_Keys_With_No_Index.sql 2023-07-14 21:18:29,969 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_submit_facilty_span_transformation.sql 2023-07-14 21:18:29,969 | INFO | 191: File outputs/sample_files/sql/Selects_That_Cause_Writes.sql 2023-07-14 21:18:29,969 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_unit_of_measurement_transformation.sql 2023-07-14 21:18:29,969 | INFO | 191: File outputs/sample_files/sql/Remove_Leading_and_Trailing_Backward_and_Forward_Slashes.sql 2023-07-14 21:18:29,969 | INFO | 191: File outputs/sample_files/sql/Move_tempdb.sql 2023-07-14 21:18:29,969 | INFO | 191: File outputs/sample_files/sql/Search_Script.sql 2023-07-14 21:18:29,969 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_region_transformation.sql 2023-07-14 21:18:29,970 | INFO | 191: File outputs/sample_files/sql/dbo.usp_EnableAndAddFileStreamForDatabase.sql 2023-07-14 21:18:29,970 | INFO | 191: File outputs/sample_files/sql/Trace_Flag_3895.sql 2023-07-14 21:18:29,970 | INFO | 191: File outputs/sample_files/sql/Get_Amazon_RDS_Instance_Size.sql 2023-07-14 21:18:29,970 | INFO | 191: File outputs/sample_files/sql/dbo.sp_RestoreScript.sql 2023-07-14 21:18:29,970 | INFO | 191: File outputs/sample_files/sql/Uppercase_All_String_Columns.sql 2023-07-14 21:18:29,970 | INFO | 191: File outputs/sample_files/sql/Azure SQL Database Diagnostic Information Queries.sql 2023-07-14 21:18:29,970 | INFO | 191: File outputs/sample_files/sql/Index_Creating_Info.sql 2023-07-14 21:18:29,970 | INFO | 191: File outputs/sample_files/sql/dbo.sp_FailedLogins.sql 2023-07-14 21:18:29,971 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_status_transformation.sql 2023-07-14 21:18:29,971 | INFO | 191: File outputs/sample_files/sql/Change_NonDefault_Collation_for_all_tables.sql 2023-07-14 21:18:29,971 | INFO | 191: File outputs/sample_files/sql/Jobs_Get_Runing_info.sql 2023-07-14 21:18:29,971 | INFO | 191: File outputs/sample_files/sql/GetResourceNameFromBlockedProcessReport.sql 2023-07-14 21:18:29,971 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_program_x_modifier_transformation.sql 2023-07-14 21:18:29,971 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_treatment_type_detail_transformation.sql 2023-07-14 21:18:29,971 | INFO | 191: File outputs/sample_files/sql/dbo.usp_Dijkstra.sql 2023-07-14 21:18:29,971 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_roster_detail_transformation.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/Tempdb_Contention.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/Sort_UID_Demo.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/dbo.usp_UnusedInputParameters.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/Get_Coulmn_Statistics_By_Name.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/Get_Opened_Transactions_Info.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/Restore_script_for_Ola_Hallengren_backup.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/FindTablesWithSimilarTableStructure.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_diagnosis_x_group_transformation.sql 2023-07-14 21:18:29,972 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_ctgry_x_group_store_transformation.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/dbo.usp_who5.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/SQL Server 2008 R2 Diagnostic Information Queries.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/Bad_Query_Example_13_JOINS.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/Enabling_Jobs_Schedules.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_category_transformation.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/SQL Server 2019 Diagnostic Information Queries.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/DetermineSpaceWithinSQLDatabaseFiles.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/TuneYourIndexingStrategyWithDMVs.sql 2023-07-14 21:18:29,973 | INFO | 191: File outputs/sample_files/sql/DBCC_CHECKDB_Latest_date.sql 2023-07-14 21:18:29,974 | INFO | 191: File outputs/sample_files/sql/Build_CREATE_TABLE_statement_using_dm_exec_describe_first_result_set.sql 2023-07-14 21:18:29,974 | INFO | 191: File outputs/sample_files/sql/SQL Server 2012 Diagnostic Information Queries.sql 2023-07-14 21:18:29,974 | INFO | 191: File outputs/sample_files/sql/Identify_All_Logins_With_No_Associated_Default_Database_User.sql 2023-07-14 21:18:29,974 | INFO | 191: File outputs/sample_files/sql/BufferPoolExtension.sql 2023-07-14 21:18:29,974 | INFO | 191: File outputs/sample_files/sql/dbo.sp_doc.sql 2023-07-14 21:18:29,974 | INFO | 191: File outputs/sample_files/sql/dbo.sp_capture_login_auth.sql 2023-07-14 21:18:29,974 | INFO | 191: File outputs/sample_files/sql/dbo.usp_Breadth_First.sql 2023-07-14 21:18:29,975 | INFO | 191: File outputs/sample_files/sql/Objects_Size_In_Database.sql 2023-07-14 21:18:29,975 | INFO | 191: File outputs/sample_files/sql/Enable Microsoft.ACE.OLEDB.12.0.sql 2023-07-14 21:18:29,975 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_program_x_group_transformation.sql 2023-07-14 21:18:29,975 | INFO | 191: File outputs/sample_files/sql/dbo.sp_PerfSQ.sql 2023-07-14 21:18:29,975 | INFO | 191: File outputs/sample_files/sql/dbo.usp_generateIdentifier.sql 2023-07-14 21:18:29,975 | INFO | 191: File outputs/sample_files/sql/Space used by object.sql 2023-07-14 21:18:29,975 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_taxonomy_rate_transformation.sql 2023-07-14 21:18:29,975 | INFO | 191: File outputs/sample_files/sql/dbo.udp_IntegerListfromRanges.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_clsfctn_desc_transformation.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/dbo.sp_sizing.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/Job_AG_Failover_Detected.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/Get_SQL_Server_Agent_Information.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_x_group_store_transformation.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/dbo.usp_bcpUnloadSelect.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/Numbers_DATALENGTH.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_modifier_crosswalk_transformation.sql 2023-07-14 21:18:29,976 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_diag_related_group_transformation.sql 2023-07-14 21:18:29,977 | INFO | 191: File outputs/sample_files/sql/Count_Database_Reads_and_Writes.sql 2023-07-14 21:18:29,977 | INFO | 191: File outputs/sample_files/sql/dbo.usp_CreatePlantUMLCode.sql 2023-07-14 21:18:29,977 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_drg_rate_transformation.sql 2023-07-14 21:18:29,977 | INFO | 191: File outputs/sample_files/sql/Visualizing_Agent_Jobs_in_SSMS.sql 2023-07-14 21:18:29,977 | INFO | 191: File outputs/sample_files/sql/Security_Audit_Report.sql 2023-07-14 21:18:29,977 | INFO | 191: File outputs/sample_files/sql/dbo.usp_Prim.sql 2023-07-14 21:18:29,977 | INFO | 191: File outputs/sample_files/sql/Disable_Enable_All_Triggers_In_Database.sql 2023-07-14 21:18:29,977 | INFO | 191: File outputs/sample_files/sql/dbo.usp_Generate_Merge.sql 2023-07-14 21:18:29,978 | INFO | 191: File outputs/sample_files/sql/How_to_Find_Queries_Using_an_Index.sql 2023-07-14 21:18:29,978 | INFO | 191: File outputs/sample_files/sql/Shredding_XML_Data_From_Extended_Events.sql 2023-07-14 21:18:29,978 | INFO | 191: File outputs/sample_files/sql/Create_JOIN_Query_Between_Multiple_Tables_Dynamically.sql 2023-07-14 21:18:29,978 | INFO | 191: File outputs/sample_files/sql/FindLongRunningJobSteps.sql 2023-07-14 21:18:29,978 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_relative_value_unit_transformation.sql 2023-07-14 21:18:29,978 | INFO | 191: File outputs/sample_files/sql/dbo.usp_GetPackageDetails.sql 2023-07-14 21:18:29,978 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_diagnosis_transformation.sql 2023-07-14 21:18:29,978 | INFO | 191: File outputs/sample_files/sql/Temporal_Table_Maker.sql 2023-07-14 21:18:29,979 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_reference_additive_transformation.sql 2023-07-14 21:18:29,979 | INFO | 191: File outputs/sample_files/sql/How_to_obtain_the_deadlocks_on_Azure.sql 2023-07-14 21:18:29,979 | INFO | 191: File outputs/sample_files/sql/Bufer_Cache_Info.sql 2023-07-14 21:18:29,979 | INFO | 191: File outputs/sample_files/sql/Stop_long-running_SQL_Server_Agent_Jobs.sql 2023-07-14 21:18:29,979 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_durable_medical_equipment_transformation.sql 2023-07-14 21:18:29,979 | INFO | 191: File outputs/sample_files/sql/WhiteListIPTable.sql 2023-07-14 21:18:29,979 | INFO | 191: File outputs/sample_files/sql/SQL Managed Instance Diagnostic Information Queries.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/dbo.sp_ns_shrink_db_log.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_modifier_detail_transformation.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/SQL Server 2014 Diagnostic Information Queries.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/dbo.sp_sqltrace.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_facility_prvdr_rate_transformation.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/Read_Error_Log_File.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_specialty_x_group_transformation.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/FindingSpecificColumns.sql 2023-07-14 21:18:29,980 | INFO | 191: File outputs/sample_files/sql/Generate_table_definition_to_match_query.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_sbmt_fclty_bill_clsfctn_transformation.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/dbo.sp_RestoreGene.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/dbo.usp_TransliterationEN2RU.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/Wait_Statistics_Snapshot.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_facility_type_transformation.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_dental_area_type_association_transformation.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_drg_indicator_transformation.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_group_rate_attachment_transformation.sql 2023-07-14 21:18:29,981 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_drg_pricing_exception_transformation.sql 2023-07-14 21:18:29,982 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_drg_detail_transformation.sql 2023-07-14 21:18:29,982 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_modifier_status_transformation.sql 2023-07-14 21:18:29,982 | INFO | 191: File outputs/sample_files/sql/dbo.sp_Blocked_Process_Report_Viewer.sql 2023-07-14 21:18:29,982 | INFO | 191: File outputs/sample_files/sql/Decrypt T-SQL module.sql 2023-07-14 21:18:29,982 | INFO | 191: File outputs/sample_files/sql/Trace_Flag_1165.sql 2023-07-14 21:18:29,982 | INFO | 191: File outputs/sample_files/sql/Date_Calendar_Cross-Reference_Table.sql 2023-07-14 21:18:29,982 | INFO | 191: File outputs/sample_files/sql/udprdsftcore.udp_d_bill_classification_transformation.sql 2023-07-14 21:18:29,982 | INFO | 181: Unzipping and sorting file to outputs/sample_files done 2023-07-14 21:18:30,818 | INFO | 316: Complexity file level info : { "pig": { "limit.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 9, "complexity": "simple" }, "order-by.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 12, "complexity": "simple" }, "multi-delimiter.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 9, "complexity": "simple" }, "distinct.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 9, "complexity": "simple" }, "lookup.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 14, "complexity": "simple" }, "join.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 12, "complexity": "simple-medium" }, "from-vim.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 15, "complexity": "simple" }, "strip-quote.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 14, "complexity": "simple" }, "count-words.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 1, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 15, "complexity": "simple" }, "filter-by.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 10, "complexity": "simple" }, "count.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 9, "complexity": "simple" }, "stream-shell-script.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 7, "complexity": "simple" }, "get-twitter-names.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 15, "complexity": "simple" }, "stream-python.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 7, "complexity": "simple" }, "load-store.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 9, "complexity": "simple" }, "group-by.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 9, "complexity": "simple" }, "data-bag.pig": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 11, "complexity": "simple" } }, "py": { "pyspark-create-dataframe.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "pyspark-select-columns.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 72, "complexity": "simple" }, "pyspark-drop-column.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "pyspark-broadcast-dataframe.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 37, "complexity": "simple" }, "pyspark-update-column.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "pyspark-rename-column.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 85, "complexity": "simple" }, "pyspark-timestamp-date.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 55, "complexity": "simple" }, "pyspark-unix-time.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 42, "complexity": "simple" }, "pyspark-rdd-wordcount-2.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 44, "complexity": "simple" }, "pyspark-read-json.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 66, "complexity": "simple" }, "pyspark-join.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 14, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 82, "complexity": "medium-complex" }, "pyspark-window-functions.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 4, "rank": 6, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 73, "complexity": "simple" }, "pyspark-repartition-2.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 28, "complexity": "simple" }, "python-pandas.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 26, "complexity": "simple" }, "pyspark-sql-case-when.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 47, "complexity": "simple" }, "pyspark-split-function.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 50, "complexity": "simple" }, "pyspark-date-string.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 29, "complexity": "simple" }, "pyspark-when-otherwise.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 54, "complexity": "simple" }, "pyspark-lit.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 24, "complexity": "simple" }, "pyspark-parallelize.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 22, "complexity": "simple" }, "pyspark-string-date.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 27, "complexity": "simple" }, "pyspark-change-string-double.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 35, "complexity": "simple" }, "pyspark-rdd-broadcast.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 29, "complexity": "simple" }, "pyspark-string-timestamp.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "pyspark-count-distinct.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 34, "complexity": "simple" }, "pyspark-rdd.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 16, "complexity": "simple" }, "pyspark-dataframe-repartition.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 23, "complexity": "simple" }, "pyspark-maptype-dataframe-column.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 56, "complexity": "simple" }, "pyspark-python-dataframe.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 53, "complexity": "simple" }, "pyspark-rdd-map.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 66, "complexity": "simple" }, "pyspark-types.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 55, "complexity": "simple" }, "pyspark-current-date-timestamp.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 34, "complexity": "simple" }, "pyspark-read-csv.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 61, "complexity": "simple" }, "pyspark-rdd-to-dataframe.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 45, "complexity": "simple" }, "spark-repartition-2.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 28, "complexity": "simple" }, "pyspark-shape-dataframe.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 27, "complexity": "simple" }, "pyspark-collect.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 30, "complexity": "simple" }, "pyspark-empty-data-frame.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 34, "complexity": "simple" }, "pyspark-date-timestamp-functions.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 97, "complexity": "simple" }, "pyspark-withcolumn.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 88, "complexity": "simple" }, "pyspark-struct-to-map.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 35, "complexity": "simple" }, "pyspark-create-dataframe-dictionary.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 52, "complexity": "simple" }, "pyspark-rdd-actions.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 91, "complexity": "simple" }, "pyspark-sampling.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 37, "complexity": "simple" }, "pyspark-sparksession.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 30, "complexity": "simple" }, "pyspark-dataframe-flatMap.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 20, "complexity": "simple" }, "pyspark-convert-map-to-columns.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 42, "complexity": "simple" }, "pyspark-mappartitions.py": { "update": 3, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 37, "complexity": "simple" }, "pyspark-udf.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 80, "complexity": "simple" }, "pyspark-dataframe.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 13, "complexity": "simple" }, "pyspark-rdd-reduceByKey.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 27, "complexity": "simple" }, "pyspark-time-diff.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 73, "complexity": "simple" }, "pyspark-left-anti-join.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 41, "complexity": "simple-medium" }, "pyspark-explode-array-map.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 54, "complexity": "simple" }, "pyspark-add-new-column.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 69, "complexity": "simple" }, "pyspark-orderby.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 52, "complexity": "simple" }, "pyspark-groupby-sort.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 69, "complexity": "simple" }, "pyspark-string-to-array.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 32, "complexity": "simple" }, "currentdate.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 23, "complexity": "simple" }, "pyspark-expr.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 45, "complexity": "simple" }, "pyspark-filter.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 77, "complexity": "simple" }, "pyspark-column-functions.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 112, "complexity": "simple" }, "pyspark-row.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 65, "complexity": "simple" }, "pyspark-array-string.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 29, "complexity": "simple" }, "pyspark-explode-nested-array.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 2, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 31, "complexity": "simple" }, "pyspark-rdd-wordcount.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 32, "complexity": "simple" }, "pyspark-fulter-null.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 27, "complexity": "simple" }, "pyspark-groupby.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 53, "complexity": "simple" }, "pyspark-column-operations.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 57, "complexity": "simple" }, "pyspark-convert_columns-to-map.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "pyspark-datediff.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 40, "complexity": "simple" }, "pyspark-pivot.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "pyspark-cast-column.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "timediff.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 32, "complexity": "simple" }, "pyspark-show-top-n-rows.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 55, "complexity": "simple" }, "pyspark-distinct.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 37, "complexity": "simple" }, "pyspark-repartition.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "pandas-pyspark-dataframe.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 47, "complexity": "simple" }, "pyspark-create-list.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 51, "complexity": "simple" }, "pyspark-rdd-flatMap.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 23, "complexity": "simple" }, "pyspark-union.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 5, "partition by": 0, "partitioned": 0, "line_of_code": 41, "complexity": "simple" }, "pyspark-orderby-groupby.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "pyspark-join-two-dataframes.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 7, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 74, "complexity": "medium" }, "pyspark-aggregate.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 62, "complexity": "simple" }, "pyspark-filter-null.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 45, "complexity": "simple" }, "pyspark-print-contents.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 38, "complexity": "simple" }, "pyspark-loop.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 76, "complexity": "simple" }, "pyspark-drop-null.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 26, "complexity": "simple" }, "pyspark-range-partition.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 35, "complexity": "simple" }, "pyspark-filter2.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 17, "complexity": "simple" }, "pyspark-add-month.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 13, "complexity": "simple" }, "pyspark-arraytype.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 44, "complexity": "simple" }, "pyspark-repace-null.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 38, "complexity": "simple" }, "pyspark-partitionby.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 60, "complexity": "simple" }, "schema.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 28, "complexity": "simple" }, "pyspark-structtype.py": { "update": 3, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 83, "complexity": "simple" }, "convert-column-python-list.py": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 48, "complexity": "simple" } }, "txt": { "glen_berry_diagnostic_queries_links.txt": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 9, "complexity": "simple" } }, "shell": {}, "pyspark": {}, "R": { "mssql2csv.R": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 118, "complexity": "simple" }, "Benchmark_TSQL.R": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 296, "complexity": "simple" } }, "xml": { "ShredDeadlockGraph_Sample2.xml": { "update": 30, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 335, "complexity": "complex" }, "ShredDeadlockGraph_Sample1.xml": { "update": 7, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 53, "complexity": "medium" } }, "sh": { "sample_call.sh": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 141, "complexity": "simple" }, "test_twitter.sh": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 141, "complexity": "simple" }, "file_config.sh": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 141, "complexity": "simple" }, "final_call.sh": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 141, "complexity": "simple" }, "api_call.sh": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 141, "complexity": "simple" } }, "hive": {}, "sql": { "Database_Mail_Problems.sql": { "update": 0, "delete": 1, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 90, "complexity": "simple" }, "AutoGuessingForeignKeyConstraints.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 10, "union": 0, "partition by": 2, "partitioned": 0, "line_of_code": 78, "complexity": "medium" }, "udprdsftcore.udp_d_pricing_exception_type_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "SpaceusedByTable.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 76, "complexity": "simple" }, "dbo.usp_RandomWait.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "CheckSpectreMeltdownStatus.sql": { "update": 13, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 238, "complexity": "medium-complex" }, "Trace_Flag_8602.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 76, "complexity": "simple" }, "dbo.sp_Snapshot.sql": { "update": 0, "delete": 1, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 156, "complexity": "simple" }, "Wait_Statistics.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 128, "complexity": "simple" }, "Line_Of_Codes_In_database.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 19, "complexity": "simple" }, "Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 26, "complexity": "simple" }, "Windows logins not in AD.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 19, "complexity": "simple" }, "SQL Server 2008 Diagnostic Information Queries.sql": { "update": 15, "delete": 0, "insert": 7, "flatten": 0, "row_number": 4, "rank": 6, "join": 42, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 1316, "complexity": "complex" }, "dbo.usp_TopologicalSort.sql": { "update": 1, "delete": 1, "insert": 7, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 127, "complexity": "simple" }, "udprdsftcore.udp_d_dental_area_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Indexes_Script_Out.sql": { "update": 2, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 10, "union": 0, "partition by": 0, "partitioned": 1, "line_of_code": 139, "complexity": "medium" }, "udprdsftcore.udp_d_group_rate_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Pattern_Match.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 1, "rank": 0, "join": 5, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 63, "complexity": "simple-medium" }, "dbo.usp_SSIS_ScriptEnvironment.sql": { "update": 1, "delete": 2, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 124, "complexity": "simple-medium" }, "udprdsftcore.udp_d_drg_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_provider_rate_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_age_range_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "CPU_Utilization.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 27, "complexity": "simple" }, "VLF_Info.sql": { "update": 1, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 122, "complexity": "simple" }, "Get_Database_Size_With_Graph.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 19, "complexity": "simple" }, "dbo.usp_bcpTableUnloadBatchMode.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 63, "complexity": "simple" }, "dbo.sp_helpme.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 6, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 477, "complexity": "medium" }, "How_old_your_backups.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 3, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 38, "complexity": "simple" }, "udprdsftcore.udp_member_rate_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_provider_rate_attachment_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Delete_Login_And_All_Users.sql": { "update": 0, "delete": 4, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 134, "complexity": "simple" }, "Jobs_Detailed_History.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 9, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 118, "complexity": "medium" }, "MAXDOP_recommendation.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 97, "complexity": "simple" }, "udprdsftcore.udp_d_relative_value_unit_detail_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_SQL_Server_System_Report.sql": { "update": 4, "delete": 0, "insert": 7, "flatten": 0, "row_number": 5, "rank": 9, "join": 35, "union": 0, "partition by": 3, "partitioned": 0, "line_of_code": 3135, "complexity": "complex" }, "dbo.usp_SearchOnAllDB.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 189, "complexity": "simple-medium" }, "dbo.usp_SetFileGrowth.sql": { "update": 2, "delete": 3, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 292, "complexity": "simple" }, "RenameDefaultConstraints.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 47, "complexity": "simple" }, "Simulate_Permissions_Logins_Change.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 111, "complexity": "simple" }, "Checking_Your_Backup_Paths_Exist_and_Automatically_Create_it.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "udprdsftcore.udp_d_prcdr_usg_x_prcng_excptn_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_checkAllDatabases.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 37, "complexity": "simple" }, "Save_Error_Log_To_Table.sql": { "update": 1, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 64, "complexity": "simple" }, "udprdsftcore.udp_d_modifier_indicator_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_drg_mbr_age_vald_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_DBA_job_notification.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 147, "complexity": "simple" }, "Data_Dictionary_Information.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 9, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 153, "complexity": "medium" }, "Memory_Consumption_By_Object.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 5, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 122, "complexity": "simple-medium" }, "udprdsftcore.udp_d_member_rate_attachment_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_age_range_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_prcdr_clinic_visit_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Which_Indexes_are_not_Used.sql": { "update": 10, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 46, "complexity": "medium" }, "Overview_HADR_AlwaysOn_Local_Replica_Server.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 7, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 62, "complexity": "medium" }, "SplitFileGroup.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 192, "complexity": "simple" }, "Server_Parameters.sql": { "update": 2, "delete": 0, "insert": 65, "flatten": 0, "row_number": 0, "rank": 1, "join": 1, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 124, "complexity": "complex" }, "Finding_Host_Names_for_Failed_login_attempts.sql": { "update": 4, "delete": 3, "insert": 4, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 168, "complexity": "simple-medium" }, "Suspect_Database_Pages.sql": { "update": 1, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 29, "complexity": "simple" }, "dbo.usp_TableUnpivot.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 108, "complexity": "simple" }, "Find_Synonyms_for_nested_objects_in_the_different_databases.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 111, "complexity": "simple" }, "udprdsftcore.udp_d_facility_type_status_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Date_Format_Cheat_Sheet.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 1, "rank": 0, "join": 0, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 69, "complexity": "simple" }, "Get_Table_Hierarchy.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 6, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 71, "complexity": "medium" }, "udprdsftcore.udp_d_prvdr_drg_rate_factor_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_ref_operator_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_prcdr_x_mdfr_indicator_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Current_Running_Tasks_and_Server_Info.sql": { "update": 16, "delete": 0, "insert": 22, "flatten": 0, "row_number": 2, "rank": 2, "join": 46, "union": 5, "partition by": 4, "partitioned": 0, "line_of_code": 1196, "complexity": "complex" }, "SQL_Server_Defaults.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 157, "partition by": 0, "partitioned": 0, "line_of_code": 161, "complexity": "simple" }, "udprdsftcore.udp_d_modifier_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Backup_Restore_What\u256c\u00f4C\u2560\u00baO\u2560\u00eas_My_Status.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 31, "complexity": "simple" }, "dbo.usp_Object_Search.sql": { "update": 0, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 5, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 1125, "complexity": "complex" }, "Get_CPU_Usage_Per_Database.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 37, "complexity": "simple" }, "How_much_will_it_cost_or_save_to_rebuild_that_index.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 1, "line_of_code": 69, "complexity": "simple" }, "dbo.usp_Kruskal.sql": { "update": 1, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 109, "complexity": "simple" }, "SQL_Azure_Approximate_Datetime_Restart.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 1, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 42, "complexity": "simple" }, "dbo.sp_Defrag_Indexes.sql": { "update": 26, "delete": 1, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 2, "line_of_code": 1458, "complexity": "complex" }, "udprdsftcore.udp_d_bill_classification_span_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "CPU_Utilization_Graphical_form.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 0, "union": 2, "partition by": 0, "partitioned": 0, "line_of_code": 29, "complexity": "simple" }, "dbo.usp_FindDbObjects.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 23, "complexity": "simple" }, "Generate_BIML_Script.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 90, "complexity": "simple" }, "Trace_Flag_460.sql": { "update": 0, "delete": 0, "insert": 4, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 68, "complexity": "simple" }, "dbo.sp_IndexAnalysis-v11.sql": { "update": 39, "delete": 4, "insert": 9, "flatten": 0, "row_number": 3, "rank": 8, "join": 31, "union": 2, "partition by": 6, "partitioned": 0, "line_of_code": 916, "complexity": "complex" }, "udprdsftcore.udp_d_program_x_rac_priority_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Compress_Tables_And_Indexes.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 8, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 205, "complexity": "medium" }, "dbo.sqlg_ParseDiskskpXml.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 11, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 366, "complexity": "medium-complex" }, "udprdsftcore.udp_d_pricing_exception_base_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_sp_ssp_x_grp_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_diag_prcdr_crosscoder_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "SQL Server 2017 Diagnostic Information Queries.sql": { "update": 37, "delete": 2, "insert": 6, "flatten": 0, "row_number": 4, "rank": 6, "join": 56, "union": 0, "partition by": 2, "partitioned": 0, "line_of_code": 2056, "complexity": "complex" }, "dbo.usp_LogError.sql": { "update": 0, "delete": 0, "insert": 4, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 83, "complexity": "simple" }, "Find_and_fix_that_troublesome_Windows_Power_setting.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 95, "complexity": "simple" }, "Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 23, "complexity": "simple" }, "Query_Store_Export.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 8, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 163, "complexity": "medium" }, "Find_Weak_Passwords.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 87, "complexity": "simple" }, "Finding_Blocking_Queries.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 1, "partition by": 1, "partitioned": 0, "line_of_code": 54, "complexity": "simple" }, "dbo.sp_sizeoptimiser.sql": { "update": 9, "delete": 0, "insert": 29, "flatten": 0, "row_number": 1, "rank": 3, "join": 45, "union": 1, "partition by": 1, "partitioned": 0, "line_of_code": 1367, "complexity": "complex" }, "LatchStats.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 28, "complexity": "simple" }, "Get_latches_Objects.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 6, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 83, "complexity": "medium" }, "dbo.usp_bcpTableUnload.sql": { "update": 2, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 203, "complexity": "simple" }, "Fix_The_Broken_Dependencies_On_All_Objects.sql": { "update": 0, "delete": 1, "insert": 6, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 185, "complexity": "simple" }, "dbo.usp_LoadTableBlobs.sql": { "update": 6, "delete": 4, "insert": 22, "flatten": 0, "row_number": 1, "rank": 2, "join": 43, "union": 2, "partition by": 13, "partitioned": 0, "line_of_code": 390, "complexity": "complex" }, "New_Default_Database_Assignment_For_Any_Login_Missing_Their_Default_Database.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 89, "complexity": "simple" }, "udprdsftcore.udp_d_groups_x_lookup_domain_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "GenerateTSQLTimeSlices.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 4, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 30, "complexity": "simple" }, "SQL Server 2005 Diagnostic Information Queries.sql": { "update": 14, "delete": 0, "insert": 7, "flatten": 0, "row_number": 4, "rank": 6, "join": 34, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 1179, "complexity": "complex" }, "udprdsftcore.udp_d_group_other_detail_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Failed_SQL_Server_Agent_Jobs_With_Restart_Command.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 3, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "Read_Default_Trace.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 69, "complexity": "simple" }, "udprdsftcore.udp_d_group_indicator_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_generate_merge.sql": { "update": 19, "delete": 4, "insert": 13, "flatten": 0, "row_number": 1, "rank": 0, "join": 7, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 602, "complexity": "medium-complex" }, "Adding_Trace_Flags_To_Startup_Parameters.sql": { "update": 0, "delete": 4, "insert": 2, "flatten": 0, "row_number": 2, "rank": 0, "join": 1, "union": 4, "partition by": 0, "partitioned": 0, "line_of_code": 153, "complexity": "simple" }, "IN_Memory_Example_2014.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 116, "complexity": "simple" }, "dbo.sp_DropIndexes.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 79, "complexity": "simple" }, "dbo.PerformanceGraph.sql": { "update": 0, "delete": 0, "insert": 7, "flatten": 0, "row_number": 3, "rank": 0, "join": 0, "union": 0, "partition by": 3, "partitioned": 0, "line_of_code": 256, "complexity": "simple" }, "PIVOT_Columns_generator.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 22, "complexity": "simple" }, "Find_Non_Sargable_Queries.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 30, "complexity": "simple" }, "UnPivot_Output_Restore_Headeronly.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 3, "partition by": 0, "partitioned": 0, "line_of_code": 91, "complexity": "simple" }, "dbo.usp_GetUntrustedForeignKeys.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 94, "complexity": "simple" }, "Find_Maximum_Float_Values.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 47, "complexity": "simple" }, "Table_Count_Fast_Alternatives.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 26, "complexity": "simple" }, "Create_2_Million_Tables.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "SQL Server 2016 SP1 Diagnostic Information Queries.sql": { "update": 22, "delete": 2, "insert": 9, "flatten": 0, "row_number": 4, "rank": 6, "join": 56, "union": 0, "partition by": 2, "partitioned": 0, "line_of_code": 2015, "complexity": "complex" }, "dbo.usp_PrintError.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 20, "complexity": "simple" }, "dbo.sp_AllocationMetadata.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 103, "complexity": "simple" }, "udprdsftcore.udp_d_diagnosis_indicator_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Trace_Flag_2371.sql": { "update": 0, "delete": 2, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 111, "complexity": "simple" }, "Who_dropped_database.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 2, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 64, "complexity": "simple" }, "tempdb_Information.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 4, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 63, "complexity": "simple-medium" }, "Get_SQLServer_Startup_Parameters.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 16, "complexity": "simple" }, "QueryActiveDirectory.sql": { "update": 0, "delete": 1, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 43, "complexity": "simple" }, "Get_Statistics_Details.sql": { "update": 1, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 35, "complexity": "simple" }, "MaxServerMemoryCalculator.sql": { "update": 1, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 162, "complexity": "simple" }, "dbo.sp_foreign_key$batch_drop_and_recreate.sql": { "update": 0, "delete": 1, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 183, "complexity": "simple" }, "Simulate_SQL_Server_Users_Hack.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 121, "complexity": "simple" }, "udprdsftcore.udp_d_program_x_rac_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_code_range_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Find_SQL_Server_Integer_Columns_to_Make_Skinnier.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 7, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 105, "complexity": "medium" }, "udprdsftcore.udp_d_facility_type_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_RunCheckAllUntrustedForeignKeys.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 210, "complexity": "simple" }, "Get_Latest_Success_and_Failure_Login.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 83, "complexity": "simple" }, "IN_Memory_Example_2017.sql": { "update": 0, "delete": 0, "insert": 5, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 196, "complexity": "simple" }, "dbo.sp_Example_RegisterAssembly_PDFCLR.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 52, "complexity": "simple" }, "Truncate log file.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 3, "complexity": "simple" }, "udprdsftcore.udp_reference_inactivation_status_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Find_Not_Used_Legacy_Tables.sql": { "update": 1, "delete": 1, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 1, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 71, "complexity": "simple" }, "FindingImplicitColumnConversionsInPlanCache.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "udprdsftcore.udp_d_treatment_type_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Fast_alternative_to_sp_WhoIsActive.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 28, "complexity": "simple" }, "Find_Foreign_Key_Chains_For_Tables.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 9, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 81, "complexity": "medium" }, "udprdsftcore.udp_d_bill_type_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Find_Status_of_SQL_Server_Statistics.sql": { "update": 3, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 5, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 124, "complexity": "simple-medium" }, "Blocked_Session.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 5, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 49, "complexity": "simple-medium" }, "Database_Mail_Configuration.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 104, "complexity": "simple" }, "Index Breakdown.sql": { "update": 15, "delete": 0, "insert": 4, "flatten": 0, "row_number": 2, "rank": 6, "join": 17, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 698, "complexity": "medium-complex" }, "Get_SQL_Server_Backup_Directory.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 11, "complexity": "simple" }, "udprdsftcore.udp_d_taxonomy_rate_attachment_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_String_Search.sql": { "update": 2, "delete": 0, "insert": 4, "flatten": 0, "row_number": 8, "rank": 13, "join": 5, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 460, "complexity": "simple-medium" }, "IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql": { "update": 0, "delete": 1, "insert": 0, "flatten": 0, "row_number": 1, "rank": 0, "join": 0, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 79, "complexity": "simple" }, "dbo.sp_WhatsupQueryStore.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 32, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 553, "complexity": "medium-complex" }, "udprdsftcore.udp_d_group_x_fund_detail_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "DynamicallyGenerateDMAStatement.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 17, "complexity": "simple" }, "udprdsftcore.udp_d_diag_age_range_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Test_job.sql": { "update": 0, "delete": 2, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 88, "complexity": "simple" }, "tempdb_usage.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 64, "complexity": "simple-medium" }, "Get_SQL_Server_NUMA_Memory.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 5, "union": 6, "partition by": 0, "partitioned": 0, "line_of_code": 54, "complexity": "simple-medium" }, "PowerSavingCheck.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 51, "complexity": "simple" }, "dbo.sp_PrintString.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 94, "complexity": "simple" }, "udprdsftcore.udp_d_tenant_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "SQL_Server_Fixed_Role_Permissions.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 24, "complexity": "simple" }, "Get_Create_or_Alter_Index_Progress.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 47, "complexity": "simple" }, "udprdsftcore.udp_d_functional_area_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_DBA_Rename_Database.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 71, "complexity": "simple" }, "dbo.sp_helpExpandView.sql": { "update": 4, "delete": 0, "insert": 3, "flatten": 2, "row_number": 0, "rank": 0, "join": 6, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 455, "complexity": "medium" }, "dbo.sp_FailedJobs.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 70, "complexity": "simple" }, "Who_dropped_altered_database_object.sql": { "update": 0, "delete": 1, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 49, "complexity": "simple" }, "Partial_Restore_Demo.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 1, "line_of_code": 147, "complexity": "simple" }, "Which_databases_were_backed_up_and_when.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 79, "complexity": "simple-medium" }, "Restore_Database_Dynamic_SQL.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 21, "complexity": "simple" }, "When_SQL_Server_Was_Installed.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 24, "complexity": "simple" }, "Drop_all_objects_in_schema.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 104, "complexity": "simple-medium" }, "Queries_vulnerable_to_SQL_injection.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 24, "complexity": "simple" }, "Disabling_Jobs_Schedules.sql": { "update": 2, "delete": 1, "insert": 4, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 220, "complexity": "simple" }, "SQL Server 2016 Diagnostic Information Queries.sql": { "update": 22, "delete": 2, "insert": 9, "flatten": 0, "row_number": 4, "rank": 6, "join": 50, "union": 0, "partition by": 2, "partitioned": 0, "line_of_code": 1964, "complexity": "complex" }, "Auto_Generate_Database_Documentation.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 3, "partition by": 0, "partitioned": 0, "line_of_code": 185, "complexity": "simple" }, "udprdsftcore.udp_d_ansthsa_cost_factor_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Show all permissions in a database.sql": { "update": 2, "delete": 2, "insert": 5, "flatten": 0, "row_number": 0, "rank": 3, "join": 29, "union": 20, "partition by": 6, "partitioned": 0, "line_of_code": 542, "complexity": "medium-complex" }, "udprdsftcore.udp_d_prcdr_age_range_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_help_permissions.sql": { "update": 2, "delete": 2, "insert": 29, "flatten": 0, "row_number": 3, "rank": 2, "join": 33, "union": 28, "partition by": 4, "partitioned": 0, "line_of_code": 968, "complexity": "complex" }, "Compare_2_tables_by_column_names.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 31, "complexity": "simple" }, "udprdsftcore.udp_d_treatment_type_indicator_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_groups_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_Depends.sql": { "update": 1, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 153, "complexity": "simple" }, "dbo.sp_BenchmarkTSQL.sql": { "update": 2, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 14, "partition by": 0, "partitioned": 0, "line_of_code": 669, "complexity": "medium" }, "Queries_with_parallelism.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 1, "rank": 2, "join": 0, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 41, "complexity": "simple" }, "Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 1, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 33, "complexity": "simple" }, "Reseed_Identity_Column_Value_To_Last_Value.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 36, "complexity": "simple" }, "Using_OPENROWSET_to_Query_Excel.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 31, "complexity": "simple" }, "Code_Reuse_With_Dynamic_SQL_and_Temp_Procedures_Example.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 74, "complexity": "simple" }, "udprdsftcore.udp_d_geo_unit_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Get_Table_and_Index_Storage_Size.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 56, "complexity": "simple" }, "udprdsftcore.udp_d_submit_facilty_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "SQL Server 2016 SP2 Diagnostic Information Queries.sql": { "update": 37, "delete": 2, "insert": 6, "flatten": 0, "row_number": 4, "rank": 6, "join": 56, "union": 0, "partition by": 2, "partitioned": 0, "line_of_code": 1997, "complexity": "complex" }, "Table_Parameters.sql": { "update": 2, "delete": 1, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 16, "union": 0, "partition by": 0, "partitioned": 1, "line_of_code": 226, "complexity": "medium-complex" }, "dbo.sp_GenerateMerge.sql": { "update": 20, "delete": 6, "insert": 15, "flatten": 0, "row_number": 1, "rank": 0, "join": 8, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 670, "complexity": "medium-complex" }, "dbo.usp_CopyLogins.sql": { "update": 0, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 9, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 285, "complexity": "medium" }, "Monitor_Deadlocks_with_Extended_Events.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 60, "complexity": "simple" }, "Which_Filegroup_is_that_Partition_Using.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 9, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 47, "complexity": "medium" }, "MaxDop_2016_and_higher.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 116, "complexity": "simple" }, "udprdsftcore.udp_d_diagnosis_status_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Read_errorlog.sql": { "update": 1, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 108, "complexity": "simple" }, "udprdsftcore.udp_d_holiday_master_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_GenerateRandomPassword.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 104, "complexity": "simple" }, "Current_Running_Queries.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 5, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 65, "complexity": "simple-medium" }, "Check_Reserved_Words_For_Object_Names.sql": { "update": 2, "delete": 1, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 48, "complexity": "simple" }, "Recover_Deleted_Data_Proc.sql": { "update": 24, "delete": 20, "insert": 8, "flatten": 0, "row_number": 2, "rank": 0, "join": 27, "union": 11, "partition by": 0, "partitioned": 0, "line_of_code": 708, "complexity": "medium-complex" }, "Job_AG_Resume_Data_Movement.sql": { "update": 1, "delete": 4, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 129, "complexity": "simple" }, "udprdsftcore.udp_d_diagnosis_detail_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Visualizing_VLF.sql": { "update": 1, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 28, "complexity": "simple" }, "MisleadingSQLServerPerformanceCounters.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 34, "complexity": "simple" }, "udprdsftcore.udp_d_modifier_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_period_type_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Which_sp_configure_Options_Clear_the_Plan_Cache.sql": { "update": 1, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 50, "complexity": "simple" }, "dbo.sp_SQLskills_helpindex.sql": { "update": 2, "delete": 1, "insert": 3, "flatten": 0, "row_number": 1, "rank": 0, "join": 7, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 409, "complexity": "medium" }, "dbo.sp_SQLskills_ExposeColsInIndexLevels.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 191, "complexity": "simple" }, "Cached_Data_Per_Object_in_Memory.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "ShredDeadlockGraph.sql": { "update": 0, "delete": 0, "insert": 8, "flatten": 0, "row_number": 1, "rank": 2, "join": 6, "union": 0, "partition by": 3, "partitioned": 0, "line_of_code": 260, "complexity": "medium" }, "Extract_Scale_Part_From_Decimal_Number.sql": { "update": 0, "delete": 0, "insert": 5, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 22, "complexity": "simple" }, "dbo.sp_ChangeDatabaseOwnerShip.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 64, "complexity": "simple" }, "dbo.usp_SearchStoredProcedureText.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 91, "complexity": "simple" }, "GoogleJobTimeline.sql": { "update": 1, "delete": 0, "insert": 8, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 206, "complexity": "simple" }, "dbo.sp_ctrl3.sql": { "update": 5, "delete": 5, "insert": 21, "flatten": 0, "row_number": 8, "rank": 0, "join": 83, "union": 14, "partition by": 16, "partitioned": 0, "line_of_code": 1222, "complexity": "complex" }, "FindDBConnectionLeaks.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 44, "complexity": "simple" }, "Dynamic_GRANT_Generation.sql": { "update": 1, "delete": 1, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 35, "complexity": "simple" }, "Count character matches.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 9, "complexity": "simple" }, "udprdsftcore.udp_reference_association_status_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_drg_rate_factor_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_group_store_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Generate_Restore_Script_From_Backup_Folder.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 81, "complexity": "simple" }, "udprdsftcore.udp_d_dental_area_x_dental_area_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_holiday_exclusion_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "SQLServer_Memory_Information.sql": { "update": 4, "delete": 2, "insert": 8, "flatten": 0, "row_number": 0, "rank": 0, "join": 5, "union": 9, "partition by": 0, "partitioned": 0, "line_of_code": 377, "complexity": "simple-medium" }, "Databases_Report.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 74, "complexity": "simple" }, "dbo.usp_SQLskillsAnalyzeLog.sql": { "update": 5, "delete": 1, "insert": 12, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 271, "complexity": "simple-medium" }, "Get_Identity_Column_Information.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 7, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 88, "complexity": "medium" }, "What_Agent_Job_is_Running.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 50, "complexity": "simple" }, "udprdsftcore.udp_d_correct_code_initiative_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_estindex.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 13, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 877, "complexity": "medium-complex" }, "Jobs_Find_And_Replace_Text.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 117, "complexity": "simple" }, "Find_Synonyms_for_nested_objects_in_the_same_database.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 68, "complexity": "simple" }, "Trace_Flag_8726.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 28, "complexity": "simple" }, "dbo.sp_BlitzInMemoryOLTP.sql": { "update": 0, "delete": 18, "insert": 25, "flatten": 0, "row_number": 1, "rank": 0, "join": 34, "union": 1, "partition by": 2, "partitioned": 0, "line_of_code": 2046, "complexity": "complex" }, "udprdsftcore.udp_d_revenue_x_clm_type_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_indicator_option_x_specialty_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Trace_Flag_8727.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 38, "complexity": "simple" }, "dbo.usp_BulkUpload.sql": { "update": 0, "delete": 0, "insert": 11, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 298, "complexity": "simple-medium" }, "Configure_SQL_Agent_Alerts.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 13, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 344, "complexity": "medium-complex" }, "Sort_SQL_Server_Tables_into_similarly_sized_buckets.sql": { "update": 1, "delete": 0, "insert": 1, "flatten": 0, "row_number": 1, "rank": 0, "join": 5, "union": 0, "partition by": 3, "partitioned": 0, "line_of_code": 133, "complexity": "simple-medium" }, "Find_Object_Dependecy.sql": { "update": 25, "delete": 0, "insert": 53, "flatten": 0, "row_number": 0, "rank": 115, "join": 93, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2558, "complexity": "complex" }, "udprdsftcore.udp_d_length_of_stay_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_PrintDebug.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 46, "complexity": "simple" }, "Foreign_Key_batch_rename.sql": { "update": 0, "delete": 1, "insert": 0, "flatten": 0, "row_number": 1, "rank": 2, "join": 5, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 54, "complexity": "simple-medium" }, "Ring_Bufer_Analyze.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 36, "complexity": "simple" }, "Checkpoint_XE.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 50, "complexity": "simple" }, "Foreign_Keys_With_No_Index.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 7, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 29, "complexity": "medium" }, "udprdsftcore.udp_d_submit_facilty_span_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Selects_That_Cause_Writes.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 67, "complexity": "simple" }, "udprdsftcore.udp_d_unit_of_measurement_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Remove_Leading_and_Trailing_Backward_and_Forward_Slashes.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 15, "complexity": "simple" }, "Move_tempdb.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 61, "complexity": "simple" }, "Search_Script.sql": { "update": 2, "delete": 0, "insert": 25, "flatten": 0, "row_number": 0, "rank": 0, "join": 47, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 592, "complexity": "complex" }, "udprdsftcore.udp_d_region_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_EnableAndAddFileStreamForDatabase.sql": { "update": 2, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 96, "complexity": "simple" }, "Trace_Flag_3895.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 53, "complexity": "simple" }, "Get_Amazon_RDS_Instance_Size.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 37, "complexity": "simple" }, "dbo.sp_RestoreScript.sql": { "update": 2, "delete": 0, "insert": 5, "flatten": 0, "row_number": 4, "rank": 0, "join": 6, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 206, "complexity": "medium" }, "Uppercase_All_String_Columns.sql": { "update": 2, "delete": 0, "insert": 7, "flatten": 0, "row_number": 1, "rank": 1, "join": 4, "union": 0, "partition by": 1, "partitioned": 0, "line_of_code": 288, "complexity": "simple-medium" }, "Azure SQL Database Diagnostic Information Queries.sql": { "update": 12, "delete": 2, "insert": 0, "flatten": 0, "row_number": 4, "rank": 4, "join": 42, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 1261, "complexity": "complex" }, "Index_Creating_Info.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 45, "complexity": "simple" }, "dbo.sp_FailedLogins.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 53, "complexity": "simple" }, "udprdsftcore.udp_d_group_status_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Change_NonDefault_Collation_for_all_tables.sql": { "update": 5, "delete": 4, "insert": 14, "flatten": 0, "row_number": 0, "rank": 0, "join": 28, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 718, "complexity": "medium-complex" }, "Jobs_Get_Runing_info.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "GetResourceNameFromBlockedProcessReport.sql": { "update": 1, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 7, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 248, "complexity": "medium" }, "udprdsftcore.udp_d_program_x_modifier_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_treatment_type_detail_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_Dijkstra.sql": { "update": 5, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 117, "complexity": "simple-medium" }, "udprdsftcore.udp_roster_detail_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Tempdb_Contention.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 36, "complexity": "simple" }, "Sort_UID_Demo.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 15, "partition by": 0, "partitioned": 0, "line_of_code": 36, "complexity": "simple" }, "dbo.usp_UnusedInputParameters.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 146, "complexity": "simple-medium" }, "Get_Coulmn_Statistics_By_Name.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 49, "complexity": "simple" }, "Get_Opened_Transactions_Info.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 46, "complexity": "simple-medium" }, "Restore_script_for_Ola_Hallengren_backup.sql": { "update": 6, "delete": 1, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 218, "complexity": "medium" }, "FindTablesWithSimilarTableStructure.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 1, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 62, "complexity": "simple" }, "udprdsftcore.udp_d_diagnosis_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_group_ctgry_x_group_store_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_who5.sql": { "update": 20, "delete": 2, "insert": 11, "flatten": 0, "row_number": 0, "rank": 0, "join": 19, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 1651, "complexity": "complex" }, "SQL Server 2008 R2 Diagnostic Information Queries.sql": { "update": 17, "delete": 0, "insert": 7, "flatten": 0, "row_number": 4, "rank": 6, "join": 46, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 1403, "complexity": "complex" }, "Bad_Query_Example_13_JOINS.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 10, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 26, "complexity": "medium" }, "Enabling_Jobs_Schedules.sql": { "update": 2, "delete": 1, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 167, "complexity": "simple" }, "udprdsftcore.udp_d_group_category_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "SQL Server 2019 Diagnostic Information Queries.sql": { "update": 27, "delete": 0, "insert": 8, "flatten": 0, "row_number": 4, "rank": 6, "join": 55, "union": 0, "partition by": 4, "partitioned": 0, "line_of_code": 2069, "complexity": "complex" }, "DetermineSpaceWithinSQLDatabaseFiles.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 37, "complexity": "simple" }, "TuneYourIndexingStrategyWithDMVs.sql": { "update": 12, "delete": 2, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 20, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 231, "complexity": "medium-complex" }, "DBCC_CHECKDB_Latest_date.sql": { "update": 1, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 77, "complexity": "simple" }, "Build_CREATE_TABLE_statement_using_dm_exec_describe_first_result_set.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 76, "complexity": "simple" }, "SQL Server 2012 Diagnostic Information Queries.sql": { "update": 27, "delete": 0, "insert": 8, "flatten": 0, "row_number": 4, "rank": 6, "join": 52, "union": 0, "partition by": 2, "partitioned": 0, "line_of_code": 1790, "complexity": "complex" }, "Identify_All_Logins_With_No_Associated_Default_Database_User.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 76, "complexity": "simple" }, "BufferPoolExtension.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 61, "complexity": "simple" }, "dbo.sp_doc.sql": { "update": 0, "delete": 0, "insert": 85, "flatten": 0, "row_number": 0, "rank": 1, "join": 38, "union": 2, "partition by": 0, "partitioned": 0, "line_of_code": 1432, "complexity": "complex" }, "dbo.sp_capture_login_auth.sql": { "update": 0, "delete": 0, "insert": 5, "flatten": 0, "row_number": 1, "rank": 0, "join": 10, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 707, "complexity": "medium" }, "dbo.usp_Breadth_First.sql": { "update": 0, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 96, "complexity": "simple-medium" }, "Objects_Size_In_Database.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 31, "complexity": "simple" }, "Enable Microsoft.ACE.OLEDB.12.0.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 13, "complexity": "simple" }, "udprdsftcore.udp_d_program_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_PerfSQ.sql": { "update": 1, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 14, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 529, "complexity": "medium-complex" }, "dbo.usp_generateIdentifier.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 91, "complexity": "simple" }, "Space used by object.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 74, "complexity": "simple" }, "udprdsftcore.udp_d_taxonomy_rate_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.udp_IntegerListfromRanges.sql": { "update": 0, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 83, "complexity": "simple" }, "udprdsftcore.udp_d_clsfctn_desc_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_sizing.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 220, "complexity": "simple-medium" }, "Job_AG_Failover_Detected.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 39, "complexity": "simple" }, "Get_SQL_Server_Agent_Information.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 30, "complexity": "simple" }, "udprdsftcore.udp_d_group_x_group_store_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_bcpUnloadSelect.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 78, "complexity": "simple" }, "Numbers_DATALENGTH.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 17, "complexity": "simple" }, "udprdsftcore.udp_d_modifier_crosswalk_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_diag_related_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Count_Database_Reads_and_Writes.sql": { "update": 2, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 30, "complexity": "simple" }, "dbo.usp_CreatePlantUMLCode.sql": { "update": 0, "delete": 0, "insert": 4, "flatten": 0, "row_number": 0, "rank": 0, "join": 14, "union": 4, "partition by": 0, "partitioned": 0, "line_of_code": 248, "complexity": "medium-complex" }, "udprdsftcore.udp_d_drg_rate_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Visualizing_Agent_Jobs_in_SSMS.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 1, "join": 1, "union": 2, "partition by": 0, "partitioned": 0, "line_of_code": 120, "complexity": "simple" }, "Security_Audit_Report.sql": { "update": 0, "delete": 1, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 13, "union": 2, "partition by": 0, "partitioned": 0, "line_of_code": 273, "complexity": "medium-complex" }, "dbo.usp_Prim.sql": { "update": 5, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 3, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 101, "complexity": "simple-medium" }, "Disable_Enable_All_Triggers_In_Database.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 44, "complexity": "simple" }, "dbo.usp_Generate_Merge.sql": { "update": 20, "delete": 6, "insert": 15, "flatten": 0, "row_number": 1, "rank": 0, "join": 8, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 639, "complexity": "medium-complex" }, "How_to_Find_Queries_Using_an_Index.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 6, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 122, "complexity": "medium" }, "Shredding_XML_Data_From_Extended_Events.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 7, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 129, "complexity": "medium" }, "Create_JOIN_Query_Between_Multiple_Tables_Dynamically.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 8, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 73, "complexity": "medium" }, "FindLongRunningJobSteps.sql": { "update": 0, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 6, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 101, "complexity": "medium" }, "udprdsftcore.udp_d_relative_value_unit_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.usp_GetPackageDetails.sql": { "update": 36, "delete": 4, "insert": 39, "flatten": 0, "row_number": 8, "rank": 9, "join": 31, "union": 3, "partition by": 8, "partitioned": 0, "line_of_code": 1505, "complexity": "complex" }, "udprdsftcore.udp_d_diagnosis_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Temporal_Table_Maker.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 157, "complexity": "simple" }, "udprdsftcore.udp_d_reference_additive_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "How_to_obtain_the_deadlocks_on_Azure.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 19, "complexity": "simple" }, "Bufer_Cache_Info.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 18, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 193, "complexity": "medium-complex" }, "Stop_long-running_SQL_Server_Agent_Jobs.sql": { "update": 0, "delete": 2, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 76, "complexity": "simple" }, "udprdsftcore.udp_d_durable_medical_equipment_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "WhiteListIPTable.sql": { "update": 1, "delete": 0, "insert": 1, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 59, "complexity": "simple" }, "SQL Managed Instance Diagnostic Information Queries.sql": { "update": 15, "delete": 2, "insert": 6, "flatten": 0, "row_number": 4, "rank": 6, "join": 48, "union": 0, "partition by": 2, "partitioned": 0, "line_of_code": 1675, "complexity": "complex" }, "dbo.sp_ns_shrink_db_log.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 123, "complexity": "simple" }, "udprdsftcore.udp_d_modifier_detail_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "SQL Server 2014 Diagnostic Information Queries.sql": { "update": 24, "delete": 0, "insert": 8, "flatten": 0, "row_number": 4, "rank": 6, "join": 55, "union": 0, "partition by": 2, "partitioned": 0, "line_of_code": 1865, "complexity": "complex" }, "dbo.sp_sqltrace.sql": { "update": 12, "delete": 2, "insert": 5, "flatten": 0, "row_number": 1, "rank": 0, "join": 2, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 611, "complexity": "medium-complex" }, "udprdsftcore.udp_d_facility_prvdr_rate_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "Read_Error_Log_File.sql": { "update": 2, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 125, "complexity": "simple" }, "udprdsftcore.udp_d_specialty_x_group_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "FindingSpecificColumns.sql": { "update": 1, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 76, "complexity": "simple-medium" }, "Generate_table_definition_to_match_query.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 27, "complexity": "simple" }, "udprdsftcore.udp_d_sbmt_fclty_bill_clsfctn_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_RestoreGene.sql": { "update": 2, "delete": 0, "insert": 0, "flatten": 0, "row_number": 2, "rank": 0, "join": 49, "union": 9, "partition by": 0, "partitioned": 0, "line_of_code": 1005, "complexity": "complex" }, "dbo.usp_TransliterationEN2RU.sql": { "update": 0, "delete": 0, "insert": 5, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 9, "partition by": 0, "partitioned": 0, "line_of_code": 317, "complexity": "simple" }, "Wait_Statistics_Snapshot.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 4, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 74, "complexity": "simple-medium" }, "udprdsftcore.udp_d_facility_type_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_dental_area_type_association_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_drg_indicator_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_group_rate_attachment_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_drg_pricing_exception_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_drg_detail_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "udprdsftcore.udp_d_modifier_status_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" }, "dbo.sp_Blocked_Process_Report_Viewer.sql": { "update": 0, "delete": 0, "insert": 5, "flatten": 0, "row_number": 0, "rank": 0, "join": 5, "union": 1, "partition by": 0, "partitioned": 0, "line_of_code": 316, "complexity": "simple-medium" }, "Decrypt T-SQL module.sql": { "update": 0, "delete": 0, "insert": 0, "flatten": 0, "row_number": 0, "rank": 0, "join": 1, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 139, "complexity": "simple" }, "Trace_Flag_1165.sql": { "update": 0, "delete": 0, "insert": 3, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 63, "complexity": "simple" }, "Date_Calendar_Cross-Reference_Table.sql": { "update": 12, "delete": 0, "insert": 2, "flatten": 0, "row_number": 5, "rank": 0, "join": 7, "union": 1, "partition by": 5, "partitioned": 0, "line_of_code": 391, "complexity": "medium-complex" }, "udprdsftcore.udp_d_bill_classification_transformation.sql": { "update": 2, "delete": 0, "insert": 2, "flatten": 0, "row_number": 0, "rank": 0, "join": 0, "union": 0, "partition by": 0, "partitioned": 0, "line_of_code": 2, "complexity": "simple" } } } 2023-07-14 21:18:30,887 | INFO | 54: Final Data frame : Feed Type File Name update ... partitioned line_of_code complexity 0 pig limit.pig 0 ... 0 9 simple 1 pig order-by.pig 0 ... 0 12 simple 2 pig multi-delimiter.pig 0 ... 0 9 simple 3 pig distinct.pig 0 ... 0 9 simple 4 pig lookup.pig 0 ... 0 14 simple .. ... ... ... ... ... ... ... 495 sql dbo.sp_Blocked_Process_Report_Viewer.sql 0 ... 0 316 simple-medium 496 sql Decrypt T-SQL module.sql 0 ... 0 139 simple 497 sql Trace_Flag_1165.sql 0 ... 0 63 simple 498 sql Date_Calendar_Cross-Reference_Table.sql 12 ... 0 391 medium-complex 499 sql udprdsftcore.udp_d_bill_classification_transfo... 2 ... 0 2 simple [500 rows x 14 columns] 2023-07-14 21:18:31,120 | INFO | 80: Feed Type : pig , Total Scripts : 17 , simple : 16 , 'simple-medium' : 1, Medium :0 , Medium-complex: 0, complex :0 2023-07-14 21:18:31,130 | INFO | 80: Feed Type : py , Total Scripts : 97 , simple : 94 , 'simple-medium' : 1, Medium :1 , Medium-complex: 1, complex :0 2023-07-14 21:18:31,140 | INFO | 80: Feed Type : txt , Total Scripts : 1 , simple : 1 , 'simple-medium' : 0, Medium :0 , Medium-complex: 0, complex :0 2023-07-14 21:18:31,151 | INFO | 80: Feed Type : R , Total Scripts : 2 , simple : 2 , 'simple-medium' : 0, Medium :0 , Medium-complex: 0, complex :0 2023-07-14 21:18:31,162 | INFO | 80: Feed Type : xml , Total Scripts : 2 , simple : 0 , 'simple-medium' : 0, Medium :1 , Medium-complex: 0, complex :1 2023-07-14 21:18:31,173 | INFO | 80: Feed Type : sh , Total Scripts : 5 , simple : 5 , 'simple-medium' : 0, Medium :0 , Medium-complex: 0, complex :0 2023-07-14 21:18:31,184 | INFO | 80: Feed Type : sql , Total Scripts : 376 , simple : 268 , 'simple-medium' : 29, Medium :30 , Medium-complex: 20, complex :29 2023-07-14 21:18:31,272 | INFO | 104: No hidden files