🔥

Mikael Weaver mikaelweave

🔥

Software Engineer in Healthcare at Microsoft

mikaelweave / add_column_if_not_exist.sql

Created July 15, 2015 22:29

Add column if it doesn't already exist

	IF EXISTS (
	SELECT *
	FROM sys.columns
	WHERE object_id = OBJECT_ID(N'[dbo].[Person]')
	AND name = 'ColumnName'
	)
	ALTER TABLE dbo.Person
	ADD ColumnName VARCHAR(64)

mikaelweave / SQL Stats.sql

Created September 22, 2015 06:20

Two liners to enable SQL Stats for your query/session

	SET STATISTICS IO ON;
	SET STATISTICS TIME ON;

mikaelweave / index_last_rebuilt.sql

Created November 5, 2015 16:50

This is a collection of SQL scripts that will give you some information about your indexes.

	DECLARE @tableName VARCHAR(256);
	SET @tableName = 'dbo.ct_pstor';

	SELECT name AS Stats,
	STATS_DATE(object_id, stats_id) AS LastStatsUpdate
	FROM sys.stats
	WHERE object_id = OBJECT_ID(@tableName)
	and left(name,4)!='_WA_';

mikaelweave / drop_sql_index_if_existst.sql.sql

Created November 18, 2015 16:57

Drop Index if it already exists

	IF EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME ='indexname')
	DROP INDEX indexname ON SCHEMA.tablename;

mikaelweave / connect_to_databaseps1.ps1

Created February 1, 2016 16:54

Database Connection Powershell snippits

	function Invoke-SQL {
	param(
	[string] $dataSource = $(throw "Please specify a datasource."),
	[string] $database = $(throw "Please specify a database."),
	[string] $sqlCommand = $(throw "Please specify a query.")
	)

	$connectionString = "Data Source=$dataSource; " +
	"Integrated Security=SSPI; " +
	"Initial Catalog=$database"

mikaelweave / row_rank_sql_example.sql

Last active March 15, 2016 17:18

Examples on how to use row_number and rank

	SELECT
	ROW_NUMBER() OVER (ORDER BY ct_id) AS row_num,
	ROW_NUMBER() OVER (PARTITION BY source_id ORDER BY ct_id) AS partitioned_row_num,
	RANK() OVER (ORDER BY ct_id) AS row_num,
	RANK() OVER (PARTITION BY source_id ORDER BY ct_id) AS partitioned_row_num
	FROM
	ct_pstor

mikaelweave / lowercase_guids

Created June 10, 2016 14:49

Sublime Text Search/Replace Hacks

mikaelweave / reinstall-package

Created June 29, 2017 19:51

nuget commands

update-package Newtonsoft.Json -reinstall

mikaelweave / DropDownListFor Enum

Last active November 9, 2017 16:49

Drop Down List Split Enums

	@Html.DropDownListFor(model => model.Status, Status.GetValues(typeof(Status)).Cast<Status>().Select(v => new SelectListItem
	{
	Text = WebAdministration.Classes.Helpers.SplitCamelCase(v.ToString()),
	Value = ((int)v).ToString()
	}).ToList(), new { @class = "form-control" })


	/// <summary>
	/// Takes a camel case string and splits it
	/// </summary>

mikaelweave / Default AJAX Get

Last active November 9, 2017 16:49

Default Ajax

	$.ajax({
	contentType: 'application/json',
	dataType: 'html',
	type: 'GET',
	async: true,
	cache: false,
	url: url,
	success: function(result) {
	},
	error: function() {