SQL Dumping Ground
Tuesday, 22 September 2015
Query all SQL DB sizes
›
Original source here with fs as ( select database_id, type, size * 8.0 / 1000 size from sys.master_files ) select name...
Wednesday, 29 July 2015
Stored Procedure that disables failing Server Agent Jobs
›
I had a problem, I had a lot of development jobs that ran overnight, when they failed I got an email advising me of this. Then they faile...
Thursday, 4 June 2015
Script to iterate through all selected columns in two databases
›
Script that does a distinct count and comparison of all columns and all tables across two databases --list of fields to check, using a tab...
Friday, 20 February 2015
TSQL Stored Procedure to disable failing jobs
›
Procedure to disable failing jobs and email an alert when this happens
Thursday, 22 January 2015
SQL Pivot and Stuff
›
Query to pivot and stuff information to show all values
Thursday, 8 January 2015
SQL Claims Triangles
›
Insurance claims triangles, getting the latest outstanding amount and the total amount paid Includes Temporary Tables Updating tables ...
SQL Earned Premiums for Triangulations
›
Query to generate earned premiums, working based off the latest of either the entry date or the inception date Contains Temporary Table...
Home
View web version